Metric Maven: 101 Sheets Tasks
by Metric Maven
101 hands-on Google Sheets tasks with video solutions, from formulas to pivot tables
+1 more
Stop wondering how to do it in Google Sheets. 101 Sheets Tasks and How to Solve Them answers questions like how to combine text from multiple cells, create a dropdown list, build a pivot table, clean up messy data, and look up information from another table.
The course is organized into 15 sections of bite-sized lessons with video solutions. The first seven cover formulas and functions, including lookup, text, array, logical, and nested functions. The rest cover pivot tables, charts, sort and filter, data validation, conditional formatting, and tips and tricks. No fluff, just practical Sheets skills you can use at work tomorrow.
Outcomes
- Solve everyday Google Sheets problems with confidence
- Write text, lookup, array, and nested formulas
- Build pivot tables and charts in Sheets
- Clean up messy data faster
What's included?
101 Hands-On Sheets Tasks
Practical tasks that answer the questions people search for most, like combining text, building dropdowns, and looking up data.
Video Solutions
Bite-sized video walkthroughs for every task, so you can see exactly how each problem is solved.
Formulas & Functions (Sections 1-7)
Aggregate IFS, logical, text, lookup, array, and nested functions, taught through real tasks.
Additional Skills (Sections 8-15)
Pivot tables, charts, sort and filter, data validation, conditional formatting, and 27 tips, tricks, and useful features.
Who is this for?
- Google Sheets users who constantly search for how to do things
- Professionals who want practical Sheets skills for work
- Beginners who want bite-sized lessons with video solutions
- Anyone who wants to clean, sort, and analyze data in Sheets
About the creator
Metric Maven
Excel training and coaching for real-world spreadsheet skills
Metric Maven is Shelby Bennion's Excel education brand, built to make spreadsheet skills approachable through hands-on practice rather than dense theory. The brand grew out of a simple idea: people learn Excel faster by working through real problems...