MO-200: Excel Associate Certification

Excel 2019 Associate Certification MO-200 Course Description

Excel 2019 Associate Certification will help demonstrate that you have the skills needed to get the most out of Excel by earning the Microsoft Office Specialist: Excel Associate Certification. This class will get you prepped for certification testing to demonstrate 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.

Lesson 1 – Manage and Share Workbooks

1.1 Manage Multiple Workbooks

1.2 Prepare Workbooks for Review

1.3 Manage Workbook Changes

Lesson 2 – Apply Custom Formats and Layouts

2.1 Apply Custom Data Formats

2.2 Apply Advanced Conditional Formatting and Filtering

2.3 Apply Custom Styles and Templates

2.4 Prepare Workbooks for Internationalization and Accessibility

Lesson 3 – Create Advanced Formulas

3.1 Apply Functions in Formulas

3.2 Look Up Data by Using Functions

3.3 Apply Advanced Date and Time Functions

3.4 Create Scenarios

Lesson 4 – Create Advanced Charts and Tables

4.1 Create Advanced Chart Elements

4.2 Create and Manage PivotTables

4.3 Create and Manage PivotCharts