Welcome to the Sheets Insiders content archive.
Coming soon: an Index with content grouped by topics and skill level (beginner – advanced) to make it easier to find information.
📌 Sheets Insiders 14: Beginner Apps Script workshop (16 January 2025)
- Replay of Beginner Apps Script workshop 1
- Best way to learn Apps Script in 2025
- How to approach problems
- How to leverage AI to accelerate learning path
📌 Sheets Insiders 13 (9 January 2025)
- Resources and reads on spreadsheets and AI
📌 Sheets Insiders 12: Holiday Formula Challenge (19 December 2024)
- January Schedule for the upcoming Apps Script workshops
- Holiday formula challenge with dates and the SEQUENCE formula
📌 Sheets Insiders 11: The Year in Sheets (12 December 2024)
- Rundown of all Google Sheets feature releases during 2024
📌 Sheets Insiders 10: Table Formulas + Combo Chart (5 December 2024)
- How to use Tables formulas and benefits
- How to create combo charts
- How to add labels to charts
📌 Sheets Insiders 9: Modern Analytical Functions Part II (21 November 2024)
- ⭐ Live session replay
- HSTACK and VSTACK examples
- BYROW and LAMBDA
- Bonus SPARKLINE trick with HSTACK
📌 Sheets Insiders #8: Modern Analytical Functions (14 November 2024)
- How to use HSTACK and VSTACK
- How to create default values in cells
- How to work with multi-select dropdowns and database functions
📌 Sheets Insiders #7: Database Functions (7 November 2024)
- ⭐ Live session replay
- How to use Database Functions
- Advanced criteria options
📌 Sheets Insiders #6: Tables (31 October 2024)
- Benefits of Tables
- How to use Structured Table References in formulas
- Advanced Tables formulas
📌 Sheets Insiders #5: Dropdowns (24 October 2024)
- Automatic dropdowns
- Multi-select dropdowns
- Dependent dropdowns with formulas and Apps Script
📌 Sheets Insiders #4: AI Experiments (17 October 2024)
- Three AI tools: Gemini, ChatGPT, and Julius
- Prompting tips
- Data analysis experiments
- Formula generation
📌 Sheets Insiders #3: User Interface Template (10 October 2024)
- Built-in methods like checkboxes and dropdown menus
- Specialized use cases with Apps Script
- Experimental methods using formulas and clever formatting tricks
📌 Sheets Insiders #2: Chart Tutorial (3 October 2024)
- Why series (columns) of data are KEY to building charts
- How to use “filler” bars to float data
- How to use formatting and drawings to make your charts visually pop!
📌 Sheets Insiders #1: Visual Vocabulary Template (26 Sep 2024)
- Google Sheets Visual Vocabulary template
- Design tips
- Show/hide technique for dashboards