Metric Maven: 101 Excel Tasks
by Metric Maven
101 hands-on Excel tasks with video solutions, from formulas to Power Query
+1 more
Stop wondering how to do it in Excel. 101 Excel 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, formatting, Power Query, and pro tips. No fluff, just practical Excel skills you can use at work tomorrow.
Outcomes
- Solve everyday Excel problems with confidence
- Write text, lookup, array, and nested formulas
- Build pivot tables and charts in Excel
- Clean up messy data faster
What's included?
101 Hands-On Excel 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, formatting, Power Query, hidden gems, and pro tips.
Who is this for?
- Excel users who constantly search for how to do things
- Professionals who want practical Excel skills for work
- Beginners who want bite-sized lessons with video solutions
- Anyone who wants to clean, sort, and analyze data in Excel
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...