Structured tables for Google Sheets

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: https://youtu.be/UQG54xTTPZ8 Auto colour in Google Sheets: https://youtu.be/Pm2IcNPN9uQ To download example workbooks, enter email here: https://www.xlconsulting-asia.com/socials.html 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