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.
"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
Master this powerful function to pull data from other tables — a must-know for managing large sheets or dashboards.
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.
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.
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.
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.
Lesson 6: How to Randomize a List in Google Sheets
Shuffle entries with ease — great for giveaways, sampling, seating plans, or task rotations.
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.
Lesson 8: How to Highlight Duplicates in Google Sheets
Spot and clean up repeated entries using simple conditional formatting tricks.