top of page


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.
Apr 2, 20246 min read
352
0


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
Oct 12, 20234 min read
1,637
0


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
Jun 24, 202312 min read
13,104
0


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
Dec 21, 20228 min read
361
0


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?
Aug 15, 20223 min read
1,284
0

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.
Aug 13, 20225 min read
543
0


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.
Jul 30, 20224 min read
296
0


How To Return Multiple Columns with VLOOKUP and Data Validation
The VLOOKUP function is unquestionably in my top 5 most used functions.
Jul 17, 20223 min read
3,264
0
bottom of page