Excel - Pivot your Tables Like a Champ

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

This course provides students with the information necessary to create and modify a PivotTable. Students will learn how to calculate, format, and filter within a PivotTable. Information is also included regarding PowerPivot, used for advanced analysis of a large dataset.

 

Upcoming Class Dates and Times

Aug 25, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Sep 19, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 10, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 31, 2022
3:00PM - 4:00PM Central
One Hour
Virtual Instructor Led
 GTR
Nov 22, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Dec 19, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Work with calculated fields and items
  • Use conditional formatting to highlight data
  • Create filter pages, and groupings to organize data
  • Learn various pivot table options
  • Analyze multiple tables, connect slicers and use timelines
  • Refresh and change the data source options