In this post, we will examine VLOOKUP and the differences to its modern successor, XLOOKUP, in Google Sheets.

As Gemini evolves, it can be difficult to know what its capabilities are. The ‘Ask Gemini’ menu in Google Sheets will show examples of Gemini’s capabilities and help us get started with the right prompt.

We are loving the new 'Create an AI column' Gemini button in the Google Sheets cell. It saves a lot of time.

You want to share a Google Doc with your team, but only for a limited period? Use the expiry share option. We use this a lot for training recordings.

Google Sheets has two types of references, Absolute References and Relative References.

You can combine the IMPORTRANGE function with other functions to analyse data in other Google Sheets files. Here are a couple of examples.

You can create rules to send email notifications when a cell changes in Google Sheets.

In Google Sheets, you can view the whole version history of a Sheet or you can view a specific cell, this is called the 'Edit history.

You can analyse Google Forms data using the 'convert to table' button, making it quick and easy to filter, sort and group your form data!

Paste Special allows you to copy Conditional formatting, Data validation and more within Google Sheets.

This post will teach you how to insert Google Sheets data into a Google Doc

If you click the advanced options you can change the look of the drop-down list, we have gone for the modern chip look but you can choose...