Thanks for visiting Sheets Ahead. Below you will find a collection of videos I have made about Google Sheets.
A step by step guide to using over a dozen helpful functions in Google Sheets.
The video focuses on parsing data from cells, filtering lists and returning data from other tables.
Follow along with the exercises by creating a copy of the sheet shown in the video.
Your copy will conatain blank and completed versions of the Exerices sheet
There is also a Walkthrough sheet, which will show you each function used in the video.
Here are the topics covered in Sheets Talk, along with the functions used. The Walkthrough sheet will guide you through the exercises.
How to use Index and Match in place of VLookup (Google Sheets, Microsoft Excel)
How to use the Countif and Countifs functions in Google Sheets or Microsoft Excel