12 Tips To Use Google Sheets Like A Pro

Dean Stokes - Tech Tutorials · Intermediate ·📊 Data Analytics & Business Intelligence ·5mo ago

Key Takeaways

This video teaches 12 specific tips for using Google Sheets, including techniques for project tracking and data analysis.

Original Description

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 Reads

📰
Entity Resolution: Why "Show Me Everything About This Customer" Is So Hard
Entity resolution is a major challenge in showing customer data, hindering personalization and retention efforts
Dev.to AI
 📰
Dari Membuat Program Pendeteksi Hujan Sampai Hak Cipta: Apa yang Saya Pelajari Tentang Data &…
Learn how a student's project on building a rain detection program led to insights on data and intellectual property rights
Medium · Programming
 📰
How to Query Databricks from Salesforce Apex (Without Copying a Billion Rows)
Learn how to query Databricks from Salesforce Apex without copying large datasets, enabling efficient data retrieval and analysis
Dev.to · Md Mohiuddin
 📰
Can a Data Science Course Really Change Your Career in 2026?-IABAC
Discover how a data science course can transform your career in 2026 and what skills you need to acquire for a successful transition
Medium · Data Science

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
How to Prompt Your LLM Directly from SQL
Ian Wootten
Watch →