Excel MO-201 Exam Prep

This badge is earned by successfully completing the Excel MO-201 Exam Prep course at Maven Analytics. COURSE HOURS: 14.0 COURSE DESCRIPTION: 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/365. We'll start by introducing the Microsoft MO-201 exam, reviewing the test structure and interface, and addressing the key topics and objective domains covered: - Analyzing data with formulas & basic macros - Managing & formatting data - Exploring data with charts & PivotTables - Customizing workbook options & settings Unlike other test prep materials, this is a 100% project-based course, designed to put your skills to the test with practical demos and 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.