3 Hour Live Training on Microsoft Excel Pivot Tables

This step-by-step training will teach you how to create a Pivot Table in Excel
Duration: 1 Day
Hours: 3 Hours
Training Level: All Level
Virtual Class Id: 50008
Recorded
Single Attendee
$199.00 $332.00
6 month Access for Recorded
Have Any Queries

Call Us : +1-888-880-0589

support@virtualtrainings.com

About the Course:
In three hours you will learn the simplicity of Pivot Tables along with the power that they hold. You will see first-hand what all the fuss is about and what PivotTables are and why everyone needs them. If you are using Excel and want to harness the power of the tools available to you in this program this class is for you.  Learn, with ease, how to set up, calculate, summarize, and analyze your data. This is one tool many executives, Managers, supervisors, administrative assistants, marketers, or anyone and everyone using excel needs to learn.  

Course Objective:
Create a PivotTable to analyze worksheet data.
Arrange fields in a PivotTable.
Group and Ungroup Data in a PivotTable.
Filter data in a PivotTable.
Create PivotCharts.
How to use PivotTables in Interactive Dashboards.
Tips and Tricks for beginning to Advanced Users of PivotTables.
Who is the Target Audience:
Anybody with basic knowledge of Microsoft Excel
Basic Knowledge:
Have some working knowledge of Microsoft Excel
In three hours you will learn the simplicity of Pivot Tables along with the power that they hold. You will see first-hand what all the fuss is about and what PivotTables are and why everyone needs them. If you are using Excel and want to harness the power of the tools available to you in this program this class is for you.  Learn, with ease, how to set up, calculate, summarize, and analyze your data. This is one tool many executives, Managers, supervisors, administrative assistants, marketers, or anyone and everyone using excel needs to learn.  

Course Objective:
Create a PivotTable to analyze worksheet data.
Arrange fields in a PivotTable.
Group and Ungroup Data in a PivotTable.
Filter data in a PivotTable.
Create PivotCharts.
How to use PivotTables in Interactive Dashboards.
Tips and Tricks for beginning to Advanced Users of PivotTables.

Who is the Target Audience:
Anybody with basic knowledge of Microsoft Excel

Basic Knowledge:
Have some working knowledge of Microsoft Excel

Curriculum
Total Duration: 3 Hours
Session
Table of Contents   
Create PivotTables

  • Organize Data Using the Field List
  • Group and Ungroup Data
  • Summarize and show values
  • Use Slicers
  • Sort and Filter Data
  • Quickly Format PivotTables
  • Change Data/Refresh Data
  • Create Pivot Charts
  • Interactive Excel Dashboards with slicers and Pivot Tables.
  • PivotTables vs. PowerPivot
Bonus: Pivot Tables Tips & Tricks!