Microsoft Excel Intermediate

Issued by Santa Fe Community College

Earners of the Microsoft Excel Intermediate badge demonstrate skills using Microsoft Excel to create intermediate level worksheets and workbooks. They can arrange and calculate data across multiple worksheets and manage large tables of data for decision making.

Type Learning
Level Foundational
Time Hours

Skills

Calculations
Cell Formatting
Charts
Conditional Formatting
Data Entry
Decision Making
Formulas And Functions
Microsoft Excel
Sorting

Earning Criteria

Complete Microsoft Excel Intermediate Course including up to 12 hours of training and practice.
Arrange and calculate data across multiple worksheets.
Demonstrate ability to work with the formula auditing toolbar including tracing precedents and dependents and inserting commands.
Creating, using and managing range names.
Demonstrate ability to manage large tables of data including filtering and sorting.
Calculate with dates.
Demonstrate understanding of order of precedence, absolute and relative cell references and using the show formulas tool.