Udemy – Microsoft Excel Certification Exam Prep: MO-201 Excel Expert 2021-11

Published on: 2023-02-13 20:20:40

Categories: 28

Descriptions

This course is specifically designed to help you ace the MO-201 Excel Expert Exam and earn your official Microsoft Expert Certification for Excel 2019 or Office 365. With hands-on projects, full-length practice tests, and free downloadable study guides, this is the ONLY course you’ll need to prepare for the MO-201 Excel exam, guaranteed! Unlike other test prep materials, this is a hands-on and 100% project-based course, designed to put your skills to the test with practical demos and unique business intelligence case studies.

You’ll work with real data from Airbnb, and use Excel’s full arsenal of tools to analyze property details, rental rates, mortgage projections, and everything in between. By the end of the course, you’ll be able to apply advanced formulas and functions, design custom visuals and formats, explore data with PivotTables, automate manual tasks with macros, collaborate with other users, and much more. We’ve even included several custom-built practice tests, designed to replicate the actual Excel MO-201 exam structure and prepare you for the real deal.

What you’ll learn

Analyze data with advanced formulas, including logical operators, lookups, date/time functions, and more
Automate tedious, manual 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

Who this course is for

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 Excel skill set
Students looking for a fun, interactive, and project-based approach to test prep