INDEX Function in Google Sheets

All Tutorials 49 postsNo categories yet.
Essentials 14 postsNo categories yet.
Formatting 6 postsNo categories yet.
Data Validation 7 postsNo categories yet.
Charts 5 postsNo categories yet.
Finance 1 postNo categories yet.
Pivot Tables 1 postNo categories yet.
Maths 4 postsNo categories yet.
Lookup 6 postsNo categories yet.
Logical 2 postsNo categories yet.
Web 1 postNo categories yet.
Google 2 postsNo categories yet.
Google Apps Script 6 postsNo categories yet.
Chat GPT 4 postsNo categories yet.
Text 1 postNo categories yet.
Filter 1 postNo categories yet.
Templates 8 postsNo categories yet.

Widget Didn’t Load

Check your internet and refresh this page.

If that doesn’t work, contact us.

To-Do List Task Tracker with Calendar Template

No product

Basic Task Management Template

Pro Task Management Template

ChatGPT Custom Function Template in Google Sheets

Chat GPT Menu Trigger Template in Google Sheets

Currency Conversion Template

Automatic Invoice Template

Google Translate Template in Google Sheets

Formatting

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.

Lookup

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.

Chat GPT

Google Sheets with ChatGPT 4

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

Google Apps Script

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.

Charts

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.

Lookup

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

Charts

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.

Formatting

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

Formatting

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.

Google Apps Script

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

Chat GPT

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!

Chat GPT

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

Charts

Use the Sparkline function in Google Sheets to create a mini Progress Bar Chart

The Sparkline function in Google Sheets creates a miniature chart contained within a single cell. This is great for showcasing your data...

Data Validation

Create a Dropdown list with Smart Chips in Google Sheets

Dropdown chips are a better-looking version of the old-fashioned dropdown lists you could create using Data Validation.

Formatting

How To Apply Conditional Formatting Across An Entire Row In Google Sheets

Conditional formatting in Google Sheets can be a great time saver to highlight cells or text based on conditional logic automatically.

To-Do List Task Tracker with Calendar Template

Basic Task Management Template

Pro Task Management Template

ChatGPT Custom Function Template in Google Sheets

Chat GPT Menu Trigger Template in Google Sheets

Currency Conversion Template

Automatic Invoice Template

Google Translate Template in Google Sheets

Automatic Daily Gantt Chart Template

Project Management Template

Automatic QR Code Generator Template

ChatGPT 4 Pro Custom Function Template in Google Sheets