Time Management With Excel

Got your time under control! With these useful templates it will be easy for you – try it out!

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

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

Transfer excel-list for out of office replacement

In addition to the holiday planner, an out of office list for holiday replacement is also very useful. With this template, you can record all the important things to do during your absence.

In addition, you give your representation the possibility of recognizing via the transfer list

  • what the project status is,
  • how the contacts are called and how best to reach them.
  • Which meetings visited and
  • which deadlines have to be met.
  • As the access data are and
  • whether a key handover is necessary.

Continue reading

Vacationplanner 2018

Just like last year I offer my vacation-planner 2018 for free.

Update: There are new planner for 2019 and 2020.

The use of this planner is simple. Choose the cells from the employee who’s going to be on vacation and mark them with a background-color.

You can just make “x” instead or print it out blank and mark it with a pencil or crayon. No problem 🙂

Continue reading

Vacationplanner 2017

Just like last year I offer my vacation-planner 2017 today for free. I’m sorry that it took so long. I just forgot about it and made other excel-templates instead.


Update: There are new planner for 2018, 2019 and 2020.


Here we go with the vacation-planner 2017. As you can see in the next picture you get an overview for your employees when there are on vacation or on duty. Just activated the cell and format it with a color (I use darkgreen here).

Continue reading

2017 Monthly Calendar Template – 3 Styles

No full year calendar goes without a matching monthly calendar and after publishing the 2017 Full Year Calendar MS Excel template, we decided to follow with monthly calendars. But this time, we are featuring 3 styles of this free Excel template in just one post: The light, the bold, and the wall styles. While all these templates have the same functionality, the appearance and visual designs are quite different and appropriate for distinct occasions. Needless to say that all of the 3 templates are ready for print.

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

Class Scheduler Excel Template

Class Scheduler MS Excel Template

Keeping up with one’s schedule in school is essential, not only in receiving a decent education and the first building blocks for life, but also in learning discipline and getting organized. Years ago, I remember when visiting school, we had those nice tables and spreadsheets on the back or inside of the cover of our notebooks and every semester I filled it with my new class schedule.

Continue reading