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: • Better tables in Google Sheets with 2...
Auto colour in Google Sheets: • Automatically colour in Google Sheets...
Download example files here: https://www.xlconsulting-asia.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
Watch video Structured tables for Google Sheets online without registration, duration hours minute second in high quality. This video was added by user David Benaim 05 June 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 7,921 once and liked it 182 people.