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