Maven Analytics - Become a EXCEL SPECIALIST Download For Free
This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more
ABOUT THIS PATH
This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more.
We’ll start with a deep dive into some of Excel’s core capabilities, including formulas, charts & graphs, and PivotTables. You’ll learn how to explore and analyze raw data, build custom visuals and interactive reports, and quickly expose patterns and insights with user-friendly pivots.
From there we’ll dive into more advanced tools like Power Query, Power Pivot & DAX, explore tips and techniques to help you maximize your productivity, and wrap up with an exam prep course to help you earn your official MO-201 Excel Expert certification from Microsoft.
**INCLUDED COURSES
EXCEL FORMULAS & FUNCTIONS**
Master 75+ formulas & functions, and transform Excel into a dynamic and powerful analytics tool
Course Info8course hours
EXCEL CHARTS & GRAPHS
Design clear and effective charts and graphs, create advanced custom visuals, and master 20+ chart types in Excel
Course Info4.5course hours
EXCEL PIVOT TABLES & CHARTS
Learn how to explore and analyze your data using Pivot Tables & Pivot Charts, with 10 real-world case studies
Course Info7course hours
POWER QUERY, POWER PIVOT & DAX
Build and analyze data models using Excel’s trio of self-service BI tools: Power Query, Power Pivot & DAX
Course Info7.5course hours
EXCEL PRO TIPS: PRODUCTIVITY
Save time and work more efficiently with Excel productivity tools like shortcuts, flash fill, named ranges, and more
Course Info2course hours
EXCEL PRO TIPS: FORMATTING
Transform Excel worksheets into clear and polished reports using powerful formatting tools and techniques
Course Info1.5course hours
Chris Dutton
EXCEL PRO TIPS: FORMULAS
Expand your formula skills with powerful techniques like auditing tools and complex nested functions
Course Info2.5course hours
Chris Dutton
EXCEL PRO TIPS: VISUALIZATION
Think outside the pie chart and explore powerful visualization tools like maps, form controls, sparklines, and more
Course Info1.5course hours
Chris Dutton
EXCEL PRO TIPS: PIVOT TABLES
Learn advanced Pivot Table techniques like value grouping, complex filters, data caching, and custom sort lists
Course Info2course hours
EXCEL PRO TIPS: ANALYTICS
Sample some of Excel’s most powerful analytics tools, like forecasting, optimization, Monte Carlo simulation, and more
Course Info2course hours
Chris Dutton
EXCEL MO-201 EXAM PREP
Master the skills you need to ace the MO-201 Exam and become a certified Microsoft Excel Expert
Course Info8course hours
Enrique Ruiz
