top of page


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.
Dec 21, 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 25, 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.
Nov 16, 20235 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
Oct 12, 20235 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.
Sep 15, 20233 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
Jun 24, 202312 min read


Duration Conversion with a Custom Function in Google Sheets
Convert text durations into numeric durations in Google Sheets with Google Apps Script
Jun 14, 20235 min read


How to Remove Duplicate Rows in Google Sheets
Removing duplicate entries in Google Sheets can be a time-consuming and tedious task. Fortunately, there’s a way to streamline the process.
May 3, 20234 min read


How to use the CONCATENATE Function in Google Sheets
The CONCATENATE function in Google Sheets allows you to combine two or more text strings or cells together.
Mar 26, 20234 min read


Chat GPT Custom Function in Google Sheets
Explore the possibilities of utilising Chat GPT as a custom function in Google Sheets to bring AI into any cell in your sheets!
Mar 18, 202311 min read
bottom of page
