Excel 2016 Essentials

Module One: 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 Two: Manage Data Cells and Ranges
Insert data in cells and ranges
fill cells by using Auto Fill
Insert and delete cells
Format cells and ranges
Summarize and organize data

Module Three: Create tables
Create and manage tables
Manage table styles and options
Filter and sort a table

Module Four: Perform operations with formulas and functions
Summarize data by using functions
Perform calculations by using MIN and MAX functions
Perform conditional operations by using functions
Format and modify text by using functions

Module Five: Create charts and objects
Create charts
Format graphic elements
Insert and format objects