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.

Course Topics

Manage worksheets and workbooks

• Import data into workbooks
• Import data from delimited text files
• 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
• How to customize the Quick Access Toolbar
• Modify the display of content

Display multiple parts of a worksheet

• Display formulas
• Modify basic workbook properties
• Configure content for collaboration
• Inspect workbooks for issues
• Print workbook content

Save workbooks in alternative file formats

• Manage data cells and ranges
• Manipulate data in worksheets
• Create data
• Reuse data

Modify worksheet structure

• Format cells and ranges
• Merge and unmerge cells
• Modify cell alignment, orientation, and indentation

Wrap text within cells

• Apply cell formats and styles
• Apply number formats
• Reapply existing formatting
• Define and reference named ranges
• Summarize data visually
• Format cells based on their content
• Insert sparklines
• Manage tables and table data
• Create and format tables
• Create an Excel table from a cell range
• Apply styles to tables

Convert a table to a cell range

• Modify tables
• Add or remove table rows and columns
• Configure table style options
• Filter and sort table data
• Filter tables
• Sort tables
• Perform operations by using formulas and functions
• Insert references in formulas
• Insert relative, absolute, and mixed references
• Referenced named cell ranges and tables in formulas
• Calculate and transform data by using functions
• Perform calculations by using the SUM(), AVERAGE(), MAX(), and MIN() functions
• Count cells by using the COUNT(), COUNTA(), and COUNTBLANK() functions

Perform conditional operations by using the IF () function

• Format and modify text by using functions
• Select text by using the LEFT(), MID(), and RIGHT() functions
• Format text by using the UPPER (), LOWER(), and PROPER() functions

Count characters by using the LEN() and LENB() functions

• Combine text by using the CONCAT() and TEXTJOIN() functions
• Manage Charts
• Create Charts
• Modify Charts
• Modify chart content
• How to modify chart elements
• Format charts
• Apply layouts and styles
• Provide alternative text for accessibility