Google Sheets 101 Course
Google Sheets 101 Course
Google Sheets 101 Course
Learn to organize, analyze, and visualize data with ease. Perfect for professionals, students, and teams ready to go beyond the basics.
Learn Google Sheets for FREE
Built with
"This course completely changed the way I work. The lessons are super easy to follow, and I was building useful automations within the first hour. The real-world examples made everything click. If you're new to Zapier, this is the best place to start."
"I used to just enter data and hope for the best, but this course completely changed how I use Google Sheets. I finally understand VLOOKUP, pivot tables, and all those features I used to avoid. The lessons are short, clear, and super useful. If you want to feel confident using Sheets at work or school, this is the course to take."
Lesson 1: How to Use VLOOKUP in Google Sheets
Lesson 1: How to Use VLOOKUP in Google Sheets
Lesson 1: How to Use VLOOKUP in Google Sheets
Master this powerful function to pull data from other tables — a must-know for managing large sheets or dashboards.
Built with
Lesson 2: How to Create a Pivot Table in Google Sheets
Lesson 2: How to Create a Pivot Table in Google Sheets
Lesson 2: How to Create a Pivot Table in Google Sheets
Turn rows of raw data into meaningful summaries with built-in pivot tables — no need for advanced formulas.
Turn rows of raw data into meaningful summaries with built-in pivot tables — no need for advanced formulas.
Turn rows of raw data into meaningful summaries with built-in pivot tables — no need for advanced formulas.
Built with
Lesson 3: How to Apply Conditional Formatting in Google Sheets
Lesson 3: How to Apply Conditional Formatting in Google Sheets
Lesson 3: How to Apply Conditional Formatting in Google Sheets
Automatically highlight key insights like overdue tasks, low values, or duplicates to make your sheets more visual and useful.
Automatically highlight key insights like overdue tasks, low values, or duplicates to make your sheets more visual and useful.
Automatically highlight key insights like overdue tasks, low values, or duplicates to make your sheets more visual and useful.
Built with
Lesson 4: How to Create a Drop-Down List in Google Sheets
Lesson 4: How to Create a Drop-Down List in Google Sheets
Lesson 4: How to Create a Drop-Down List in Google Sheets
Streamline data entry and minimize errors with selectable cell options — perfect for forms, checklists, and templates.
Streamline data entry and minimize errors with selectable cell options — perfect for forms, checklists, and templates.
Streamline data entry and minimize errors with selectable cell options — perfect for forms, checklists, and templates.
Built with
Lesson 5: How to Combine First and Last Name in Google Sheets
Lesson 5: How to Combine First and Last Name in Google Sheets
Lesson 5: How to Combine First and Last Name in Google Sheets
Learn quick formulas to merge names or any other text — useful for contact lists, mail merges, and reporting.
Learn quick formulas to merge names or any other text — useful for contact lists, mail merges, and reporting.
Learn quick formulas to merge names or any other text — useful for contact lists, mail merges, and reporting.
Built with
Lesson 6: How to Randomize a List in Google Sheets
Lesson 6: How to Randomize a List in Google Sheets
Lesson 6: How to Randomize a List in Google Sheets
Shuffle entries with ease — great for giveaways, sampling, seating plans, or task rotations.
Shuffle entries with ease — great for giveaways, sampling, seating plans, or task rotations.
Shuffle entries with ease — great for giveaways, sampling, seating plans, or task rotations.
Built with
Lesson 7: How to Create a Bar Graph in Google Sheets
Lesson 7: How to Create a Bar Graph in Google Sheets
Lesson 7: How to Create a Bar Graph in Google Sheets
Visualize your data fast with clear bar charts — essential for presentations and stakeholder updates.
Visualize your data fast with clear bar charts — essential for presentations and stakeholder updates.
Visualize your data fast with clear bar charts — essential for presentations and stakeholder updates.
Built with
Lesson 8: How to Highlight Duplicates in Google Sheets
Lesson 8: How to Highlight Duplicates in Google Sheets
Lesson 8: How to Highlight Duplicates in Google Sheets
Spot and clean up repeated entries using simple conditional formatting tricks.
Spot and clean up repeated entries using simple conditional formatting tricks.
Spot and clean up repeated entries using simple conditional formatting tricks.
Built with
