Microsoft Excel Certification Exam Prep MO201 Excel Expert

Ace the Excel MO-201 Exam. Learn advanced data analysis & earn the Excel Expert Certification (MS Excel 2019/Office 365)
Microsoft Excel Certification Exam Prep MO201 Excel Expert
File Size :
4.53 GB
Total length :
8h 35m



Maven Analytics


Last update




Microsoft Excel Certification Exam Prep MO201 Excel Expert

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

Microsoft Excel Certification Exam Prep MO201 Excel Expert


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


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!We’ll start by introducing Microsoft’s MO-201 Excel Expert Exam, reviewing the test structure and interface, and addressing the key topics and objective domains you’ll need to master, including:Analyzing data with formulas & macrosLogical operators, date/time functions, financial functions, lookups, basic macros, formula auditing tools, etc.Managing & formatting dataCustom formats, data validation, removing duplicates, autofill & flash fill, conditional formatting, etc.Exploring data with charts & PivotTablesStatistical charts, tree maps & sunbursts, geospatial maps, PivotTables & PivotCharts, etc. Customizing workbook options & settingsLinking Excel workbooks, protection & encryption, comments, calculation modes, language tools, etc.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.Trust us, test prep has NEVER been this much fun!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.So why get certified as a Microsoft Excel Expert?Build powerful and practical skills to launch or accelerate your careerStrengthen your resume and market yourself to potential employersEarn a highly coveted and prestigious credential, certified by MicrosoftIf you’re ready to level-up your skills, increase your earning potential, and become a certified Excel ROCKSTAR, this is the course for you.Join today and get immediate, lifetime access to the following:8+ hours of high-quality videoDownloadable MO-201 test prep guideExcel project files & solutionsQuizzes & practice testsExpert-support and Q&A forum30-day money-back guaranteeHappy learning!-Enrique (Certified Excel Expert & Instructor, Maven Analytics)__________Looking for the full business intelligence stack? Search for “Maven Analytics” to browse our full course library, including Excel, Power BI, MySQL, and Tableau courses!See why this is one of the TOP-RATED Excel courses on Udemy:”Awesome, awesome course! Took the exam today: 945/1000 🙂 I have been a long-time user, but your review helped to focus on the more important needs — I’d recommend your course and ALL YOUR SEMINARS/CLASSES!”- Stacey T.”Tried taking a course through LinkedIn Learning to prepare for the exam and I was disappointed… On the other hand– Enrique has done an outstanding job of organizing this material, keeping it current, providing excellent practical uses, and explaining it well. Well done!”- Jimmy D.”So happy to have passed my MO-201 Exam with a score of 945! Huge thanks to Enrique Ruiz for his amazing course!”- Buqet Y.”Excellent course! All concepts reviewed clearly and concisely with some bonus tips on shortcuts and useful features. I would definitely recommend it for anyone wanting to enhance their Excel skills or prepare for the MO-201 exam!”- Jason W.


Section 1: Getting Started

Lecture 1 Course Structure & Outline

Lecture 2 READ ME: Important Notes for New Students

Lecture 3 DOWNLOAD: Course Resources

Lecture 4 Setting Expectations

Section 2: About the MO-201 Exam

Lecture 5 Exam Structure

Lecture 6 Objective Domains & Skills Measured

Lecture 7 Exam Interface & Scheduling

Lecture 8 Helpful Resources

Section 3: The Course Project

Lecture 9 Course Project Intro

Lecture 10 The Airbnb Dataset

Section 4: Advanced Formulas & Macros

Lecture 11 Objective Domain Intro

Lecture 12 Fixed vs. Relative References

Lecture 13 Explicit vs. Structured References

Lecture 14 Logical Operations

Lecture 15 The IF Function

Lecture 16 Nested IF Functions vs. The IFS Function

Lecture 17 The NOT & “<>” Operators

Lecture 18 The AND/OR Operators

