An Introduction to VLOOKUPs
27th August, 2024

Although vLookups might initially scare Excel users off, they’re probably more straightforward than you think. Plus, once you’ve got an understanding of them down, you can save yourself time and effort while impressing your colleagues – what’s not to love!?
Read More

Using IF Statements in Excel
26th August, 2024

Sometimes, when using Excel, you’ll want to perform different tasks depending on the result of a certain query. The IF function in Excel is perfect for that; it tests if a condition is true or false, and then performs the appropriate action.
Read More

Using Excel to Calculate Dates
25th August, 2024

If you’ve used Microsoft Excel before, it’s likely that you’ve had to work with a spreadsheet where dates were manually entered - but did you know that Excel includes an array of functions to make it easy to calculate dates? It’s true!
Read More

How to Use Microsoft Excel's Autofill Function
24th August, 2024

The autofill function of Microsoft Excel is an incredibly useful tool, making it easy to repeat calculations hundreds (or even thousands) of times with very little effort.
Read More