MO-201 Complete Techniques Microsoft Excel 2019 Expert

MO-201 Complete Techniques – Microsoft Excel 2019 Expert, available at $59.99, has an average rating of 4.35, with 71 lectures, based on 232 reviews, and has 1382 subscribers.

You will learn about You will be fully prepared to take the MO-201 MOS exam in Excel Expert Be familiar with every aspect of the Objective domain for the MO-201 exam Be expert in the advanced use of Microsoft Excel 2019 Be ready to pass the MO-201 exam This course is ideal for individuals who are Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2019/365. or Students who have abilities in Excel and want to achieve independent recognition for those abilities or Students who have passed the Associate Excel exam and want to progress to the next level or Experts in Excel who would like to get their expertise recognised officially It is particularly useful for Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2019/365. or Students who have abilities in Excel and want to achieve independent recognition for those abilities or Students who have passed the Associate Excel exam and want to progress to the next level or Experts in Excel who would like to get their expertise recognised officially.

Enroll now: MO-201 Complete Techniques – Microsoft Excel 2019 Expert

Summary

Title: MO-201 Complete Techniques – Microsoft Excel 2019 Expert

Price: $59.99

Average Rating: 4.35

Number of Lectures: 71

Number of Published Lectures: 70

Number of Curriculum Items: 71

Number of Published Curriculum Objects: 70

Original Price: 199.99

Quality Status: approved

Status: Live

What You Will Learn

You will be fully prepared to take the MO-201 MOS exam in Excel Expert

Be familiar with every aspect of the Objective domain for the MO-201 exam

Be expert in the advanced use of Microsoft Excel 2019

Be ready to pass the MO-201 exam

Who Should Attend

Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2019/365.

Students who have abilities in Excel and want to achieve independent recognition for those abilities

Students who have passed the Associate Excel exam and want to progress to the next level

Experts in Excel who would like to get their expertise recognised officially

Target Audiences

Anyone who wants to obtain independent certification from Microsoft that they have achieved expert level in the use of Microsoft Excel 2019/365.

Students who have abilities in Excel and want to achieve independent recognition for those abilities

Students who have passed the Associate Excel exam and want to progress to the next level

Experts in Excel who would like to get their expertise recognised officially

Important Course Update March 2023 – Complete Practice Exam with Video Solutions!

We’ve added some very valuable resources to the course in 2023. An additional section entitled “Practice Exam and Video Solutions” has been included at the end of the course. This section includes a complete practice exam set to the standard of the MO-201 exam. This consists of 5 exam projects together with a video solution for each. Don’t review the solutions until you make an attempt at the exam project exercises. This will give you a very real sense of how well prepared you are for the MO-201 expert certification exam.

We’ve also added a new lecture within this section entitled “Special Exam Considerations”. This lecture summarizes some important points about this specific exam that you need to consider carefully. The suggestions are based on direct student experience in taking the exam. In particular we focus on:

Technical issues which arise with the exam interface
Being strategic in your preparation and focus
The best approach to the use of formulas
Use of shortcut keys
Coping with nerves

Lots of really good practical exam advice!

Become a Microsoft Certified Excel (365/2019) Expert

Become an Expert by learning from the Experts!

This course will make you an expert in Microsoft Excel, a skill that is highly valued by ALL employers and one which will make you stand out from the crowd.

All of the key advanced Excel skills are covered in depth in this course with the added major benefit of preparing you to take the only official Microsoft Certification exam in Excel Expert (Office 2019) – the MO-201 Microsoft Office Specialist Expert exam.

Every aspect of the MO-201 exam is covered in detail, together with a selection of exercises and video solutions.

Delivered by a University Lecturer with many years experience in teaching Excel to undergraduate students, and who is also a MOS Master and Microsoft Office Specialist examiner, if you take this course and follow the guidelines provided, you will significantly enhance your chances of obtaining this valuable independent certification from Microsoft.

MOS Excel Expert certification is highly regarded by employers because it is independent proof that you have the skills to become productive straight away. That saves a lot of time and effort on the employers part and they value that very highly indeed! Our mission is to make you succeed in passing the MO-201.

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

Instructors

Dave Murphy
University Lecturer

Rating Distribution

1 stars: 1 votes

2 stars: 5 votes

3 stars: 16 votes

4 stars: 85 votes

5 stars: 125 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!