Lists for every purpose

Lists-templates for Excel.
Banner book-inventory

book collection list

You like to read and read often? Then you certainly (just like me) have a large stock of books and like to lose the overview. Exactly for this case I have created an Excel template, which should remedy the situation:
Enter all your books in one file in a book list!

You can note the following:

  • Book title,
  • author,
  • genre,
  • purchase date,
  • price,
  • reading status,
  • Media type (eBook, book, audio book),
  • Description or own opinion to the book.

To make capturing even easier, the Genre, Media Type and Status areas are provided with a drop-down menu. This allows you to easily select the appropriate entry.

Personally, the list is particularly important to me for the book titles that I read electronically or with my Kindle. Since I don’t hold them in my hand analogously, it’s hard for me to make a reference to them. Again and again I find myself hesitant when searching for new reading material, whether I already know the book or not. With normal books this does not or only rarely happen to me.

Screenshots of the book-collection for Excel

Booklist Excel

Your booklist overview

Master data of booklist

Define your master-data

Dropdownlist

For some cells the content can be chosen from a list

Continue reading

Moving Checklist with Excel

You have to move to a new house or flat? You can quickly panic and forget something!

Here are some key points of the checklist for a move:

  • Signing the lease of the new apartment (and making sure that the landlord has also drawn against effective tenancy agreement)
  • cancel old apartment (by registered letter with acknowledgment of receipt)
  • It is best to inform of your moving the landlord in advance (optional)
  • If you would like to have compensation payments for kitchen or installations, you should announce this urgently before
  • Clarify renovation conditions with landlord (so that there are no surprises during the transfer)
  • Organize relocation with moving company
  • Commission service providers or obtain offers
  • Or organize the moving yourself (with friends, acquaintances, family for a specific time)
  • Pack boxes
  • Clear the basement (and other things too?). There are Facebook groups to give or sell for your home and surroundings.
  • Schedule renovations with craftsmen or create a timetable for the work, if you do it yourself – maybe even submit a holiday?
  • Make a holiday request for moving day(s)
  • Reading of your meter readings (gas, electricity)
  • Unsubscribe from gas, electricity and water suppliers
  • Re-registration of Telekom and Internet
  • Registration at the old / new place of residence
  • Registration of utility service providers at the new place of residence
  • Change your address at the local post-office
  • Take measurements from your new rooms
  • Take care of your kids – organize school records

On the whole so much work!

Continue reading

Insurance Management with Excel

Every one of us has insurance contracts. Depending on your country there are many types of insurance:

  • health insurance
  • pension insurance
  • car insurance
  • liability insurance
  • social insurance
  • accident insurance
  • disability insurance
  • life insurance
  • house insurance
  • even insurance for funeral expenses already exists

With so many insurance and associated companies, it’s no wonder that you quickly lose track.

To improve the overview, this template was created. Simply enter the type of insurance, type, provider, closing date, agent or consultant, number, duration and method of payment and costs. Under remarks, you can still record in which folder you keep the documents.



Preview of your personal insurance contract management with excel

Continue reading

Wine-Cellar Inventory-Management

A wine cellar is something very special. Anyone who deals intensively with the subject of wine, whose wine stock will become larger and larger in a short time. Quickly comes the question, how to manage a private wine cellar best?

My research showed that there are three groups of wine lovers and collectors:

  • The old-fashioned collector writing down everything in a pretty book.
  • The old fashioned IT affine who creates an Excel spreadsheet or even Access database and
  • the modern enthusiast with a large collection of wines that relies on professional and expensive software.

Who counts to point 1 can fall back here on a beautiful book.

Modern software is available from these providers:

And the rest will be happy with the following template for managing your private wine-cellar 🙂



Preview of the wine-cellar-inventory with excel

Continue reading

Company-Visitor-List

The company-reception, porter or security has to record who, when and for how long a visitor stays in the company, the museum or another institution. Therefore a company-visitor-list is very helpful I think. so I build one 😉

It’s really simple. Download the excel-sheet or pdf, print it out and fill it out each time a visitor is coming to your company or institution. Don’t forget to let it sign by that guest.



Preview of the company-visitor-list

Continue reading

Password-List for Excel

A reader of the newsletter asked me for an Excel template for the collection of passwords for the numerous websites, which now demand all name and password.

Since you can easily lose the overview.

For those who do not want to work with Excel, there are also ways to manage the passwords through a browser extension.

In the normal version, LastPass is recommended. This is free and easy to set up in the browser. Just create an account and get started:

https://lastpass.com/misc_download2.php

For professional handling I recommend 1Password. Here you install a stand-alone program, which can be used to manage all passwords:

  • Credit card information,
  • notes
  • Passwords and
  • Software licenses.

A generator for the creation of passwords is also on board. Of course, there is also an extension that integrates directly into the browser. Unfortunately this tool costs something. I was lucky to get a normal license with a one-time payment. Meanwhile, the company relies on monthly fees of $ 2.99.
(Why does every company have to switch to this type of payment?) 🙁

https://1password.com/downloads/

Since passwords are normally not to be encrypted as files in the computer, it is advisable to encrypt the file. Why? Because more and more computers are being spyed by viruses or Trojans. An open file with passwords is an ideal gateway for even more damage!

