Microsoft Excel Certification Exam Prep: MO-201 Excel Expert

Ace the Excel MO-201 Exam! Learn data analysis & visualization and earn your Excel Expert Certification (MS Excel 2019)

Created by: Maven Analytics
Empowering everyday people with life-changing data skills

Created by: Enrique Ruiz
Certified Microsoft Excel Expert

What Will I Learn?

• Analyze data with advanced formulas, including logical operators, lookups, date/time functions, and more
• Automate tedious, manual spreadsheet tasks with no-code, user-friendly VBA macros
• Visualize data with advanced charts like histograms, tree maps, geopatial maps, funnels, and combo charts
• Manage and format data with custom formats, autofill & flash fill, data validation, and conditional formatting
• Explore data on the fly with PivotTables, Pivot Charts, slicers and timelines
• Customize workbook settings like protection & encryption, calculation modes, comments, and language tools

Requirements

• Microsoft Excel 2019+ or Office 365
• Familiarity with core MS Excel functionality recommended, but not required

Target audience

• Excel users seeking to pass the MO-201 Exam and become a Microsoft Certified Expert
• Aspiring data professionals seeking to earn valuable, industry-recognized credentials
• Anyone looking to build a deep and well-rounded Microsoft Excel skill set
• Students looking for a fun, interactive, and project-based approach to test prep