Excel 365 PivotTables - Beyond the Basics

Price
$49.00
Duration
 One Hour
Delivery Methods
 VILT
Skip to Class Dates
Request More Information

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 04, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Aug 20, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Sep 09, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Sep 27, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Oct 14, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Nov 01, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Nov 18, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Dec 08, 2021
1:00PM - 2:00PM Central
One Hour
Virtual Instructor Led
 GTR
Enroll
Dec 28, 2021
8:00AM - 9:00AM Central
One Hour
Virtual Instructor Led
 GTR
Enroll

This class is also part of our LearnNow Pass. Click here for more details.

Who Should Attend

Moderate-advanced exposure to Excel is recommended for this course. Students do not need to have prior experience regarding PivotTables specifically, however the course does require moderate knowledge of Excel, since there is information regarding: conditional formatting, calculations, and filtering tools

Course Objectives

    The course is designed to provide students with information regarding PivotTables and PowerPivot. Students will learn to analyze and format data through the Pivot environment, as well as become accustom to the terminology and verbiage.

Agenda

1 - Lessons
  • * Analyzing Data with PivotTables
  • * Working with Calculated Fields and Items
  • * Using Conditional Formatting in a PivotTable
  • * Creating Filter Pages in a PivotTable
  • * Working with the PowerPivot Add-In
  • * Linking Two Tables Using PowerPivot