2 hours Live Virtual training on Slicing and Dicing Data with PivotTables
PivotTables are the most used data analysis tool in existence. In this course you will see many examples of PivotTables and master the use of this important data analysis tool.
-
Training TypeLive Training
-
CategoryMS Excel
-
Duration2 Hours
-
Rating5/5
Course Introduction
About the Course
PivotTables are the most used data analysis tool in existence. In this course you will see many examples of PivotTables and master the use of this important data analysis tool.
Course Objective
You will master the nuts and bolts of PivotTables (what button to push when), but more importantly you will learn how to look at a data set and determine to layout the PivotTable(s) that provide the most insight into the data.
Who is the Target Audience?
Accountants, Accounts, Audit
Aviation
Banking, CFOs
Controllers, CPAs
Education
Energy
FDA
Finance, Financial consultants
Human Resource
Insurance
Investments
IT
Logistics & Supply Chain
Marketing
Medical Devices
Pharmaceutical
Retail, Sales
Telecom
Basic Knowledge:
This is a basic class. No prior Excel knowledge is required.
Related Virtual Classroom
Available Batches
| 17 May 2021 | Mon (1 Day) | 10:00 AM - 12:00 PM (PT) |
Pricing
Live
Single Attendee
149
249
Live Session
Recorded
Single Attendee
199
332
6 month Access for Rec
Live+Recorded
Single Attendee
249
416
6 month Access for Rec
Group Offer
Single Attendee 40% Off -
Upto 9 Attendee 45% Off -
10 or More Attendee 50% Off
Curriculum
Total Duration : 2 Hours
The Field List
Collapsing and Expanding Fields
Pivot Table Layouts
Pivot Charts
Changing the Summary Statistic
Using Show Values to change the way the data is displayed
Using Office 365 to change PivotTable defaults
PivotTable filters and slicers
Timelines
The Office 365 Ideas Feature
Calculated Fields and Items
Using GETPIVOTDATA to extract data from a PivotTable
Using filters to create PivotTables with a single click