Google Sheets | Spreadsheet Wise

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.

Jun 24, 202312 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 14, 20234 min read

Duration Conversion with a Custom Function in Google Sheets

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