Spreadsheet Wise | Tutorials

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.

Google Sheets with ChatGPT 4

Integrate AI model ChatGPT-4 into Google Sheets for enhanced data analysis and workflow automation

Harnessing the Power of QR Codes with Google Sheets

Google Sheets offers a versatile platform for generating QR codes, with simple formulas and advanced scripting options.

Older OpenAI models will be shut down on January 4

OpenAI announced that on January 4th, 2024, they will shut down their older completions and embedding models - update your template now.

Creating a Timeline Gantt Chart in Google Sheets

Create a Gantt Chart in Google Sheets using conditional formatting to bring your project timelines to life.

How to Use INDEX and MATCH for Flexible Lookups in Google Sheets

INDEX & MATCH are two separate functions in Google Sheets that, when combined, allow you to look up values both vertically and horizontally

Sparklines in Google Sheets: A Simple Guide to Rich Data Visualisation

Welcome to the dynamic world of sparklines in Google Sheets. Turn your data into compelling visual stories.

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

How To Highlight Duplicate Rows in Google Sheets

Highlighting duplicate rows in Google Sheets can be really useful to draw attention to duplicate data quickly.