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
(10-15% of exam content)
Import data into workbooks
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
Customize options and views
- Customize the Quick Access toolbar
- Display and modify workbook content in different views
- Freeze worksheet rows and columns
- Change window views
- Modify basic workbook properties
- Display formulas
Configure content for collaboration
(20-25% of exam content)
Manipulate data in worksheets
- Paste data by using special paste options
- Fill cells by using Auto Fill
- Insert and delete multiple columns or rows
- Insert and delete cells
Format cells and ranges
- Merge and unmerge cells
- Modify cell alignment, orientation, and indentation
- Format cells by using Format Painter
- Wrap text within cells
- Apply number formats
- Apply cell formats from the Format Cells dialog box
- Apply cell styles
- Clear cell formatting
Define and reference named ranges
Summarize data visually
(15-20% of exam content)
Create and format tables
Modify tables
Filter and sort table data
(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:
- Count cells by using these functions:
- Perform conditional operations by using the IF() function
Format and modify text
- Format text using functions:
- Format text by using the CONCAT() and TEXTJOIN() functions
See also
(20-25% of exam content)
Create charts
Modify charts
- Add data series to charts
- Switch between rows and columns in source data
- Add and modify chart elements