How to use XLOOKUP in Excel

Many users of Excel will be familiar with the lookup functions called Vlookup and Hlookup. Many Excel users however, have not yet explored how to use Xlookup. Xlookup is an extension of the original VLOOKUP and HLOOKUP functions but removes some of the requirements that the Vlookup and Hlookup have. A few key differences include: […]

How to use Countif in Excel

When working with a large amount of data in Excel, you may find yourself needing to count the number of records which meet a specific criteria. This is when the Excel Countif function is going to save you a lot of time. Let’s take a look at how the Excel Countif function works and how […]

How to conditional format an entire row based on dates older than today

It seems my conditional formatting posts have become quite popular and with that, I’ve had some amazing questions asked about variations of how to use conditional formatting. If you haven’t already taken a look at my other conditional formatting posts, be sure to explore how to use conditional formatting with dates based on a range, […]

Excel giving you the wrong answer? Discover BIDMAS and Excel

An important part of understanding how Excel calculates formulas and functions is understanding BIDMAS. Let’s think back to math class. I remember the teacher talking about BIDMAS and vividly thinking that I’d never need to use it. Attend any Excel course with me and it’ll be the first thing we discuss when we begin the […]

Introduction to Functions in Microsoft Excel

Microsoft Excel is a fantastic program allowing you to collate, analyse and sort data in various formats. Gone are the days of needing a calculator beside you to manually work out results from your data analysis. Microsoft Excel has the ability to perform this and more for you all with a few clicks of the […]