Lecture 19 The SWITCH Function

Lecture 20 The COUNTIF/SUMIF/AVERAGEIF Functions

Lecture 21 COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria

Lecture 22 The MINIFS & MAXIFS Functions

Lecture 23 Excel Date Values & Formatting

Lecture 24 PRO TIP: Converting Text to Dates

Lecture 25 The TODAY & NOW Functions



Lecture 28 Recording a Macro

Lecture 29 Modifying & Deleting Macros

Lecture 30 PRO TIP: Adding Form Controls

Lecture 31 Lookup Functions

Lecture 32 The VLOOKUP & HLOOKUP Functions

Lecture 33 The INDEX Function

Lecture 34 The MATCH Function

Lecture 35 Combining INDEX & MATCH

Lecture 36 Approximate Match Lookups

Lecture 37 The PMT & NPER Functions

Lecture 38 Scenario Manager

Lecture 39 Consolidate Data

Lecture 40 Goal Seek

Lecture 41 Formula Auditing

Section 5: Managing & Formatting Data

Lecture 42 Objective Domain Intro

Lecture 43 Custom Number Formats

Lecture 44 Data Validation

Lecture 45 Group & Ungroup Data

Lecture 46 Subtotals & Totals

Lecture 47 Removing Duplicates

Lecture 48 Auto Fill & Flash Fill

Lecture 49 Advanced Fill Series Options

Lecture 50 Conditional Formatting

Lecture 51 Formula-based Conditional Formatting

Lecture 52 Managing Conditional Formatting Rules

Lecture 53 PRO TIP: Hiding Values to Create Heatmaps

Section 6: Advanced Charts & Pivot Tables

Lecture 54 Objective Domain Intro

Lecture 55 Box & Whisker Chart

Lecture 56 Histogram

Lecture 57 Filled Map

Lecture 58 Combo Chart

Lecture 59 Tree Map & Sunburst Chart

Lecture 60 Waterfall Chart

Lecture 61 Funnel Chart

Lecture 62 Creating a Pivot Table

Lecture 63 Modifying Pivot Table Views

Lecture 64 “Summarize Values By” Options

Lecture 65 “Show Values As” Calculations

Lecture 66 Analyze & Design Tabs

Lecture 67 Report Layouts & Options

Lecture 68 Number Formatting

Lecture 69 Sorting & Filtering

Lecture 70 Slicers & Timelines

Lecture 71 Grouping Text Fields

Lecture 72 Grouping Numerical Fields

Lecture 73 Grouping Date Fields

Lecture 74 Calculated Fields

Lecture 75 Calculated Items

Lecture 76 Pivot Charts

Lecture 77 Pivot Chart Formatting

Lecture 78 Expanding & Collapsing Pivot Charts

Section 7: Workbook Options & Settings

Lecture 79 Objective Domain Intro

Lecture 80 Enabling Macros

Lecture 81 Copying Macros to Other Files

Lecture 82 Linking Data Across Workbooks

Lecture 83 Protecting Worksheets & Cell Ranges

Lecture 84 Protecting & Encrypting Workbooks

Lecture 85 Recovering Workbooks

Lecture 86 Managing Comments

Lecture 87 Formula Calculation Modes

Lecture 88 Language Options

Section 8: Practice Test

Lecture 89 Practice Test Intro

Lecture 90 DOWNLOAD: Practice Test Resources

Lecture 91 Practice Test Structure

Lecture 92 SOLUTION: Project 1

Lecture 93 SOLUTION: Project 2

Lecture 94 SOLUTION: Project 3

Lecture 95 SOLUTION: Project 4

Lecture 96 SOLUTION: Project 5

Lecture 97 SOLUTION: Project 6

Section 9: Wrapping Up


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

Course Information:

Udemy | English | 8h 35m | 4.53 GB
Created by: Maven Analytics

You Can See More Courses in the IT & Software >> Greetings from

New Courses

Scroll to Top