Spreadsheet Wise | Tutorials

Sep 33 min read

Adjusting Date Formats in Google Sheets: A Simple Guide

Date formats in Google Sheets can vary significantly based on geographic location. We'll explore two simple methods to adjust date formats.

Apr 26 min read

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.

Mar 163 min read

Google Sheets with ChatGPT 4

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

Feb 105 min read

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.

Jan 11 min read

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.

Dec 20, 20234 min read

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.

Nov 25, 20234 min read

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

Nov 16, 20234 min read

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.

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

Sep 15, 20233 min read

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.