Excel - Get your Data to Pivot

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT

This course is an introduction to using PivotTables, a fast and versatile way to summarize and analyze complex sets of data. This course covers the basics of how to create, organize, filter and visualize data with PivotTable. You will also learn about how to format Pivot Tables and why to use them.

 

Upcoming Class Dates and Times

Aug 19, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Sep 12, 2022
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Oct 05, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Oct 26, 2022
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Nov 17, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR
Dec 12, 2022
10:00AM - 11:00AM Central
One Hour
Virtual Instructor Led
 GTR

Agenda

1 - Outline
  • Learn what PivotTables are, how to create them from scratch, or use premade formats
  • Create a pivot table, analyze, restructure, organize and filter data in a pivot table
  • Learn to format values, refresh your data, and use table tools on the ribbon
  • Summarize data, learn how to redesign and make your pivotable look presentable
  • Filter data quickly with slicers and timelines.
  • Visualize PivotTable data with PivotCharts, watch how quickly data will automate