
Discover how the MO-200 exam is conducted: register with Certiport, choose a testing center or remote option, and complete a project-based test with 5–7 projects, 35 tasks, in 50 minutes.
Navigate the MO-200 course structure and best approach to practice exams by using downloadable Excel files with tasks, enabling macros, and reviewing video solutions to reinforce learning.
Exam 1 Project 1 zip file
Create a cluster column chart in Excel showing noncontiguous country sizes, apply monochromatic seven color palette, adjust layout and axes, and move the chart to a worksheet named destination chart.
Practice exam project three tasks in Excel: uppercasing surnames with a formula, setting column width to 12, wrapping text, creating a named range, concatenating emails with concat, and left-aligning text.
Create an Excel table, delete a row, filter data, sort by complaints and month, calculate the average monthly complaints, and apply conditional formatting to highlight over 5000.
Merge and center cells, shift data up, and build a count blank formula. Apply filters and insert win/loss chart to compare Excel, Word, and Access values within a date range.
Learn core Excel skills for MO-200 with exam 1 project 6: absolute references, creating a table named customers, and building a line chart to compare 2020 contributions and 2021 forecast.
Complete exam 2 project 2 tasks in Excel: edit named ranges, apply euro formatting with decimals, center values, sort by office, insert line graph with labels, and count units sold.
Create a line chart of total hits by location from the website hits table, then insert and format the chart, and set the table's subject to Web interactions.
Present the exam two project six solution, covering filtering salary data and if-then bonuses. Demonstrate building formulas with left, right, and concat using insert function, plus currency and image formatting.
Verify if actual profit meets the target profit using a true/false condition; display 'Target Mass' or 'failure', then apply conditional formatting, concatenate cells, and create a 3D pie chart.
Sort data by two levels: destination ascending and payment type descending, then import text data into a new worksheet with headers and set column width to 12.
Learn to analyze budgets in Excel by calculating year averages, applying above-average conditional formatting, building clustered budgets by year and category, and moving charts to a budget-tracking worksheet.
Insert a semi transparent black hexagon with a bottom left shadow in excel, then build a last name length times spending customer code and join text with a slash.
These functions are not on the MO-200 syllabus but it has been reported to me that the RANDBETWEEN() function has appeared as a task. Review the lecture ......just in case, and if a task does appear in your test which requires either of these functions report it at the end.
Reviews Update 1 - Student scores 1000/1000 in MO-200 exam!
"I like having multiple project tasks to be able to complete/practice; with a good variety in questions. Its also extremely helpful to my learning to then to be able to watch the video solutions after. Update: I took the certification exam and scored 1000/1000!!! Using this course, I was completely prepared for the questions!!! Definitely recommend."
Reviews Update 2 - Student wins UK & Ireland MOS Excel Championship. Qualifies for World Championship!
One of our students has completed against 30,000 other competitors to win the UK & Ireland MOS Championship in Excel. She will now go on to compete in the World Championship in November. This is a major achievement and we are proud to have been part of this students preparation and success.
The above level of achievement doesn't happen without effort and the correct preparation. Our instructors REALLY know what is required if you are to succeed in your MOS exam at the 1st attempt. Don't risk your exam fees! MOS University will make sure that you have the best possible chance to obtain these valuable certifications. Our expert instructors are all MOS Masters and University Professors with many years experience in preparing students to take MOS exams. Up to date materials, expert tuition, focused exercises and sample exam questions will all ensure that your pathway to success is assured.
Course Overview
The purpose of this course is to provide you with three complete practice exams which are prepared at the level required to pass the MO-200 Microsoft Certification Associate exam in Excel 2019.
Each practice exam is divided into six projects with a total of 35 tasks for each exam. That's 21 projects and 105 project tasks all geared towards the MO-200 exam.
Advice on preparation, how to approach the exam, what the interface will look like and which areas of the Objective Domain to focus on is provided.
Tips on issues you will encounter with particular questions types are also included.
The solutions to all of the practice projects are provided in the form of video lectures in which the instructor explains how to approach the project and how the solutions are derived.
If you can master the practice projects included in this course you will be 100% confident in your abilities to pass the MO-200 Excel (Office 2019) Associate Certification exam.
Make a REAL difference to your CV. Demonstrate that you have PROVEN skills and can be an asset to any organization.