MO-201 - MOS Excel Expert 2019/365 Microsoft Certification

Two practice tests similar to the MO-201 exam, 33 Lectures, 10 Projects, 43 Assignments

3.30 (200 reviews)
Udemy
platform
English
language
IT Certification
category
1,089
students
4.5 hours
content
Apr 2022
last update
$79.99
regular price

What you will learn

By completion of the course, the students will be well prepared to take the MO-201 exam

Description

----- UPDATED April 2022 -----

Added 5 new projects


----- UPDATED March 2021 -----

Changed a few lectures and some aspects of the structure of the course


----- UPDATED January 2021 -----

Featured questions in the Q & A section of the course


----- UPDATED DECEMBER 2020 -----

Added one more lecture


The TEST4U MO-201 Exam - MOS Excel Expert 2019/365 Microsoft Certification Course

The TEST4U team realized that there is a need for a complete hands-on Training system for the MO-201 exam, so we created the MO-201 Exam - MOS Excel Expert 2019/365 Microsoft Certification course. It is targeted to people, who want to succeed in the MO-201 exam.


The Course at a glance

In this course you will find:

  • 43 assignments properly categorized

  • 43 distinct files for each of the above assignments

  • 43 solution videos for every assignment

  • 10 project questions similar to the ones you will face in the exam

  • 33 lectures explaining certain interesting subjects of the MO-201 syllabus

  • 2 lectures explaining the examination process and the structure of the multi-project question


The Course in detail


43 assignments properly categorized

In this course you will practice on the following categories:

1. Manage Workbook Options and Settings

2. Manage and Format Data

3. Create Advanced Formulas and Macros

4. Manage Advanced Charts and Tables

5. Financial Functions

6. Projects


43 distinct files for each of the above assignments

Each and every assignment comes with its distinct file(s) that are necessary to answer the assignment


43 solution videos for every assignment

All assignments are accompanied by detailed video solutions. We recommend you try to solve the assignments without viewing the solution. This way you will better understand your limitations and be able to focus on them. You can then see the video after you have solved it, to know if you answered the question correctly.


10 project questions similar to the ones you will face in the exam

Since the release of Office 2016, Microsoft introduced a new kind of examination. This examination consists of multiple project questions. We have included 5 such project questions in this course


Fast feedback from our instructors

We give feedback to all assignments, usually within one or two working days. Although in many cases we have been known to answer within a few hours.


In this course we have focused on the practical side. What does that mean? That almost all the content you will find in this lecture is in the form of assignments. You will gain practical, hands-on experience by solving these assignments and you will get feedback by uploading them in the Udemy platform.

We are involved in the IT Training field since 2003 and have successfully trained almost a million students. Our focus to the practical side of education has proven to be a lot more effective than just reading a book or watching a lecture.



Content

Introduction

Introduction
How to submit an assignment

Manage Workbook Options and Settings

Manage and Format Data

Create Advanced Formulas and Macros

The AVERAGEIFS Function
The COUNTIFS Function
The INDEX Function
The CHOOSE Function
The MATCH Function
The OFFSET Function
The VLOOKUP Function
The HLOOKUP Function
Advanced Lookup Formulas I (VLOOKUP-MATCH, VLOOKUP-HLOOKUP)
Advanced Lookup Formulas II (OFFSET-MATCH-MATCH)
Advanced Lookup Formulas III (INDEX-MATCH, INDEX-MATCH-MATCH)

Manage Advanced Charts and Tables

Pivot Tables
Pivot Charts
Slicers

Financial Functions

The Functions PV, FV, NPER, RATE
The Functions PMT, IPMT, PPMT
The Functions NPV, XNPV
The Functions IRR, MIRR, XIRR
The Functions DOLLARFR, DOLLARDE
The Functions YIELD, YIELDDISC, YIELDMAT
The Functions DISC, RECEIVED, INTRATE
The Functions PRICE, PRICEMAT, PRICEDISC
The Functions ACCRINT, ACCRINTM
The Functions COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPNUM, COUPPCD
The Functions DURATION, MDURATION
The Functions SLN, SYD, DB, DDB, VDB
The Functions TBILLEQ, TBILLPRICE, TBILLYIELD

