Author Archives: Redakteur

Banner Calendar 2020

2020 Full Year Calendar Excel Template

With Excel, not only tables and formulas can be calculated, but the program can also be used for design purposes. As for example for the representation of calendars of any kind. Here you will find various annual calendars for 2020.

On a usual “Letter” page, 12 months are clearly divided into three rows and four columns. To make the individual months and days of the week easier to read, they have been highlighted in colour (blue, orange or green). There is something for every taste.

Continue reading

Password Generator

Surely you haven’t missed out on the fact that meanwhile everything possible is to be secured with a password. And of course it must always be a new one, so that in the event of a data leak, hackers cannot log on to other services with the password they got.

Who makes the mistake and chooses a password, which appears in the following list, should not be surprised if his account is hacked.

Here are the Top-20:

Continue reading

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

Banner Calendar 2020 Excel

Monthly Calendar 2020

In this article I offer you a monthly calendar for 2020 as Excel template and as PDF for free download. As always you can download this template without registration or login.

The calendar consists of 12 Excel worksheets (or registers), one for each month. In the lower part, you can make a few important comments in the Notes section.

In contrast to my weekly or annual calendar, there is more or less space here. If you like it more detailed, you should go back to the calendar in the weekly view.

Continue reading

Editorial Planner 2020

For 2020 the following editorial planner has been created with Excel.

As always free of charge and downloadable without registration. Download the corresponding file below (either as a normal Excel file or the Excel template file) and open it with your Excel program. The free alternative OpenOffice should also be able to handle the templates.

After opening, you will find a main worksheet in which all months from 2020 are already prepared with the respective days and holidays. Now you can coordinate tasks, campaigns, authors, news, blog entries, contributions for Facebook, Twitter etc. in the columns next to it.

All in all, a comprehensive marketing plan for the coming year.

Continue reading

Weekly Planner 2020

You want to plan every day of the week for 2020 with Excel? No problem with this free calendar as Excel template.

Each week is created as a Letter 8,5×11 sheet and can be printed out separately or (if you prefer it analogous) completely for the whole year. Of course one can lead its week-planning with Excel.

Meanwhile there is the possibility to use Excel on your smartphone or tablet. If you store the weekly planner centrally in the cloud, you can use your PC, smartphone or tablet to access the same file and always have an overview.

At excel-template.net there is also a universal weekly planner without date. You can find it here.


If you are not so familiar with Excel, you can also download the weekly calendar as a PDF file and print it out. Continue reading

Vacationplanner 2020

The holiday planner for the current year (2019) has proved to be extremely popular and of course the holiday calendar for 2020 should not be missing! That’s why I’ve already started to create it.

A holiday planner is extremely helpful.

On the one hand, it helps the company or a department to make sure that someone always holds the position and that not all employees are suddenly on holiday. Well, there can always be cases of illness, but this is another construction site ?

On the other hand, a timely blocking of the own vacation can ensure that one uses his vacation days efficiently: Thus one can make by consideration of the holidays with 8 days 2 weeks vacation. As for example with use of Good Friday and Easter Monday.

The new template for holiday planning 2020

In the last Excel files for the planning of the holidays, I have also taken the following year into account in order to guarantee planning beyond the turn of the year. This is also the case in the current planner.

Continue reading

Break-Planner with excel

There can be a break schedule for different purposes

  • for the break planning of employees of a department, where always a person must be present, e.g. in order to ensure the telephone contact of customers, and
  • for the recording of break times for employees and workers who take their breaks themselves but have to record them.

For these 2 purposes I have prepared different break schedules in Excel, which hopefully will be useful for future break planning.

Screenshots of the break-planner for employees to plan and record breaks

Continue reading

Binder label template with excel

2019 has just started and this is a good opportunity to create new folders for documents and to clean out the old ones.
Labelling the back of the folder is a very difficult task. If you just try it by hand, it usually doesn’t look good. Especially if you put several folders next to each other, it doesn’t look professional and correct.
That’s why I created these templates: Signs and labels that you can glue to the folders.
Simply download the corresponding template, change the text (date and area of use), print it out and cut it out with scissors.
And you have already realized a great and neat labeling of your folders!

Screenshots of the label-template for folder and binder

Continue reading

Monthly Calendar 2019

2019 is coming quickly, so I prepared the monthly calendar for the next year. By the way you can download the yearly or the weekly calendar 2019, too.

This calendar will help you to plan your month day by day. I’ve made an excel-file, an excel-template-file and a Pdf. So even people without the software can use it. For Pdf you can use the free Adobe Reader for open and then print it.

The calendar is great to accomplish your goals and plan your holidays.

Continue reading

2019 Full Year Calendar Microsoft Excel Template

How time runs by, I totally forgot about the calendar 2019!

The “2019 Full Year Calendar” features 12 sheets and is offered in 3 colors: Green, blue and black-and-white. The 12 sheets belong to every month and have also a place where you can write down some notes. You can put your deadlines in the excel-cells and plan your schedules for business or private.

You can print out the calendar and fill the data per hand for sure.

If your aren’t able to use Excel, I have prepared a pdf for download, too.

Have a peek at screenshots from the 2019 Full Year Calendar in three different colors:

Continue reading

Weekly Planner 2019

You want to plan every day of the week for 2019 with Excel? No problem with this free calendar as Excel template.

Each week is created as a Letter 8,5×11 sheet and can be printed out separately or (if you prefer it analogous) completely for the whole year. Of course one can lead its week-planning with Excel.

Meanwhile there is the possibility to use Excel on your smartphone or tablet. If you store the weekly planner centrally in the cloud, you can use your PC, smartphone or tablet to access the same file and always have an overview.

At excel-template.net there is also a universal weekly planner without date. You can find it here.


If you are not so familiar with Excel, you can also download the weekly calendar as a PDF file and print it out. Continue reading

Vacationplanner 2019

Holidays for 2019 are still a long way off, but some companies need to plan for the long term to avoid understaffing. For this case, I have updated the vacation planner 2018 to 2019.

Update: There is a new planner for 2020.

Unlike the last vacation plan, this time there are three instead of two worksheets. Two for the year 2019 and one for the first six months of 2020. Thus, the holidays for the New Year or New Year can also be recorded immediately.

On the first two worksheets you will find 6 months each with the individual days of the week and room for 7 employees. You can print the sheets and mark with color or characters (for example, a cross or a dash) on which days which employee is on vacation. 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