Google Sheets' Tables make data far more structured and more like database type data. You can assign data types to each column, use structured references on entire column, they automatically expand with formulas, data validation and more. Change your data inputs into Tables and Google Sheets will work much better.

Create better tables in Google Sheets:    • Better tables in Google Sheets with 2...  
Auto colour in Google Sheets:    • Automatically colour in Google Sheets...  
Download example files here: https://www.xlconsultingasia.com/you...

00:00 Introduction
01:22 Make a table
02:00 Auto expand
02:54 Group by
03:53 Set data types
04:59 Smart chips data type
07:15 Table templates
07:47 Rename, resize, restyle & revert
09:08 Column options
10:01 Formulas and tables
14:29 Shortcuts
14:52 Multi cell formulas and tables
16:31 Excel Table features not in Sheets
16:56 Data type vs validation