12 Tips To Use Google Sheets Like A Pro

Dean Stokes - Tech Tutorials · Intermediate ·📊 Data Analytics & Business Intelligence ·2mo ago
Master your next Google Sheet like a pro! For the examples in this videos, I work on a project tracker for an event. I cover 12 Google spreadsheet tips which will be helpful whether you're doing data analysis, project management, or other tasks. And, of course, some of them are Gemini AI tips, too! Get a weekly Google Workspace tip by subscribing (for free) to my newsletter: https://workspaceboost.com/subscribe 0:00 #1 Prompt Gemini to create a template 0:25 #2 Convert your data to tables 0:42 #3 Tag people with people smart chips 1:08 #4 Use dropdown fields 1:31 #5 Use checkbox fields 1:46 #6 Group tables by column 2:00 #7 Save filtered views for later 2:16 #8 Use timeline view to visualise projects 2:48 #9 Use the data cleanup tool 3:34 #10 Use PROPER to standardise writing 4:03 #11 Use AI to categorise or analyse 5:28 #12 Use Gemini to provide data insights
Watch on YouTube ↗ (saves to browser)
Sign in to unlock AI tutor explanation · ⚡30

Related AI Lessons

⚡
Python for Data Science — Handling Missing Values in Pandas
Learn to handle missing values in Pandas for effective data science, a crucial skill for any data scientist
Medium · Programming
 ⚡
Roblox Data Engineering Interview Questions: Full DE Prep Guide
Prepare for Roblox data engineering interviews with a focus on text-heavy product telemetry and search-related questions
Dev.to · Gowtham Potureddi
 ⚡
Tesla Data Engineering Interview Questions: Full DE Prep Guide
Prepare for Tesla data engineering interviews with this comprehensive guide, covering key concepts and practice questions to help you succeed
Dev.to · Gowtham Potureddi
 ⚡
Exodus Point Data Engineering Interview Questions: Full DE Prep Guide
Prepare for Exodus Point data engineering interviews with this comprehensive guide, covering key concepts and practice questions to help you succeed
Dev.to · Gowtham Potureddi

Chapters (12)

#1 Prompt Gemini to create a template
0:25 #2 Convert your data to tables
0:42 #3 Tag people with people smart chips
1:08 #4 Use dropdown fields
1:31 #5 Use checkbox fields
1:46 #6 Group tables by column
2:00 #7 Save filtered views for later
2:16 #8 Use timeline view to visualise projects
2:48 #9 Use the data cleanup tool
3:34 #10 Use PROPER to standardise writing
4:03 #11 Use AI to categorise or analyse
5:28 #12 Use Gemini to provide data insights
Up next
No More Table Locks for Multi Statement Transactions #databricks #dataengineering #sql
Databricks
Watch →