MO-200: Excel Associate Certification

Course: 9147

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.

 

Download PDF
  • Duration: 1 day
  • Price: $325.00
Get This Course $325.00
February 20

9:00 AM – 4:00 PM CST

March 20

9:00 AM – 4:00 PM CST

April 17

9:00 AM – 4:00 PM CST

May 22

9:00 AM – 4:00 PM CST

June 19

9:00 AM – 4:00 PM CST

July 17

9:00 AM – 4:00 PM CST

August 21

9:00 AM – 4:00 PM CST

September 18

9:00 AM – 4:00 PM CST

October 23

9:00 AM – 4:00 PM CST

December 18

9:00 AM – 4:00 PM CST

Scroll to view additional course dates

Reserve Your Seat

  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • Virtual instructor Led Training
  • Complete Hands-on Labs
  • Softcopy of Courseware
  • Learning Labs
  • You can use your Purchase Card and checkout
  • The GSA Contract Number: 47QTCA20D000D
  • Call 800-453-5961 for details
  • Customize your class
  • Delivery Onsite or Online for your organization
  • Choice of Dates when and where you want
  • Guidance in choosing and customizing your class

Question About this Course?

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

 

Question About this Course?

Need help picking the right course?

Contact Us

Call Now

Call Now800-453-5961