Sheets Ahead logo

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.

  1. Find name from an email address - FIND and LEFT
  2. Find the domain from an email address - LET and MID
  3. Make a list of non-repeating domains - SORT and UNIQUE
  4. Find out how many times a domain appears - COUNTIF
  5. Convert a vertical list to headers - TRANSPOSE
  6. Create a list with criteria - FILTER
  7. Return information from another range - INDEX and MATCH
  8. Add a range in another sheet based on header - SUM and INDIRECT
  9. Create a list from multiple ranges - VSTACK
  10. Add ranges from multiple sheets and criteria - SUMIFS and INDIRECT
  11. Create a list from multiple sheets no blanks - VSTACK, INDIRECT and FILTER
  12. Leave a cell blank based on another cell - IF and ISBLANK
  13. 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

Send me an email Ilton.Greg at Gmail dot com