Absolute vs relative references: when to use $ in formulas
The $ symbol locks cell references. Master when to use $A$1, $A1, and A$1 to make formulas work when copied.
Read article →Excel articles
Practical Excel tips and walkthroughs you can use right away. Learn from real examples and build your skills by doing.
XLOOKUP vs VLOOKUP: which should you actually use?
XLOOKUP and VLOOKUP both find values in tables, but XLOOKUP handles more cases with simpler syntax. See when each one wins.
Read article →
Rounding numbers to the nearest 5 in Excel
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...
Read article →
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...
Read article →
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 ...
Read article →
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 al...
Read article →
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 a...
Read article →
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 fr...
Read article →
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 Vlooku...
Read article →
Calculate Age in Excel – You might be doing it wrong
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 ...
Read article →
What You Should Know About Dates in Excel
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-myst...
Read article →
How to Use Index and Match to Replace Vlookup
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...
Read article →
Rounding Numbers in Excel: Round, MRound, Ceil & Trunc explained
There are a ton of ways to round numbers in Excel. Ways you may not have thought of at first, like rounding to the nearest 1000 or truncating a spe...
Read article →
Everything About Excel’s IF Function
Welcome to the COMPLETE guide on the Excel If function. We’ll go into formulas containing If, nested If statements, AND and OR. The different condi...
Read article →
Quick Excel Guide: How to Export as PDF
A 4 step guide to make Excel export as PDF. Information on how to convert the entire workbook, specific worksheets and an in-depth look at all the ...
Read article →
Remove Spaces in Excel
How to remove spaces from Excel workbooks and worksheets. There are quite a few ways of doing this. In this video I’m showing a couple of them. I a...
Read article →
Find and Replace in Excel
Excel’s find and replace allows you to search for something (a text, a number, all formulas, etc) and replace it with something else. This blog pos...
Read article →
VLOOKUP explained in 2 minutes
It doesn’t have to be difficult: Vlookup, the most infamous function in Excel, explained in less than 2 minutes! We’ll also get into it further wit...
Read article →
Beginners Excel tips and tricks
You’ve worked with Excel a few times. You’ve seen others use it to great effect. And now, it is your time to start on your path to becoming the Exc...
Read article →
Advanced Excel lesson
You know most of the ins and outs of Excel. You’re using it to create reports and automate things for yourself or your work. But there is still one...
Read article →
Intermediate Excel lesson
You know your way around Excel. You may already be using it to create reports for yourself or your work. But when you get past the beginner stage y...
Read article →
Absolute beginners Excel lesson
You’ve opened Excel a couple of times. You’ve seen others use it to great effect. And now, it is your time to start on your path to becoming the Ex...
Read article →Want to practice what you learned?
Put your Excel knowledge to work with our interactive exercises. Practice with real spreadsheets in your browser.
Try interactive exercises