Maven Analytics – Become a EXCEL SPECIALIST Free Download. This path is for Excel users looking to build a deep, expert-level skill set, including formulas, charts, PivotTables, Power Query, and more
Maven Analytics – Become a EXCEL SPECIALIST Description
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.
EXCEL FORMULAS & FUNCTIONS
Master 75+ formulas & functions, and transform Excel into a dynamic and powerful analytics tool
EXCEL CHARTS & GRAPHS
Design clear and effective charts and graphs, create advanced custom visuals, and master 20+ chart types in Excel
EXCEL PIVOT TABLES & CHARTS
Learn how to explore and analyze your data using Pivot Tables & Pivot Charts, with 10 real-world case studies
POWER QUERY, POWER PIVOT & DAX
Build and analyze data models using Excel’s trio of self-service BI tools: Power Query, Power Pivot & DAX
EXCEL PRO TIPS: PRODUCTIVITY
Save time and work more efficiently with Excel productivity tools like shortcuts, flash fill, named ranges, and more
EXCEL PRO TIPS: FORMATTING
Transform Excel worksheets into clear and polished reports using powerful formatting tools and techniques
EXCEL PRO TIPS: FORMULAS
Expand your formula skills with powerful techniques like auditing tools and complex nested functions
EXCEL PRO TIPS: VISUALIZATION
Think outside the pie chart and explore powerful visualization tools like maps, form controls, sparklines, and more
EXCEL PRO TIPS: PIVOT TABLES
Learn advanced Pivot Table techniques like value grouping, complex filters, data caching, and custom sort lists
EXCEL PRO TIPS: ANALYTICS
Sample some of Excel’s most powerful analytics tools, like forecasting, optimization, Monte Carlo simulation, and more
EXCEL MO-201 EXAM PREP
Master the skills you need to ace the MO-201 Exam and become a certified Microsoft Excel Expert
WHO SHOULD TAKE THIS PATH?
- Excel users who want to work more efficiently and develop expert-level analytics and data visualization skills
- Analysts or business intelligence professionals looking to develop a deep and well-rounded Excel skill set
- Excel users looking to ace the MO-201 exam and become a Microsoft Certified Expert
WHAT ARE THE PATH REQUIREMENTS?
- Microsoft Excel, ideally Excel 2019 or Office 365 for Windows/PC (some features and charts are unavailable in older versions)
- Familiarity with basic Excel functionality is strongly recommended
- NOTE: The MO-201 Exam specifically covers Excel 2019/Office 365
Maven Analytics – Become a EXCEL SPECIALIST Free Download
Content From: https://www.mavenanalytics.io/path/excel-specialist