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
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us (in author info), we’ll remove relevant links or contents immediately.