Microsoft Excel Certification
Microsoft Office Specialist Program
Microsoft Excel (Office 2019): Exam MO-200


Course Description
The Excel 2019 course demonstrates new features for working with your data all while preparing a user to sit for the Excel 2019 certification exam. Learn to use Excel to visualize data and to better present your data to be easily understood. Improve your employability by learning how to manage worksheets and workbooks; manage data cells, ranges, and tables; use formulas and functions; and create, modify, and format charts.
The Microsoft Office Specialist: Excel Associate Certification demonstrates competency in the fundamentals of creating and managing worksheets and workbooks, creating cells and ranges, creating tables, applying formulas and functions and creating charts and objects. The exam covers the ability to create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook examples include professional-looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.
An individual earning this certification has approximately 150 hours of instruction and hands-on experience with the product, has proven competency at an industry associate-level and is ready to enter into the job market. They can demonstrate the correct application of the principal features of Excel and can complete tasks independently.
Microsoft Office Specialist Program certification exams use a performance-based format testing a candidate’s knowledge, skills and abilities using the Office 2019 programs:
-
Microsoft Office Specialist Program exam task instructions generally do not include the command name. For example, function names are avoided, and are replaced with descriptors. This means candidates must understand the purpose and common usage of the program functionality in order to successfully complete the tasks in each of the projects.
-
The Microsoft Office Specialist Program exam format incorporates multiple projects as in the previous version, while using enhanced tools, functions, and features from the latest programs.