X

Excel 2016 - Part 2

Course Overview

This course builds upon the knowledge presented in the Microsoft® Office Excel® 2016: Part 1 course and helps start students down the road to creating advanced workbooks & worksheets that can help deepen their understanding.

Who Should Attend

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyze and present data.

Course Objectives

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions. You will: Work with Functions Work with Lists Analyze Data Visualize Data with Charts. Create advanced formulas. Analyze Data with PivotTables and PivotCharts.

Suggested Prerequisites

Next Steps and Related Courses

Course Outline

1 - Working with Functions

  • Work with Ranges
  • Use Specialized Functions
  • Work with Logical Functions
  • Work with Date & Time Functions
  • Work with Text Functions

2 - Working with Lists

  • Sort Data
  • Filter Data
  • Query Data with Database Functions
  • Outline and Subtotal Data

3 - Analyzing Data

  • Create and Modify Tables
  • Apply Intermediate Conditional Formatting
  • Apply Advanced Conditional Formatting

4 - Visualizing Data with Charts

  • Create Charts
  • Modify and Format Charts
  • Use Advanced Chart Features

5 - Analyzing Data with PivotTables and PivotCharts

  • Create a PivotTable
  • Analyze PivotTable Data
  • Present Data with PivotCharts
  • Filter Data by Using Timelines and Slicers

Enroll Today

This is a 1-day class

Price: $295.00
Payment Options

ILT Instructor‑Led Training

OLL Online LIVE

GTR  Guaranteed to Run

Class times are listed Eastern time. This class is available for Private Group Training

To sort by location or date, click the ‘When’ and ‘Where’ column headings.

Cart When Time   Where How
09/16/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/16/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/17/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/17/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/18/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/18/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/19/2019 11:00AM - 7:00PM GTR Online LIVE OLL
09/19/2019 11:00AM - 7:00PM GTR Online LIVE OLL
09/23/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/23/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/23/2019 9:00AM - 5:00PM GTR Chicago (Downtown), IL ILT
09/24/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/25/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/27/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/27/2019 9:00AM - 5:00PM GTR Online LIVE OLL
09/30/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/01/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/02/2019 11:00AM - 7:00PM GTR Online LIVE OLL
10/03/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/09/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/09/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/11/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/14/2019 11:00AM - 7:00PM GTR Online LIVE OLL
10/15/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/18/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/18/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/22/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/23/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/24/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/25/2019 11:00AM - 7:00PM GTR Online LIVE OLL
10/28/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/29/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/31/2019 9:00AM - 5:00PM GTR Online LIVE OLL
10/31/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/05/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/08/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/08/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/12/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/14/2019 11:00AM - 7:00PM GTR Online LIVE OLL
11/15/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/18/2019 11:00AM - 7:00PM GTR Online LIVE OLL
11/20/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/20/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/25/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/25/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/26/2019 9:00AM - 5:00PM GTR Online LIVE OLL
11/27/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/02/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/05/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/06/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/12/2019 11:00AM - 7:00PM GTR Online LIVE OLL
12/13/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/16/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/17/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/17/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/20/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/20/2019 9:00AM - 5:00PM GTR Online LIVE OLL
12/26/2019 9:00AM - 5:00PM GTR Online LIVE OLL
01/02/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/06/2020 9:00AM - 5:00PM GTR Online LIVE OLL
01/08/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/08/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/10/2020 9:00AM - 5:00PM GTR Online LIVE OLL
01/13/2020 9:00AM - 5:00PM GTR Online LIVE OLL
01/14/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/14/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/16/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/20/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/20/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/22/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/22/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/24/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/24/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/28/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/28/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/30/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/30/2020 11:00AM - 7:00PM GTR Online LIVE OLL
01/31/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/04/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/04/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/06/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/06/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/10/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/10/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/12/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/12/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/13/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/14/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/14/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/18/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/18/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/20/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/20/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/24/2020 9:00AM - 5:00PM GTR Online LIVE OLL
02/26/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/26/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/28/2020 11:00AM - 7:00PM GTR Online LIVE OLL
02/28/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/03/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/03/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/05/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/05/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/09/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/09/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/11/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/11/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/13/2020 9:00AM - 5:00PM GTR Online LIVE OLL
03/17/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/19/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/19/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/23/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/23/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/25/2020 9:00AM - 5:00PM GTR Online LIVE OLL
03/30/2020 11:00AM - 7:00PM GTR Online LIVE OLL
03/30/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/01/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/01/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/03/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/03/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/06/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/07/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/07/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/09/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/09/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/13/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/13/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/15/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/15/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/16/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/17/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/17/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/21/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/21/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/23/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/23/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/27/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/27/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/28/2020 9:00AM - 5:00PM GTR Online LIVE OLL
04/29/2020 11:00AM - 7:00PM GTR Online LIVE OLL
04/29/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/01/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/01/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/05/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/05/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/07/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/07/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/11/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/11/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/13/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/13/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/15/2020 9:00AM - 5:00PM GTR Online LIVE OLL
05/19/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/19/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/20/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/21/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/21/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/27/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/27/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/29/2020 11:00AM - 7:00PM GTR Online LIVE OLL
05/29/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/02/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/02/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/04/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/04/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/10/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/10/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/12/2020 9:00AM - 5:00PM GTR Online LIVE OLL
06/16/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/16/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/18/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/22/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/22/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/25/2020 9:00AM - 5:00PM GTR Online LIVE OLL
06/29/2020 11:00AM - 7:00PM GTR Online LIVE OLL
06/29/2020 11:00AM - 7:00PM GTR Online LIVE OLL
07/01/2020 11:00AM - 7:00PM GTR Online LIVE OLL
07/01/2020 11:00AM - 7:00PM GTR Online LIVE OLL
07/07/2020 9:00AM - 5:00PM GTR Online LIVE OLL
07/21/2020 11:00AM - 7:00PM GTR Online LIVE OLL
07/23/2020 9:00AM - 5:00PM GTR Online LIVE OLL
08/04/2020 9:00AM - 5:00PM GTR Online LIVE OLL
08/18/2020 9:00AM - 5:00PM GTR Online LIVE OLL
08/18/2020 11:00AM - 7:00PM GTR Online LIVE OLL
09/11/2020 9:00AM - 5:00PM GTR Online LIVE OLL
09/22/2020 11:00AM - 7:00PM GTR Online LIVE OLL
10/20/2020 11:00AM - 7:00PM GTR Online LIVE OLL
10/30/2020 9:00AM - 5:00PM GTR Online LIVE OLL
11/02/2020 9:00AM - 5:00PM GTR Online LIVE OLL
11/16/2020 11:00AM - 7:00PM GTR Online LIVE OLL
12/15/2020 11:00AM - 7:00PM GTR Online LIVE OLL
12/28/2020 9:00AM - 5:00PM GTR Online LIVE OLL

Class times are listed Eastern time
This class is available for Private Group Training