Microsoft Excel Certification Exam Prep: MO-201 Excel Expert
- Description
- Curriculum
- FAQ
- Reviews
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 & macros
-
Logical operators, date/time functions, financial functions, lookups, basic macros, formula auditing tools, etc.
-
-
Managing & formatting data
-
Custom formats, data validation, removing duplicates, autofill & flash fill, conditional formatting, etc.
-
-
Exploring data with charts & PivotTables
-
Statistical charts, tree maps & sunbursts, geospatial maps, PivotTables & PivotCharts, etc.
-
-
Customizing workbook options & settings
-
Linking 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 career
-
Strengthen your resume and market yourself to potential employers
-
Earn a highly coveted and prestigious credential, certified by Microsoft
If 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 video
-
Downloadable MO-201 test prep guide
-
Excel project files & solutions
-
Quizzes & practice tests
-
Expert-support and Q&A forum
-
30-day money-back guarantee
Happy 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.
-
11Objective Domain Intro
-
12Fixed vs. Relative References
-
13Explicit vs. Structured References
-
14Logical Operations
-
15The IF Function
-
16Nested IF Functions vs. The IFS Function
-
17The NOT & “<>” Operators
-
18The AND/OR Operators
-
19The SWITCH Function
-
20The COUNTIF/SUMIF/AVERAGEIF Functions
-
21COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria
-
22The MINIFS & MAXIFS Functions
-
23Excel Date Values & Formatting
-
24PRO TIP: Converting Text to Dates
-
25The TODAY & NOW Functions
-
26YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
-
27WEEKDAY, WORKDAY & NETWORKDAYS
-
28Recording a Macro
-
29Modifying & Deleting Macros
-
30PRO TIP: Adding Form Controls
-
31Lookup Functions
-
32The VLOOKUP & HLOOKUP Functions
-
33The INDEX Function
-
34The MATCH Function
-
35Combining INDEX & MATCH
-
36Approximate Match Lookups
-
37The PMT & NPER Functions
-
38Scenario Manager
-
39Consolidate Data
-
40Goal Seek
-
41Formula Auditing
-
42QUIZ: Advanced Formulas & Macros
-
43Objective Domain Intro
-
44Custom Number Formats
-
45Data Validation
-
46Group & Ungroup Data
-
47Subtotals & Totals
-
48Removing Duplicates
-
49Auto Fill & Flash Fill
-
50Advanced Fill Series Options
-
51Conditional Formatting
-
52Formula-based Conditional Formatting
-
53Managing Conditional Formatting Rules
-
54PRO TIP: Hiding Values to Create Heatmaps
-
55QUIZ: Managing & Formatting Data
-
56Objective Domain Intro
-
57Box & Whisker Chart
-
58Histogram
-
59Filled Map
-
60Combo Chart
-
61Tree Map & Sunburst Chart
-
62Waterfall Chart
-
63Funnel Chart
-
64Creating a Pivot Table
-
65Modifying Pivot Table Views
-
66"Summarize Values By" Options
-
67"Show Values As" Calculations
-
68Analyze & Design Tabs
-
69Report Layouts & Options
-
70Number Formatting
-
71Sorting & Filtering
-
72Slicers & Timelines
-
73Grouping Text Fields
-
74Grouping Numerical Fields
-
75Grouping Date Fields
-
76Calculated Fields
-
77Calculated Items
-
78Pivot Charts
-
79Pivot Chart Formatting
-
80Expanding & Collapsing Pivot Charts
-
81QUIZ: Advanced Charts & Pivot Tables
-
82Objective Domain Intro
-
83Enabling Macros
-
84Copying Macros to Other Files
-
85Linking Data Across Workbooks
-
86Protecting Worksheets & Cell Ranges
-
87Protecting & Encrypting Workbooks
-
88Recovering Workbooks
-
89Managing Comments
-
90Formula Calculation Modes
-
91Language Options
-
92QUIZ: Workbook Options & Settings