Welcome
Thanks for visiting Sheets Ahead. Below you will find a collection of videos I have made about Google Sheets.
Sheets Talk with Greg
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.
- Find name from an email address - FIND and LEFT
- Find the domain from an email address - LET and MID
- Make a list of non-repeating domains - SORT and UNIQUE
- Find out how many times a domain appears - COUNTIF
- Convert a vertical list to headers - TRANSPOSE
- Create a list with criteria - FILTER
- Return information from another range - INDEX and MATCH
- Add a range in another sheet based on header - SUM and INDIRECT
- Create a list from multiple ranges - VSTACK
- Add ranges from multiple sheets and criteria - SUMIFS and INDIRECT
- Create a list from multiple sheets no blanks - VSTACK, INDIRECT and FILTER
- Leave a cell blank based on another cell - IF and ISBLANK
- Count text - COUNTA
Index Match
How to use Index and Match in place of VLookup (Google Sheets, Microsoft Excel)
Countif and Countifs
How to use the Countif and Countifs functions in Google Sheets or Microsoft Excel