Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/11/Tables-in-Google-Sheets.xlsx

In this video I explore how to replicate Excel's table functionality in Google Sheets. If you are used to using Excel tables but need to find the same functionality in Google Sheets, this video will help you.

Table of Contents:

00:00 - Intro
00:32 - Add Alternating Shading for Rows
01:13 - Freeze Rows (Column Headings)
01:56 - Apply Filters and Make Filters Expand As You Add New Records
04:07 - Create Named Ranges
06:44 - Get Formula to Automatically Copy Down and Copy to New Records
10:01 - Create a Total Row that Sums, Averages or Counts Filtered Rows
------------------------