## How to use VLOOKUP, HLOOKUP and INDEX MATCH in Excel

Say you have a table of data and you want Excel to look up a certain value and return a corresponding value in a different row. For that, you need a lookup function. Excel has a range of functions that you can use to achieve...

## How to do IF and nested IF functions in Excel

The IF function is one of the most useful you will ever learn in Microsoft Excel. It's also incredibly simple and can unlock some seriously juicy functionality when you start nesting IF statements.   In this post, we’ll show you how to do an IF and a...

## PivotTables in Excel – The Basics

PivotTable or pivot table. You may have heard of them…   In our opinion, they are one of the MOST powerful things you can learn in Excel. The great news is, they are pretty easy to get the hang of.   Before PivotTables were introduced into Excel, you had...

## Restricting Cell Contents in Excel Using Data Validation

Did you know that you can restrict, give guidance on and create drop-down lists for what you can enter in a certain cell in Excel? It’s a pretty cool feature and it’s called Data Validation.   However carefully you design your spreadsheets, even if you lock cells...

## Workout Tracker, Calorie Counter…All in Excel

‘New year, new me’… how many times have you heard that? Or even said it yourself? After eating too much over the festive season, we were feeling guilty and began looking for redemption online. We found some useful Excel spreadsheets which could help you (and us!)...

## How to Format Numbers in Excel

Excel is, at its heart, a programme that manipulates numbers: so getting your numbers to appear as you want is an important skill. The appearance of a number entered in an Excel cell can be changed in many different ways. This blog post shows you...

## How to Forecast using Average Percentage Growth

Average percentage growth tells us how fast something has grown, and eventually forecasts the future through extrapolation.   There are different ways of calculating average growth in Excel (e.g. LOGEST, LINEST, lines of best fit, etc.) and some of these will give different results. Let’s take a...

## Spotting Inconsistencies with “=…=…”

Inconsistencies can creep into spreadsheets for a range of causes: data-entry errors; accidental changes made to the data after entry; inconsistently applied rounding or changes to units; or differences in the way numbers are formatted in different systems.   The following is a simple technique which can...

## How To Excel – Use Filters to Get the Data You Want

Excel gives you many options when it comes to filtering your data. If you have a database with numerous entries, you can filter the data so that only the relevant information appears. Then, when you remove the filter, you can see all of your data...