MO-210 & MO-200 Microsoft Excel Certificate Exam Prep tests
Lectures, Practice exams, assignments, video solutions for MO-210 (Microsoft 365) & MO-200 (Office 2019)
What you will learn
You will be 100% prepared for your next MO-210 or MO-200 exam
Complete Exam syllabus coverage: How to manage Worksheets and Workbooks
You will learn how to handle the new project questions by Certiport
You will learn how to manage Data Cells and Ranges
Get hands-on experience by putting all this knowledge into action immediately
You will learn ways to manage Tables and Table Data
Guidance by a dedicated, responsive team of IT trainers with 20+ years of experience
You will learn how to Perform Operations by using Formulas and Functions
Lifetime access to all the material included in this Udemy course
You will learn how to manage Charts
Why take this course?
Massive update December 2022
This Excel course is 2 courses in 1.
It contains all the study and training material for Candidates for the following certification exams
MO-210 (Microsoft Excel 365) as well as for
MO-200 (Excel 2019).
More than 1.000.000 students have trusted TEST4U for their successful exam preparation since 2003.
Among them have been MOS World Champions! This is how efficient this way of learning is!
Just take a look at these stories below:
*******************************
“It's simple to use, has a lot of different tasks, good looking interface and was of great help while I was preparing for the MOS 2018 World Championship.”
Tarik D.
“It was a great course. I loved how they had a mix of video lecture and hands-on practice. I really appreciate that they let me go back and review the course as much as I needed and they provided me with 5 hours of Test4U practice time which gave me a sense of what to expect on the exam. I took both the Associate and Expert exams on the same day and did awesome on both (976 for Associate and 972 for Expert)! Thank you Udemy for providing this training!”
Angie K S.
*******************************
WHAT TO EXPECT FROM THIS COURSE?
- Do you wish you too could pass the Microsoft Office Specialist Exam MO-210 or MO-200 fast and easy?
- Do you hate spending too much time on the same, boring, basic staff?
- Do you wish you had an experienced, responsive team to support and guide you every step of the way, with premium resources and 20+ years of expertise?
Well, then you are in the right place, at the right time! This course will guide you all the way from the beginning to make you achieve the desired industry associate level of skills to pass the MO-210 or MO-200 exams.
In fact, we have designed this course in such a way, so that by the time you finish the practice tests and assignments, we believe that you will be 100% ready to take the MO-210 or MO-200 exams and achieve an excellent passing score!
WHY TRUST US?
That’s because we have been teaching IT skills and have been preparing students to take such exams for more than 20 years. Our strategy delivers optimum passing results and this is why students keep returning to purchase more courses and pass more exams with flying colors!
Our proven method of teaching will:
Keep your interest rate high
Keep you engaged at all times
Guide you all the way
Make you experiment and learn by doing
Above all, our method of teaching will make you ready to pass your MO-210 or MO-200 exams.
This is not just our saying! Read what our students have said about our way of teaching!
*******************************
“What I enjoyed when getting involved with this course is the fact that it is not just video-watching. You need to get your hands dirty and actually solve exercises, which is the only way to gain a new skill. Let’s be honest, learning how to use an Office suite is nothing like learning about history of arts, so practice needs to be on the table. For anyone who is interested in learning instead of wasting a few Euro, this is the course to choose.”
Oliver B.
“This course serves a double cause: First it helps you get the certificate with minimum effort since the questions are almost the same. Practicing on the extra software makes you ready. Secondly, the course actually teaches you how to use excel in an engaging way. Although I enrolled because I wanted to pass the exam, I realized that the second cause was far more important.”
Meghan
*******************************
HOW IS THIS COURSE DIFFERENT?
When you start learning by the way that we have been teaching all these years, you’ll discover the great power that comes with the learning by doing approach.
Apart from lectures, assignments and video-solutions, we have included in this course Practice Exams that familiarize you with the exam interface and recreate real exam conditions. This is how a double purpose is served:
You will learn how to properly use Excel as well as
Prepare adequately for your Certification exam.
There is even more.
By joining this course, you have access to 300+ Performance based exam simulation questions for Windows or Mac. These are Live-in-the-app questions which let you interact with the installed applications to get your hands dirty and make you learn by doing.
Soon you will feel confident enough that you have done all the practice that is necessary, so as to be and feel prepared for your MO-210 or MO-200 exams.
The skills you will have gained by this course:
Are practical and will follow you even if you use another Microsoft Office version
Are hard-to-forget and can be put immediately to work
Will get you to pass the exam, without even realizing you are being tested
Will shape the way you use technology
YOU ONLY NEED THIS COURSE IF...
Here’s the bottom line.
You need this course because it’s a pity to waste all the exam fee money and have to take it all over again. Get there adequately prepared and pass it the first time.
You also need this course because the new Microsoft Office Specialist certification exam is rather hard and you need all the help you can have.
But most importantly, you need this course because it will not only help you pass the certification exams, but also give you the great advantage of actually gaining new skills and improving the way you have been using technology so far.
Enroll today and benefit from Udemy’s no-questions-asked, 30-day, money-back guarantee.
More than 1.000.000 students have trusted the TEST4U way of learning since 2003. Be the next one.
*******************************
“The course gives good overview of what you need to know and how to apply it in and beyond the course. I purchased the whole series (MO100, 200, 300, 101, 201 and 500) and passed all of them including the MO-400. Teacher explains in a very easy and controlled way how to solve the questions and how to perform an action.”
Rob V.
*******************************
THE COURSE AT A GLANCE
In this course you will find:
52 lessons explaining certain interesting subjects of the MO-210 and MO-200 syllabi, accompanied by
52 lesson files to help you reproduce everything that you watch
2 lessons explaining the examination process and the structure of the multi-project question
127 assignments properly categorized
127 distinct exercise files for each of the above assignments
127 solution videos for every assignment
2 practice exams which contain 80+ exam-like tasks!!!
300+ Performance based exam simulation questions
THE COURSE IN DETAIL
52 lessons explaining certain interesting subjects of the MO-210 and MO-200 syllabi, accompanied by 52 lesson files to help you reproduce everything that you watch
Starting from scratch, we explain everything that is necessary for you to gain the skills needed and go ace the MOS exam. To help you practice on what you see, we give you access to the same files that we have used during our video-making, so that you can practice at your own pace.
2 lessons explaining the examination process and the structure of the multi-project question
Preparing for exam participation is not just knowing the syllabus. You need to also be familiar with the exam environment and interface. Here we explain to you all the MOS exam secrets, so that you get no surprises on the exam day!
127 assignments properly categorized
In this course you will practice on the following categories:
Manage Worksheets and Workbooks
Manage Data Cells and Ranges
Manage Tables and Table Data
Perform Operations with Formulas and Functions
Manage Charts
Projects
127 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
127 solution videos, one 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.
2 Practice exams similar to the ones you will face in the exam
This is very important!
Certiport has introduced a new kind of examination, which consists of multiple project questions. To help you understand how to approach this exam and give you the chance to practice on such exam formats, we have included 2 such practice exams in this course which contain 80+ exam-like tasks.
300+ Performance based exam simulation questions
Grab your Windows or Mac PC to gain access to 300+ or 130+ Performance-based exam simulation questions respectively! Performance-based exam simulation questions help you put all your newly gained knowledge into practice immediately and transform it into hard skills on Microsoft Excel.
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.
*******************************
MICROSOFT OFFICE SPECIALIST EXAM OBJECTIVE DOMAINS
1) MANAGE WORKSHEETS AND WORKBOOKS
Import data into workbooks
Import data from text files
Import data from online sources (only for MO-210 exam)
Import data from .csv files (only for MO-200 exam)
Navigate within workbooks
Search for data within a workbook
Navigate to named cells, ranges, or workbook elements
Insert and remove hyperlinks
Format worksheets and workbooks
Modify page setup
Adjust row height and column width
Customize headers and footers
Customize options and views
Manage the Quick Access toolbar
Display and modify worksheets in different views
Freeze worksheet rows and columns
Change window views
Modify built-in workbook properties
Display formulas
Prepare workbooks for collaboration and distribution
Set a print area
Save and export workbooks in alternative file formats
Configure print settings
Inspect workbooks and correct issues
Manage comments and notes (only for MO-210 exam)
2) MANAGE DATA CELLS AND RANGES
Manipulate data in worksheets
Paste data by using special paste options
Fill cells by using Auto Fill
Insert and delete multiple columns or rows
Insert and delete cells
Generate numeric data by using RANDBETWEEN() and SEQUENCE() (only for MO-210 exam)
Format cells and ranges
Merge and unmerge cells
Modify cell alignment, orientation, and indentation
Format cells by using Format Painter
Wrap text within cells
Apply number formats
Apply cell formats from the Format Cells dialog box
Apply cell styles
Clear cell formatting
Format multiple worksheets by grouping (only for MO-210 exam)
Define and reference named ranges
Define a named range
Reference a named range (only for MO-210 exam)
Name a table (only for MO-200 exam)
Summarize data visually
Insert Sparklines
Apply built-in conditional formatting
Remove conditional formatting
3) MANAGE TABLES AND TABLE DATA
Create and format tables
Create Excel tables from cell ranges
Apply table styles
Convert tables to cell ranges
Modify tables
Add or remove table rows and columns
Configure table style options
Insert and configure total rows
Filter and sort table data
Filter records
Sort data by multiple columns
4) PERFORM OPERATIONS BY USING FORMULAS AND FUNCTIONS
Insert references
Insert relative, absolute, and mixed references
Use structured references in formulas (only for MO-210 exam)
Reference named ranges and named tables in formulas (only for MO-200 exam)
Calculate and transform data
Perform calculations by using the AVERAGE(), MAX(), MIN() and SUM() functions
Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions
Perform conditional operations by using the IF() function
Sort data by using the SORT() function (only for MO-210 exam)
Get unique values by using the UNIQUE() function (only for MO-210 exam)
Format and modify text
Format text by using RIGHT(), LEFT(), and MID() functions
Format text by using UPPER(), LOWER(), and LEN() functions
Format text by using the CONCAT() and TEXTJOIN() functions
5) MANAGE CHARTS
Create charts
Create charts
Create chart sheets
Modify charts
Add data series to charts
Switch between rows and columns in source data
Add and modify chart elements
Format charts
Apply chart layouts
Apply chart styles
Add alternative text to charts for accessibility