XLOOKUP Function in Google Sheets
The XLOOKUP function in Google Sheets allows you to search in any direction, return multiple results, and gracefully handle missing values.
top of page
Oct 12, 20234 min read
Analysing Percentage Changes with Google Sheets Formulas and Conditional Formatting
Visualise and interpret percentage changes from week to week or month to month in Google Sheets
1,0960
Jun 24, 202312 min read
Task List in Google Sheets with Kanban & Automated Status Tracking
Efficient task management is essential for maintaining productivity. This tutorial will explore a powerful solution to streamline your tasks
10,9570
Dec 21, 20228 min read
How to Create Pivot Tables in Google Sheets
Pivot Tables are an efficient and powerful way to analyse large amounts of data and make meaningful insights with minimal effort
3460
Aug 15, 20223 min read
How to Bulk Translate with Google Sheets
With Google Translate, you can translate anything, but did you know that you you can also achieve this using a Google Sheets Function?
1,1970
Aug 13, 20225 min read
INDEX Function in Google Sheets
The INDEX function in Google Sheets, when used in conjunction with other functions can easily compete and excel compared to VLOOKUP.
5030
Jul 30, 20224 min read
VLOOKUP Function in Google Sheets
The VLOOKUP is one of those well-known functions everyone’s heard of, yet it’s still somewhat of an enigma.
2510
Jul 17, 20223 min read
How To Return Multiple Columns with VLOOKUP and Data Validation
The VLOOKUP function is unquestionably in my top 5 most used functions.
3,0460
bottom of page