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.
top of page
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.
3120
Mar 163 min read
Google Sheets with ChatGPT 4
Integrate AI model ChatGPT-4 into Google Sheets for enhanced data analysis and workflow automation
3010
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.
4890
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.
6150
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.
2,2500
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
9730
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.
4,5970
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,1490
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.
4060
bottom of page