Spot the difference: Microsoft Excel’s XLOOKUP vs VLOOKUP vs INDEX/MATCH
Who is who? and what do they do? Meet Excel’s top Lookup functions. Excel is widely known for its efficiency when navigating datasets and is an ACE tool for helping you to identify and analyse information. Manual searches for data can be tedious and prone to errors so utilising Excel’s top lookup functions to help […]
Become a Trend Spotter with Excel’s Conditional Formatting Feature
Identifying trends in your data doesn’t have to be like a game of Where’s Wally. Spotting trends in your data is such an important part of data analysis. Why? Because seeing the trends in your data helps you to make informed decisions, and the quicker you can make decisions and implement actions, the better, right? […]
Your quick guide to Excel’s CTRL shortcuts
On your marks, get set, go – these quick shortcuts will get your spreadsheets over the finish line faster! I’m constantly in awe of Excel’s capabilities to allow you to analyse data in a fast and efficient way. There are so many Excel shortcuts (including Excel’s CTRL shortcuts) available to help you streamline your activities […]
Understanding the Language of Excel Formulas and Functions
Learning a new language has never been this easy. Over the years I’ve become well versed in the language of Excel – building spreadsheets, creating formulas, and entering functions are all second nature to me (I could do it in my sleep… and often do!). But for a beginner, it can be daunting. Excel is […]