In this step-by-step guide, we’ll show you how to round numbers to the nearest multiple of five using two different methods in Microsoft Excel. Why round numbers to the nearest 5? Rounding numbers to the nearest five is a common task in finance, accounting, and data analysis. It helps simplify complex calculations and makes it … Read more

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 article, 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

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.

We’re going to look at replacing Vlookup with the Index and Match functions.
Before we do that though, it is important to note why we would. What is wrong with Vlookup that it needs replacing?