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
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
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
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
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
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
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 … Read more
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
What’s up with dates and times in Excel? What is a serial number? And what does the date January 1st, 1900 have to do with it? Today, we’re de-mystifying dates in Excel.
