Excel 2016 - Tables, Pivot Tables and Conditional Formatting

Price
$295.00
Duration
 0.5 Days
Delivery Methods
 VILT    Private Group

In This Course, students will analyze Excel data, create PivotTables, Pivot Charts as well as Analyzing Pivot Tables.

 

Upcoming Class Dates and Times

Feb 16, 2021
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Mar 22, 2021
8:00AM - 11:30AM Central
0.5 Days
Virtual Instructor Led
 GTR
Apr 26, 2021
12:30PM - 4:00PM Central
0.5 Days
Virtual Instructor Led
 GTR
May 28, 2021
12:30PM - 4:00PM Central
0.5 Days
Virtual Instructor Led
 GTR

Course Objectives

    Please refer to Overview

Agenda

1 - ANALYZING DATA
  • Tables
  • Conditional Formatting
2 - CREATE A PIVOTTABLE
  • Pivot Tables
  • Pivot Charts
3 - PREPARING DATA AND CREATING PIVOTTABLES
  • Summarize PivotTable Data
  • Organize PivotTable Data
  • Filter PivotTable Data
  • Format a PivotTable
  • Refresh and Change a PivotTable