Skills Measured

As a candidate for Excel certification, you must demonstrate your skills creating and managing workbooks, ranges, tables, charts, and using formulas and functions.

Please note that the exam may test on, but will not be limited to, the topics described below.

Links to Microsoft videos and articles are provided below for many of the exam topics. Some of these articles have different instructions depending on the version of Excel being used. If multiple sets of instructions are listed, make sure to select Windows rather than MacOS or Web, and/or Office 365/2019 or Newer Versions rather than Office 2016 or earlier.

Links in the See Also section at the bottom of each skillset group may also be helpful.

Exam Objectives

Manage worksheets and workbooks

(10-15% of exam content)

Import data into workbooks

Navigate within workbooks

Format worksheets and workbooks

Customize options and views

Configure content for collaboration

Set a print area
Save workbooks in alternative file formats
Configure print settings
Inspect workbooks for issues

Manage data cells and ranges

(20-25% of exam content)

Manipulate data in worksheets

Format cells and ranges

Define and reference named ranges

Define a named range
Name a table (also, Name Manager)

Summarize data visually

Manage tables and table data

(15-20% of exam content)

Create and format tables

Modify tables

Filter and sort table data

Apply Formulas and Functions

(20-25% of exam content)

Insert references

Create formulas (formula basics, about the formula bar)

Calculate and transform datas

Perform calculations by using these functions:
- AVERAGE()
- MAX()
- MIN()
- SUM()
Count cells by using these functions:
Perform conditional operations by using the IF() function

Format and modify text

Format text using functions:
- RIGHT()
- LEFT()
- MID()
- UPPER()
- LOWER()
- PROPER()
- LEN()
Format text by using the CONCAT() and TEXTJOIN() functions