Participants will gain a fundamental understanding of the Excel environment and the ability to complete tasks independently. They will know and demonstrate the correct application of the principal features of Excel 2016. Participants will create and edit a workbook with multiple sheets, and use a graphic element to represent data visually. Workbook example include professional looking budgets, financial statements, team performance charts, sales invoices, and data-entry logs.

 

Module 1

Create and Manage Worksheets and Workbooks
Create Worksheets and Workbooks
Navigate in Worksheets and Workbooks
Format Worksheets and Workbooks
Customize Options and Views for Worksheets and Workbooks
Configure Worksheets and Workbooks for Distribution

 

Module 2

Manage Data Cells and Ranges
Insert data in cells and ranges
Format cells and ranges
Summarize and organize data

 

 

Module 3

Create tables
Create and manage tables
Manage table styles and options
Filter and sort a table

 

Module 

Perform operations with formulas and functions
Summarize data by using functions
Perform conditional operations by using functions
Format and modify text by using functions

 

Module 5

Create charts and objects
Create charts
Format graphic elements
Insert and format objects

 

 

© Copyright. All rights reserved.

Logo

We need your consent to load the translations

We use a third-party service to translate the website content that may collect data about your activity. Please review the details in the privacy policy and accept the service to view the translations.