Course Information
Course Overview
Two practice tests similar to the MO-201 exam, 33 Lectures, 10 Projects, 43 Assignments
----- 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.
Course Content
- 10 section(s)
- 33 lecture(s)
- Section 1 Introduction
- Section 2 Manage Workbook Options and Settings
- Section 3 Manage and Format Data
- Section 4 Create Advanced Formulas and Macros
- Section 5 Manage Advanced Charts and Tables
- Section 6 Financial Functions
- Section 7 Multi-Project Questions 1 (as seen in the MOS exam)
- Section 8 Multi-Project Question 2 (as seen in the exam)
- Section 9 Epilogue
- Section 10 BONUS Lecture
What You’ll Learn
- By completion of the course, the students will be well prepared to take the MO-201 exam
Skills covered in this course
Reviews
-
AAhmad Almaleh
Wonderful training material
-
AAlexander Meneikis
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.
-
LLaura Spark
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!
-
UUta Michael
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!