So if you later load your Excel template, save it with encryption. On the one hand via the encryption of Microsoft Excel, on the other hand by protection with Windows Bitlocker. See the following list for instructions.

But now go to the actual Excel template for a list of passwords. Continue reading

Telephone Notes as Excel Template

A few days ago somebody asked me for a telehone-notes-template. Thanks for that hint! I could swear I did that template already, but I didn’t.

So here we go with a telephone message template. It is free and easy to handle. Just download it, open with Excel or Adobe Reader (PDF) and print it. Now you can put that sheet right to your phone and you won’t forget about what to ask during the phone-call.

Continue reading

Ticket Sales Tracker MS Excel Template

Have you ever hosted and managed an event where tickets are sold for participants? You can always outsource the job or use some online service, but for small events that are hosted by a family or a family run small business, it is in many cases better to keep it local and handy. Our Ticket Sales Tracker free Microsoft Excel template helps you to easily track different types of sold tickets and the resulting income.

The Ticket Sales Tracker MS Excel template enables you to set different costs for different types of tickets including Adult, Child and Discounted and will automatically show you the total number of sold tickets and the total resulting income.

 Have a peek at screenshots from the Ticket Sales Tracker Excel Template:

Continue reading

Employee Absence Tracking Template

Every company, whether it has 5 or 5 thousand employees, needs to track the absence and availability of its personnel. This enables the company to pay its employees fairly, avoiding any disputes, and keep record of their overall performance and availability over time.

There are many software out there that streamline this process for the human resource department of middle to enterprise-sized companies, but these solutions are expensive and add too much complexity and overhead. Small business owners and startups with a few employees need a simple and effective way to keep track of their employees’ absence and this is why we publish this week the free Employee Absence Tracking Calendar Microsoft Excel template.

Continue reading

Birthday List Template

Birthday List MS Excel Template

Remembering the birthday of every friend, family member and sometimes even co-workers is quite difficult and can get out of hand. You can keep it to social media like Facebook which help you greatly to keep up with a growing network of friends, but not everybody is on Facebook and there are those who you may wish to give a special treatment at their birthdays. In some smaller working environments, it is seen as rude or unsocial to forget a colleague’s birthday.

This week, to equip you with the necessary tools to keep up to the task, we introduce the Birthday List Free Microsoft Excel template.

Have a peek at screenshots from the Birthday List Excel Template:

Birthday List Excel Template Continue reading

Monthly Household Budget Microsoft Excel Template

Monthly Household Budget MS Excel Template

The Monthly Household Budget free template, helps you to set up your monthly budget professionally, without the need to seek out professional help. Don’t let the easy to use and friendly user interface fool you. It is fully packed with tons of functionalities. In fact, if you are planning to buy a car, save for your retirement, or just want to keep track of how you (or anyone else for that matter) spend your hard-earned money over the month, this free Excel template is one of the easiest and most functional options out there.

Have a peek at screenshots from the Monthly Household Budget Excel Template:

Monthly Household Budget Planner Continue reading

Budget-Planner for College Students

College has almost started and so I had the idea to make a budget-planner for college-students with an excel-template.

My own studies are long ago and everything seems to be more expensive now. No good news for parents who want to support their children with payments for the college. But how much does it really cost? What expenses are there? Continue reading

Mortgage Excel-Template

This excel-template calculates your mortgage. Just fill out the left side on top of table and the rest will calculated automatically.

For everyone planning to buy a house or flat, this is a really important calculation. Don’t be to optimistic with your financial income. What if you lose your job, what if you have to sell the house because you have to move to another place because of your work? To do you have some extra-money for some unexpected repairs? Don’t forget, that you might need some money for an illness or operation. What about making holidays or paying the college for the children.

There are many aspects that should be respected – but to be honest – an own house is fantastic 🙂

So here is the Excel-Template for the mortgage-calculation: Continue reading

Diet Plan as Excel Template

Do you want to lose weight or just maintain records of what you have eaten per week or you are planning to eat? Then this diet plan Excel template is just right for you. Either print the Excel template and write by hand all the foods or do it directly in Excel. Keep track of your eating habits and do not forget to enter everything 🙂

Have a look at the screenshot of the diet plan excel template

Diet plan Excel template


Diet plan Excel template

Download the diet plan template for free





Here you may find this template in different file formats (.xls, .xlsx, .xltx, and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a zip file.

More diet plan templates in the network

A little research showed that there are other good diet plan templates to download:

Software List as Excel Template

This time I offer you one more list as Excel template. This template will help you catalogue your software, keep track of your software licenses, registration numbers, user names, passwords and Internet addresses. However, the user name is not always important for the software catalog; Adobe software is directly connected to a user name or e-mail address. Other software online services, such as Dropbox, work by sending an e-mail and password combination.

As usual, you can download this Excel template free of charge.

Have a look at the screenshot of the software list excel template

Your software list Excel template


Your software list Excel template

Download the software list template for free





Here you may find this template in different file formats (.xls, .xlsx, .xltx, .pdf and zip). Please, the users of Internet Explorer should pay attention to the fact that direct download of .xls files may fail to function in your browser, that’s why you have to choose a .pdf or zip file.

[give_form id=”853″]

More software list templates in the network

A little research showed that there are other good software list templates to download: