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

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

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

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

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

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

Step by Step Idea Planner Template

Having a great idea is good and brainstorming is always necessary to shape an idea and make it work. But in the fast-evolving environment of today’s markets, it is also necessary to approach a good idea with a great plan. Our free Step by Step Idea Planner MS Excel template helps you to do just that. It helps you to solve the problem methodically by first describing your objectives and goals, setting a due date, detailing the necessary steps involved, and then assigning the tasks to different individuals. It has also a resource list where you can consolidate all the external resources you and your team are using for this project so that you have a better overview and access to them.

This free Excel workbook is, while highly functional, is very easy to work with and features a minimalistic design and appearance. All in all, it takes a minimal time to learn how it works and will be productive and efficient from the start. It is also print-ready and can be printed with one click.

Have a peek at screenshots from the Step by Step Idea Planner Excel Template:

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

Basic Invoice Template

The Basic Invoice free MS Excel template is a visually pleasant and print ready workbook for creating invoices. Being a basic invoice template isn’t something to be ashamed of. Quite to the contrary, this is the most valuable virtue of this Excel template. It saves time and nerves and helps you manage your finances.

 Have a peek at screenshots from the Basic Invoice Excel Template:

Continue reading

Activity Log Template

Free Excel templates are great, but they are not great enough if they don’t help to improve our health.

According to the American Heart Association, one should have at least 150 minutes of moderate activity each week. This can also be substituted with 75 minutes of vigorous activity per week. The Amercian Heart Association continues that physical activity boosts mental wellness, improves physical health, and prolongs one’s optimal health and life.

This time, we’ve come up with another brand new free Excel template that not only pleases the eye but also lets you keep track of your daily activity, helping to improve your health and wellness.

Have a peek at screenshots from the Activity Log Excel Template:

Continue reading

Expense Report MS Excel Template

 

The Expense Report free Microsoft Excel template helps you keep track of your expenses when on a business trip. It is also print ready so that you can send it directly to your superior. The minimalistic design and the overview it offers remind you of the costs without occupying too much of your time and energy.

Have a peek at screenshots from the Expense Report Excel Template:

Continue reading

Business Expenses Template

Keeping track of business expenses is essential to having a successful professional life. It is important to keep b business expenses apart from private expenses. Our Business Expenses free MS Excel template helps you to do just that.

It has a minimalistic visual representation and can be easily filled with expense records. Every expense sheet has a Name, Start Date and End Date field where you specify the overall information. Then you have more specific fields like Date, Expense (description), Type, Amount and Notes where you enter specific details about each expense item. You can also easily filter the information by any of the previously entered data. This free Excel template is also 100 percent print ready and just waits for you to click “Print”.

 Have a peek at screenshots from the Business Expenses Excel Template:

Continue reading

Workout Log Free MS Excel Template

Living a healthy life is paramount to professional and private success and in addition to a healthy food, doing sports is one of the pillars of achieving such a goal. Our free Workout Log MS Excel template will help you to keep track of your daily activity and the calories burnt. Please keep in mind that based on your age, profession, and general health conditions, different types and amounts of activities will yield the best possible results. So it is necessary to have a way to plan ahead, track what you’ve planned and adjust it periodically.

This free Workout Log Microsoft Excel Workbook to keep track of the average duration (in minutes) of your activity, the average distance you’ve moved, your average pace (per hour), the average calories you’ve burnt, and your average weight.

As most of our Excel template, this one here also has a minimalistic design and the functionality is very easy to learn so it won’t waste your time and you would be productive from the start. Just enter the details of your workout into the excel worksheet and it’ll give you an overview of your activities. Have fun (as I had) and happy healthy life.

Have a peek at screenshots from the Workout Log Excel Template:

Continue reading

Trip Planner Template

This time, we are going to present the Travel Planner MS Excel template. Those of you who travel a lot, whether for business or leisure, know very well that there are a lot of small details (and some big ones) that can get overlooked and in effect ruin a supposedly beautiful and fruitful travel. After all one’s mind can remember only that much. The solution? Planning.

Trip Planner is a beautifully designed free MS Excel WorkBook that tries to cover every aspect of a trip by dividing it into 4 worksheets as follows:

  1. Travel
  2. Lodging
  3. Activities
  4. Budget

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

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

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

Wedding Budget Planner Template

Planning and organizing a wedding isn’t a small feat and there are an endless number of gaffes and errors that could lead to embarrassment and more. In fact, remembering all the important details, from little to the big ones, is really hard. That is why there are so many wedding planners out there.

