Thanks for visiting Sheets Ahead. Below you will find a couple 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 Exercises 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.
The Fictional Retail Company sells the Amazing Thing in 8 different colors and the Nice Extra in 2 colors.
Their online store and two California locations are the only places you can find these items.
Review the Sales Revenue, Units Sold, and more on the Yearly and Monthly sheets.
Each sheet can be filtered by 3 different dropdowns, Product, Employee, and Store.
The Monthly sheet can also be filtered by Start and End Months.
Create your own copy of the sheet to review the formulas and underlying data.