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 […]
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 […]
How to create Excel formulas
If you’re new to Excel or want to start using Excel formulas, this guide will help you get started with the basics. Many people use Excel for years but still rely on a calculator for calculations. This is often because they’re unsure where to start or don’t fully trust Excel’s results. Let’s explore some simple […]