MO-201 Complete Techniques for the MOS Excel Expert Exam

Description

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 365/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! The messages and reviews on our other Excel Expert Course for Excel 2016 speak for themselves. Our mission is to make you succeed in passing the MO-201. You can do it with our help!

What you will learn...

Create and Modify Pivot Tables

Create Pivot Tables

Modify Pivot Table Field Selections and Options

Create Slicers for Data Analysis

Group Pivot Table Data

Add Pivot Table Calculated fields

Format Data in Pivot Tables

Create and Modify Pivot Charts

Create Pivot Charts

Manipulate Options in Existing Pivot Charts

Apply Styles to Pivot Charts

Drill Down into Pivot Chart Details

Perform Logical Operations in Formulas

Perform Logical Operations by using Nested Functions including the IF(), IFS(), SWITCH(), SUMIF(), AVERAGEIF(), COUNTIF(), SUMIFS(), AVERAGEIFS(), COUNTIFS(), MAXIFS(), MINIFS(), AND(), OR() and NOT() Functions

Look Up Data by using Functions

Look Up Data by using VLOOKUP(), HLOOKUP(), MATCH() and INDEX() Functions

Use Advanced Date and Time Functions

Reference Date and Time by using the NOW() and TODAY() Functions

Calculate Dates by using the WEEKDAY() and WORKDAY() Functions

Perform Data Analysis

Summarise Data from Multiple Ranges by using the Consolidate Feature

Perform What-if Analysis by using Goal Seek and Scenario Manager

Forecast Data by using the AND(), IF() and NPER() Functions

Troubleshoot Formulas

Trace Precedence and Dependence

Monitor Cells and Formulas by using the Watch window

Validate Formulas by using Error Checking rules

Evaluate Formulas

Manage Macros and Workbooks

Create and Modify Simple Macros

Copy Macros Between Workbooks

Reference Data in Other Workbooks

Enable Macros in a Workbook

Manage Workbook Versions

Prepare Workbooks for Collaboration

Restrict Editing

Protect Worksheets and Cell Ranges

Protect Workbook Structure

Configure Formula Calculation Options

Manage Comments

Use and Configure Language Options

Configure Editing and Display Languages

Use Language Specific Features

Advanced AutoFill Options

Fill Cells by using Flash Fill

Fill Cells by using Advanced Fill Series Options

Format and Validate Data

Create Custom Number Formats

Configure Data Validation

Group and Ungroup Data

Calculate Data by Inserting Sub Totals and Totals

Apply Advanced Conditional Formatting and Filtering

Create Custom Conditional Formatting Rules

Create Conditional Formatting Rules That Use Formulas

Manage Conditional Formatting Rules

Here are some recent messages and reviews from our students about our Microsoft Excel 2016 Expert certification courses.....

From Delia

I've covered the Excel Expert syllabus using other courses from LinkedIn and I've also tried the Microsoft books on the subject. This is the most comprehensive coverage of the syllabus for the Excel Expert exam. All of the topics are covered in depth with great examples for getting used to the way the questions are posed in the test. Extremely highly recommended!

From Amanda

"I studied Lynda and took the Excel Expert Exam and made a 389. I regrouped and bought Dave's study material, including the practice exams. I learned so much more material that wasn't covered on Lynda through Dave's videos. I took the exam three weeks after studying Dave's tutorials and passed the exam with a 795."

From Christie

"Dave,

Thanks for the great course! I easily passed the Excel Expert exam a couple weeks ago thanks to the materials covered in your course! The lectures were easy to understand and all of the content from your course very relevant in preparing for the exam.

Cheers!

Christie"

From Aicha

" I just passed the test today with 769 !! :) Just can't be happier. The course is really well structured and helpful especially the exercises at the end of each objective !! Thanks Dave , You did a great Job"

From Branislav

"Very specific and targeted topics. I believe it a must for all who attempt the exam."

From Taylor

I can't post it here but I will show my badge earned in the Facebook group. I've been studying for roughly a month, with basic data entry experience, and a BCIS course I took in highschool. Needless to say I wasn't very well versed in excel to begin with, and now im an Excel Expert. Im always skeptical about what I buy and strive to recommend as little as possible to friends and family through fear of worth. But this course here is incredible and I can't thank Dave enough for the time and effort he put into it. I'm a bit of a talker to, and Dave was able to get back to me with answers regarding questions I had about the Exam in a very timely manner. Regards, Taylor"

Who this course is for:

• 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