The Microsoft Office Specialist: Excel Associate Certification demonstrates 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. The exam covers the ability to create and edit a workbook with multiple
sheets, and use a graphic element to represent data visually. Workbook examples
include professional-looking budgets, financial statements, team performance charts,
sales invoices, and data-entry logs.
An individual earning this certification has approximately 150 hours of instruction and
hands-on experience with the product, has proven competency at an industry
associate-level and is ready to enter into the job market. They can demonstrate the
correct application of the principal features of Excel and can complete tasks
independently.
Course Outline
Manage Worksheets and Workbooks
- Import data into workbooks
- Navigate within workbooks
- Format worksheets and workbooks
- Customize options and views
- Configure content for collaboration
Manage Data Cells and Ranges
- Manipulate data in worksheets
- Format cells and ranges
- Define and reference named ranges
- Summarize data visually
Manage Tables and Table Data
- Create and format tables
- Modify tables
- Filter and sort table data
Perform Operations by using Formulas and Functions
- Insert references
- Calculate and transform data
- Format and modify text
Manage Charts
- Create charts
- Modify charts
- Format charts