Have a plan – Excel helps

Templates for Excel for planning nearly everything: Your wedding, your holiday and many more!

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

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

Football World Cup 2018 Playing Schedule

This summer is a special event in the house: The Football World Cup 2018! This time in Russia – but without Italy. For real football enthusiasts (Italians) a real disgrace.

But if Peru should fall out, Italy can move up!

Click on the button to load the content from www.thesun.co.uk.

Load content

Well, all speculative – so we prefer to dedicate ourselves to the Excel templates. This time a template to capture the game results. Of course, you can also use the template as a game board to see who plays.



Preview of the football-world-championchip playing schedule

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

2018 Full Year Calendar Microsoft Excel Template

Wow, how time runs by, I totally forgot about the calendar 2018!

The 2018 Full Year Calendar features 12 sheets. These 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.

Have a peek at screenshots from the 2018 Full Year Calendar Excel Template:

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

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

Trip Planner – Summer Break MS Excel Template

 

The Trip Planner (Summer Break) free MS Excel template is a specialized trip planner template that is tailored for a summer break. Whether you are a group of friends or a family, if you plan to go to the sea, surfing, or sailing, the Trip Planner (Summer Break) Excel template will make planning fun and easy. It helps you estimate the costs and avoid surprises.

Needless to mention that this free MS Excel template is as always print-ready.

Have a peek at screenshots from the Trip Planner – Summer Break Excel Template:

Continue reading