Multi-Project Questions (as seen in the MOS exam)

MOS 2019 / 365 exam procedure (It remains the same as the 2016 exams)
Multi-Project Questions Description (It remains the same as the 2016 exams)

Epilogue

What is TEST4U?
Benchmark and Assessment
Epilogue
BONUS lecture

Screenshots

MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Screenshot_01MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Screenshot_02MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Screenshot_03MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Screenshot_04

Reviews

Gabriel
September 17, 2023
I already passed the MO201 not thanks to this course -- the general knowledged presented in this course is alright but it doesn't resemble what's evaluated in MO201 at all.
Thaw
August 26, 2023
Hi, When I was searching for a suitable Excel expert course I found this course. The approach of this course is different from other courses. It prepares you for the exam very well. One can prepare for his/her exam within a short period of time if he/she has some basic knowledge of Excel. Test4U platform is best to practice for exams. It mimics exactly the exam interface. I found some same questions came in the exam too. Thank you. Thaw
Sonia
July 26, 2023
This is the 3rd training I have taken with Test4U and the other 2 definitely def helped me past my other 2 exams - Access Expert, and Excel MO200. I am confident this training will help me pass my next exam.
Ferdinand
January 10, 2023
The course is well put together. Even though I use Excel regularly, I was challenged in each section and learned a lot of new features.
Alexander
January 6, 2023
This is one of the best courses I have taken. Many practical examples, well-demonstrated. And most of all, the instructor is THE most helpful and constructive I have ever seen, he responds quickly and gives very understandable answers. How well this matches the actual MO-201 exam, will remain to be seen. But I have learned a lot and discovered some new functions that I never knew existed in 24 years in controlling.
Laura
November 28, 2022
Very comprehensive and “easy” course to follow. All it takes is a little bit of self-discipline to get yourself to do all the tasks included. You’ll be ready in no time!
Uta
October 27, 2022
This course has really been the key to helping me unlock my potential to passing the exam. I was intimidated at first, however I decided to give the exam a try, since it was kind of requirement for my job. Answering all the questions in Udemy was my first priority and then I realized that I was given access to some extra training software, as an exam simulation tool. That turned out to be absolutely great. It automatically checked the correctness of my responses and gave me instant video-solutions upon mistakes. I couldn’t be happier with my progress and my passing score!
Pablo
October 11, 2022
What a great course! Congratulations to the team! I recommend the course to anyone looking for MO201 preparation!
John
October 4, 2022
This course compares to no other when it comes to the quality of assignments and plentitude of questions.
Bill
October 4, 2022
Just follow my advice and ask for the free access to the bonus software they advertise. It comes free of charge just because you enrolled in the course and is a life-savior.
Kulvinder
September 30, 2022
Using Excel in an expert level is a challenge on its own, so I consider myself rather lucky to have found this course and have gained such high-level skills. Congrats to the instructor for the well-shaped course design.
Sabine
September 23, 2022
A course that is worth all 5 stars imo! Simplifies the less known areas and gives you a totally different understanding towards a professional approach.
Tsipa
September 9, 2022
This course was for me all it took to pass the exam! Interesting, involving, up-to-date and efficient training material.
Lia
August 29, 2022
This course is the demystification of Excel. Honestly, it looks far less daunting after having realized the whys and hows. If you are looking to just pass the exam, there is good news: you also get to learn how to use the application. As I have said before, I surely recommend it and I am planning to learning more skills this way.
Sahota
June 17, 2022
This is a perfect example of a course that was meticulously designed by subject matter experts. It is high-quality, targeted training that helps anyone achieve their goal. Fear not the MO201 exam, cause this is all you need. Hint: Make sure to ask for access to the extra software.

Charts

Price

MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Price chart

Rating

MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Ratings chart

Enrollment distribution

MO-201 - MOS Excel Expert 2019/365 Microsoft Certification - Distribution chart
2408162
udemy ID
6/11/2019
course created date
11/21/2019
course indexed date
Bot
course submited by