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.
/0x35:2400x1566/prod01/channel_34/media/seattle-university/albers-school-of-business/academics/undergraduate-and-advising/-images/Physics_yck_ClassRoom_01.jpg)
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
Format worksheets and workbooks
Customize options and views
Configure content for collaboration
- Inspect workbooks for issues
(20-25% of exam content)
Manipulate data in worksheets
Format cells and ranges
- , and indentation
Define and reference named ranges
- (also, )
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
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 and functions
See also
(20-25% of exam content)