Category Archives: tips & tricks

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.

Have a look at the screenshot of the telephone-note-template

Telephone Note Message with Excel

Telephone Note Message with Excel

Download the telephone-note 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.

Do You like the templates? Thanks for a coffee 🙂

$
Personal Info

Donation Total: $1

Some hints for making phone-calls:

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

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

Stock Quote Free Excel Template

Manage, predict and analyse your stock portfolio with MS Excel

We have had already different free MS Excel templates for managing one’s financial day to day business, like the Cash Book Excel template, or the Interest Calculator Excel Template, but a stock quote template was something we had never tried.

Today, we have a very special free MS Excel template to offer. It is a sophisticated analysis template, where you can get live updates from Yahoo Finance.

This free Excel template enables you to enter your stock portfolio, including stock name and quantity, into a table and will calculate everything from percentage change and total value change to P&L change. The template also features a pie chart, where you can have a nice visual about your portfolio and how much different stock are filling you investments.

The current profits and losses are shown in a neat bar chart, where you get an overall view of each stock’s recent performance. Continue reading

Gift Certificate

Now Christmas is already around the corner and I thought that a voucher template in Excel is perhaps even feasible . And indeed , if you load an image in the header of an Excel sheet , it is automatically displayed on the whole page in the background . Although Excel does have a background-image-function, but this shows the image only during editing and not in the putput of the printer ! Well , the Excel-template with a voucher , which I offer here for free download, contains definitely a coupon text that is customizable . The word Certificate and the framework around it , however, is in the background image and is thus fixed . Continue reading