Fonts in Excel

How to download fonts and install them in Excel

When you need to improve the looks of a spreadsheet, it’s good to know how to install a font in Excel. Fonts improve the style of documents and web pages. They can also make text more readable and give personality to your projects. There are numerous free and paid fonts available on the Internet. In

Read More
Calculating minus sum? Probably just pi.

Is there a ‘minus sum’ for spreadsheets?

We have seen people ask this question online quite a bit. The reason is simple, there is a SUM function in Excel. But is there also an opposite of SUM? A formula that will subtract all numbers that you give it? A spreadsheet ‘minus sum’, so to speak? There are two answers to this question.

Read More
Excel for marketers

7 Excel Tricks for Marketers

Did you know that Microsoft Excel has over 500 functions at your disposal? These functions make Microsoft Excel useful as an analytical tool for almost any industry. Marketers may not think of Excel as such, but Excel can be a super helpful tool to make their daily analysis of data simpler. Because nowadays, successful marketers

Read More
Learn Excel quick with bite-sized learning.

How to Learn Excel Fast: 3 things you need to know

Sometimes you’re just strapped for time. You may be applying for jobs and looking for a quick CV boost. Or you might need to learn Excel fast for an upcoming project that requires it. Whatever the reason, it can be a relief to hear that it is possible to learn Excel fast and without much

Read More
Curious cat

Excel Beginner Exercises

In this article, I’m going to walk you through a couple of Excel exercises that are perfect for beginners. We will slowly ramp up the difficulty from beginner to advanced so if things are too easy for you, just scroll down a bit. Getting started with formulas ‘Formulas?!’ You may be thinking. ‘That’s way too

Read More
Stop sign to tell you to stop using Vlookup

Why You Should Stop Using VLOOKUP

A lot of us are familiar with this function. You could even make a case that it’s the most (in)famous Excel function out there: Vlookup. The Vlookup function (Vlookup stands for Vertical Lookup) is widely used in business and personal Excel use alike. Whenever a value needs to be found in a long list of

Read More
Old man

Calculate Age in Excel – You might be doing it wrong

In this short video, I’ll tell you how to calculate ​someone’s age based on a date of birth and how you may be doing it wrong right now. ​Once you realize that ​age is just the difference in years between a date of birth and the current date, it becomes easy to do. Check the video

Read More
Learn how to use Excel without the mouse

Mouse free Excel navigation: Become 5x faster with Excel

To go from a beginner or intermediate Excel level and become a master, you will need to improve your speed. One of the quickest ways to greatly improve your Excel speed is by learning some keyboard navigation shortcuts. In this video I’ll show you what buttons and keyboard shortcuts you need to know to navigate

Read More
Piggy Bank

Creating a Personal Finance Spreadsheet

​Many people use Excel as a tool to keep up with their personal finances. In this video I show you how you can ​create a spreadsheet ​where you can keep track of your personal finances every month. The result is a dashboard with charts giving you insight in your spending and saving.V​ideo ​Download ​xlsx file​Download

Read More