But if you are one of those DIY types, you’ll definitely need the Wedding Budget Planner MS Excel template. After all, you can’t keep track of everything and at the end the bills for a perfect wedding get out of control. With the free Budget Planner Excel template, it won’t be like this. You will estimate your costs and budget from the first and split it among different categories by percentage to keep an overall record of your wedding spendings.

Have a peek at screenshots from the Wedding Budget Planner Excel Template:

Continue reading

2017 Full Year Calendar Microsoft Excel Template

We are still about 3 months away from 2017 but some early birds are already asking for next year’s calendar and that is a good thing. Having a clear picture and schedule for the future is one of the pillars to become successful, professionally and privately. The 2017 Full Year Calendar features 14 sheets. The first sheet shows all the 12 months at a glance and gives you space to write down some notes. The next 12 sheets belong to every month and show you public holidays and have also a place where you can write down some notes. The last sheet is for January 2018, so that plan ahead.

It should be noted that this calendar is print ready.

Have a peek at screenshots from the 2017 Full Year Calendar 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

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

Weekly Meal Planner Microsoft Excel Template

Weekly Meal Planner MS Excel

This week, I like to introduce one of my most favorite Excel templates, namely the Weekly Meal Planner. A friend of mine recently asked me to create an Excel template for his wife, a proficient Excel user herself, to help her in her weekly task of putting together a meal plan for the whole family. The initial template wasn’t as huge as this free Excel template, and had only a fraction of its current functionality, but fortunately, I received very much appreciated positive feedback from my friend’s wife and was encouraged to build on it. The free MS Excel template that follows is the result of many iterations and adjustments to create a functional but at the same time easy to use template.

Have a peek at a screenshots from the Weekly Meal Planner Excel Template:

Continue reading

4 Week Project Timeline Microsoft Excel Template

Managing more than a few projects at the same time is quite a feat that can bring you headaches. People usually forget meetings, miss deadlines and end spending more time managing than doing actual work. This is where the overhead becomes more than the real work and you won’t be productive anymore and start wasting your own and your teammates valuable time down the road.

Continue reading

Time Sheet Microsoft Excel Template

Managing one’s time or one’s employees times can turn into a hassle that takes too much time and makes you unproductive. In this week’s free Excel template we present you another workbook that enables you to keep track of your own weekly working hours or those of your employees.

This MS Excel template is very easy to use and saves you the complications of sophisticated worksheets that take a whole day to learn how they work.

Have a peek at the clean and minimalistic style of the Time Sheet Excel Template: Continue reading

A Comprehensive Guide on Free Excel Templates for Startups

In the last few days, I was busy researching different options that would help young business startups get up and running their new venture and therefore we didn’t publish our weekly free excel template last week.

But to make up for what we missed last week, I’ve come up with a thorough post about using free MS Excel templates readily available on the market, and some free MS Word templates too for that matter, which will help you pave the way for your seed to grow, bloom and survive in an increasingly competitive market.

According to a recent report by the US Small Business Administration, there are around 28 million small businesses in the US that create a proud 64 percent of new private sector jobs every year.

Every second, 3 startups are born worldwide (Three Startups per Second!) that adds up to a staggering 100 million new businesses every year! But unfortunately, about 90 percent of them will fail. Despite the high risks of investing in startups, in the US alone, the sheer number of 48.3 billion USD in venture capital is invested in startups every year.

If you like to know more about startup statistics, have a look at this article from mashable.com with a great infographic that helps to visualize the whole subject. Continue reading

Personal Budget Planner Microsoft Excel Template

Personal Budget Planner for MS Excel

In this week’s free Excel template, I want to introduce you to one of my favorite templates, namely the Personal Budget Planner. It has a clean and stylish and modern look with a very easy to use interface to do one of the most important, in cases worst handled, tasks.

The perfect appearance makes this free Microsoft Excel template a treat for the eye, so you could look at it just for the fun of seeing it! In addition to that, it’ll provide you with a nice overview of a month’s income, expenses, and savings.

Have a peek at the nice charts of the Personal Budget Planner Excel template:

Excel Template Personal Budget Planner

To get the charts showing relevant data, you have to fill 3 tables in this Excel template. The table and what they do are as follows:

  • Monthly Income: Here you will enter each income you receive during the month separately. It is paramount to enter accurate and relevant data to avoid miss calculations later on.
  • Monthly Expenses: This table is the exact opposite of the Monthly Income table, but the rules are the same. Keep it accurate.
  • Monthly Savings: Here you enter any extra money you were able to save during the month.

Have a peek at the tables of Personal Budget Calculator Excel Template:

Continue reading