X

Excel 2016 - Tables, PivotTables, and Conditional Formatting

Course Overview

In this course, students will create, edit, and enhance Tables, PivotTables and Conditional Formatting using Microsoft Office Excel 2016.

Who Should Attend

This course is intended for individuals who want to gain knowledge of working on Excel using Tables, PivotTables and Conditional Formatting.

Course Objectives

Upon successful completion of this course, students will be able to create a spreadsheet using Tables, PivotTables and Conditional Formatting by using Microsoft Office Excel 2016.

Course Outline

1 - ORGANIZE WORKSHEET AND TABLE DATA

  • Create a Table
  • Sort and Filter a Table
  • Create Calculated Columns in a Table
  • Create a Total Row in a Table
  • Format a Table

2 - ANALYZING DATA USING PIVOTTABLES, SLICERS, AND PIVOTTABLES

  • Create a PivotTable
  • Filter Data with Slicers
  • Analyze Data Using PivotCharts

3 - APPLY CONDITIONAL FORMATTING

  • Data Bars, Icon Sets, Color Scales, Top/Bottom Values, Duplicate Values

Enroll Today

This is a half-day class

Price: $195.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/23/2019 1:30PM - 5:00PM GTR Online LIVE OLL
09/23/2019 1:30PM - 5:00PM GTR Online LIVE OLL
10/01/2019 1:30PM - 5:00PM GTR Online LIVE OLL
10/16/2019 1:30PM - 5:00PM GTR Online LIVE OLL
11/01/2019 1:30PM - 5:00PM GTR Online LIVE OLL
11/11/2019 1:30PM - 5:00PM GTR Online LIVE OLL
11/25/2019 1:30PM - 5:00PM GTR Online LIVE OLL
12/10/2019 1:30PM - 5:00PM GTR Online LIVE OLL

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