Self-Paced Course
Excel MO-201 Exam Prep
Master the skills you need to ace the MO-201 Exam and become a certified Microsoft Excel Expert
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.
If you're ready to level-up your skills and become a certified Excel ROCKSTAR, this is the course for you.
Â
COURSE CURRICULUM:
- Course Structure & Outline
- DOWNLOAD: Course Resources
- Setting Expectations
- Exam Structure
- Objective Domains & Skills Measured
- Exam Interface & Scheduling
- Helpful Resources
- Course Project Intro
- The Airbnb Dataset
- Objective Domain Intro
- Fixed vs. Relative References
- Explicit vs. Structured References
- Logical Operations
- The IF Function
- Nested IF Functions vs. the IFS Function
- The NOT & <> Operators
- The AND/OR Operators
- The SWITCH Function
- The COUNTIF/SUMIF/AVERAGEIF Functions
- COUNTIFS/SUMIFS/AVERAGEIFS for Multiple Criteria
- The MINIFS & MAXIFS Functions
- Excel Date Values & Formatting
- PRO TIP: Coverting Text to Dates
- The TODAY & NOW Functions
- YEAR/MONTH/DAY & HOUR/MINUTE/SECOND
- WEEKDAY, WORKDAY & NETWORKDAYS
- Recording a Macro
- Modifying & Deleting Macros
- PRO TIP: Adding Form Controls
- Lookup Functions
- The VLOOKUP & HLOOKUP Functions
- The INDEX Function
- The MATCH Function
- Combining INDEX & MATCH
- Approximate Match Lookups
- The PMT & NPER Functions
- Scenario Manager
- Consolidate Data
- Goal Seek
- Formula Auditing
- QUIZ: Advanced Formulas & Macros
- Objective Domain Intro
- Custom Number Formats
- Data Validation
- Group & Ungroup Data
- Subtotals & Totals
- Removing Duplicates
- Auto Fill & Flash Fill
- Advanced Fill Series Options
- Conditional Formatting
- Formula-Based Conditional Formatting
- Managing Conditional Formatting Rules
- PRO TIP: Hiding Values to Create Heatmaps
- QUIZ: Manage & Format Data
- Objective Domain Intro
- Box & Whisker Chart
- Histogram
- Filled Map
- Combo Chart
- Tree Map & Sunburst Chart
- Waterfall Chart
- Funnel Chart
- Creating a PivotTable
- Modifying PivotTable Views
- Summarize Values By Options
- Show Value As Calculations
- Analyze & Design Tabs
- Report Layouts & Options
- Number Formatting
- Sorting & Filtering
- Slicers & Timelines
- Grouping Text Fields
- Grouping Numerical Fields
- Grouping Dates
- Calculated Fields
- Calculated Items
- Pivot Charts
- Pivot Chart Formatting
- Expanding & Collapsing Pivot Charts
- QUIZ: Advanced Charts & Tables
- Objective Domain Intro
- Enabling Macros
- Copying Macros to Other Files
- Linking Data Across Workbooks
- Protecting Worksheets & Cell Ranges
- Protecting & Encrypting Workbooks
- Recovering Workbooks
- Managing Comments
- Formula Calculation Modes
- Language Options
- QUIZ: Workbook Options & Settings
- Practice Test Intro
- DOWNLOAD: Practice Test Resources
- Practice Test Structure
- SOLUTION: Project 1
- SOLUTION: Project 2
- SOLUTION: Project 3
- SOLUTION: Project 4
- SOLUTION: Project 5
- SOLUTION: Project 6
- Course Feedback Survey
- Share the love!
- Next Steps
WHO SHOULD TAKE THIS COURSE?
- Excel users seeking to become a Microsoft Certified Expert
- Aspiring data professionals seeking to earn industry-recognized credentials
- Anyone looking to build deep and well-rounded Excel skills
WHAT ARE THE COURSE REQUIREMENTS?
- Microsoft Excel 2019+ or Office 365
- Familiarity with core Excel functionality recommended, but not required
Start learning for FREE, no credit card required!
Every subscription includes access to the following course materials
- Interactive Project files
- Downloadable e-books
- Graded quizzes and assessments
- 1-on-1 Expert support
- 100% satisfaction guarantee
- Verified credentials & accredited badges
Ready to become a
data rockstar?
Start learning for free, no credit card required!