Published On May 10, 2024
NEW 2024 TABLE FEATURE IN GOOGLE SHEETS!
Here’s a copy if you want to edit and test out the table options:
https://docs.google.com/spreadsheets/...
As mentioned in the video, the most exciting parts for me are:
1. Easily Format your data
2. Easily validate your data with “column types”
3. Filtering, Sorting, and other options to switch in your table all in one space.
4. Reference the table in other functions / Formulas or PIVOT Tables.
---
⏳Timestamps:
00:00 Introduction
00:55 Google’s Blogpost and TLDW
03:00 Pre-built Table Examples and Getting Started
4:16 Column Types
5:17 Highlighting Previous “Table Building”
5:44 Creating Table With Spreadsheet Data
6:17 Sorting and Filtering Tables
7:04 Creating Group By Views
9:53 Editing Column Types
11:24 Adding New Data
12:08 Referencing a Table
13:58 Table[ALL] Referencing
17:41 Some Table Limitations (IMPORTRANGE & Charts)
20:56 Referencing While Filtered
23:21 Conclusion
23:51 End Slides
--
🗣️Socials:
WEBSITE: https://matttechtidbits.github.io/mat...
REDDIT: / matttechtidbits
LINKEDIN: https://www.linkedin.com/in/matthew-k...
INSTAGRAM: / matttechtidbits
UPWORK: https://www.upwork.com/freelancers/~0...
🎵Music is "WFH" by Ambiosynthesis
• WFH
—
#️⃣#sheets
#spreadsheet
#googlesheets
#technology