Spreadsheet Wise | Tutorials

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.

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

Duration Conversion with a Custom Function in Google Sheets

Convert text durations into numeric durations in Google Sheets with Google Apps Script

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.

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.

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!

How to use Chat GPT in Google Sheets

Learn how to connect OpenAI’s Chat GPT to Google Sheets to harness the power of natural language processing

Relative and Absolute References in Google Sheets

Relative and absolute references are essential tools in Google Sheets to make your work easier and more efficient.

Dependent Drop-down Chips in Google Sheets

You can take drop-down lists to the next level by making them dynamic with dependent Drop-down Chips