Microsoft® Excel® 2016: Level 2

Duration:

1 Day (6.5 instructional hours)

Excel 2016

Course Number: 091056

Course Objective:

Upon successful completion of this course, you will learn the advanced skills to organize, calculate, analyze, revise, update, and present data with PivotTables and PivotCharts.

Target Student:

This course is meant for those desiring to gain the higher-level functionality of Microsoft Office Excel 2016 that is necessary to create and work with electronic spreadsheets.

Course Objective:

To ensure success, students will need to be familiar with using or have equivalent knowledge of Microsoft® Office Excel® 2016: Part 1.

Course Outline

Lesson 1: Working with Functions

Topic A: Work with Ranges
Topic B: Use Specialized Functions
Topic C: Work with Logical Functions
Topic D: Work with Date & Time Functions
Topic E: Work with Text Functions

Lesson 2: Working with Lists

Topic A: Sort Data
Topic B: Filter Data
Topic C: Query Data with Database Functions
Topic D: Outline and Subtotal Data

Lesson 3: Analyzing Data

Topic A: Create and Modify Tables
Topic B: Apply Intermediate Conditional Formatting
Topic C: Apply Advanced Conditional Formatting

Lesson 4: Visualizing Data with Charts

Topic A: Create Charts
Topic B: Modify and Format Charts
Topic C: Use Advanced Chart Features

Lesson 5: Analyzing Data with PivotTables and PivotCharts

Topic A: Create a PivotTable
Topic B: Analyze PivotTable Data
Topic C: Present Data with PivotCharts
Topic D: Filter Data by Using Timelines and Slicers