MO-201 Complete Techniques – Microsoft Excel 2019 Expert

Course Curriculum

Chapter 1: Introduction

Lecture 1: Course Introduction

Lecture 2: How the exam is conducted

Lecture 3: Extracting the Student Resource Files

Lecture 4: Try It Yourself Exercises

Chapter 2: 1.1 Manage Workbooks

Lecture 1: 1.1.1 Copy Macros between Workbooks

Lecture 2: 1.1.2 Reference Data in Other Workbooks

Lecture 3: 1.1.4 Manage Workbook Versions

Lecture 4: 1.1.3 Enable Macros in a Workbook

Chapter 3: 1.2 Prepare Workbooks for Collaboration

Lecture 1: 1.2.1 and 1.2.2 Restrict Editing and Protect Worksheets

Lecture 2: 1.2.3 Protect Workbook Structure

Lecture 3: 1.2.4 Configure Formula Calculation Options

Lecture 4: 1.2.5 Manage Comments

Chapter 4: 1.3 Use and Configure Language Options

Lecture 1: 1.3.1 and 1.3.2 Use and Configure Language Options

Chapter 5: 2.1 Fill Cells Based on Existing Data

Lecture 1: 2.1.1 Fill Cells by using Flash Fill

Lecture 2: 2.1.2 Fill Cells by using Advanced Fill Series Options

Lecture 3: 2.1.2 Clarification on Advanced Series Fill Options

Chapter 6: 2.2 Format and Validate Data

Lecture 1: 2.2.1 Create Custom Number Formats

Lecture 2: 2.2.2 Configure Data Validation

Lecture 3: 2.2.3 and 2.2.4 Group, Ungroup and Sub Total Data

Lecture 4: 2.2.5 Remove Duplicate Records

Chapter 7: 2.3 Apply Advanced Conditional Formatting and Filtering

Lecture 1: 2.3.1 Create Custom Conditional Formatting Rules

Lecture 2: 2.3.2 Create Conditional Formatting Rules that use Formulas

Lecture 3: 2.3.2 TIY Explanatory Lecture

Lecture 4: 2.3.3 Manage Conditional Formatting Rules

Chapter 8: 3.1 Perform Logical Operations in Formulas

Lecture 1: 3.1.1 (Part 1) Perform Logical Operations by using IF and IFS Functions

Lecture 2: 3.1.1 (Part 2) Perform Logical Operations by using SWITCH(), AND, OR() and NOT()

Lecture 3: 3.1.1 (Part 3) Perform Logical Operations by using SUMIF() and Other Functions

Chapter 9: 3.2 Look Up Data by using Functions

Lecture 1: 3.2.1 (Part 1) Using the Vlookup and Hlookup Functions

Lecture 2: Hlookup Clarification Lecture

Lecture 3: 3.2.1 (Part 2) Using the Match and Index Functions

Lecture 4: 3.2.1 (Part 3) Match and Index Function Structures

Chapter 10: 3.3 Use Advanced Date and Time Functions

Lecture 1: 3.3.1 Reference Date and Time by using the NOW() and TODAY() Functions

Lecture 2: 3.3.2 Calculate Dates by using the WEEKDAY() and WORKDAY() Functions

Chapter 11: 3.4 Perform Data Analysis

Lecture 1: 3.4.1 Summarise Data from Multiple Ranges by using the Consolidate Feature

Lecture 2: 3.4.2 Perform What-If Analysis by using Goal Seek and Scenario Manager

Lecture 3: 3.4.3 Forecast Data by using the AND(), IF() and NPER() Functions

Lecture 4: 3.4.4 Calculate Data by using the PMT() Function

Chapter 12: 3.5 Troubleshoot Formulas

Lecture 1: 3.5.1 Trace Precedence and Dependence

Lecture 2: 3.5.2 Monitor Cells and Formulas by using the Watch Window

Lecture 3: 3.5.3 Validate Formulas by using Error Checking Rules

Lecture 4: 3.5.4 Evaluate Formulas

Chapter 13: 3.6 Create and Modify Simple Macros

Lecture 1: 3.6.1 to 3.6.3 (Part 1) Record, Name and Edit Simple Macros

Lecture 2: 3.6.1 to 3.6.3 (Part 2) Record, Name and Edit Simple Macros

Chapter 14: 4.1 Create and Modify Advanced Charts

Lecture 1: 4.1.1 Create and Modify Dual Axis Charts

Lecture 2: 4.1.2 (Part 1) Create and Modify Charts including Box & Whisker, Combo etc.

Lecture 3: 4.1.2 (Part 2) Create and Modify Charts including Box & Whisker, Combo etc.

Lecture 4: 4.1.2 (Part 3) Create and Modify Charts including Box & Whisker, Combo etc.

Chapter 15: 4.2 Create and Modify Pivot Tables

Lecture 1: Webinar on Pivot Tables and Charts March 11th 2021

Lecture 2: 4.2.1 Create Pivot Tables

Lecture 3: 4.2.2 Modify Field Selections and Options

Lecture 4: 4.2.3 Create Slicers

Lecture 5: 4.2.4 Group Pivot Table Data

Lecture 6: 4.2.5 Add Calculated Fields

Lecture 7: 4.2.6 Format Data

Chapter 16: 4.3 Create and Modify Pivot Charts

Lecture 1: 4.3.1 Create PivotCharts

Lecture 2: 4.3.2 Manipulate Options in Existing PivotCharts

Lecture 3: 4.3.3 Apply Styles to PivotCharts

Lecture 4: 4.3.4 Drill Down into PivotChart Details

Chapter 17: Exercise Book Solution Videos

Lecture 1: Objective Domain 1 Exercise Solutions

Lecture 2: Objective Domain 2 Exercise Solutions

Lecture 3: Objective Domain 3 Exercise Solutions

Lecture 4: Objective Domain 4 Exercise Solutions

Chapter 18: MO-201 Practice Exam and Video Solutions

Lecture 1: How to use the Practice Exam

Lecture 2: Exam 1 Project 1

Lecture 3: Exam 1 Project 2

Lecture 4: Exam 1 Project 3

Lecture 5: Exam 1 Project 4

Lecture 6: Exam 1 Project 5

Chapter 19: Bonus Lecture

Lecture 1: Bonus Lecture : MOS University

Lecture 2: Bonus Lecture : About MOS University