3 Hour Live Training on Microsoft Excel Pivot Tables
Training TypeLive Training
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, Mangers, supervisors, administrative assistants, marketers, or anyone and everyone using excel needs to learn.
Create a PivotTable to analyze worksheet data.
Arrange fields in a PivotTable.
Group and Ungroup Data in a PivotTable.
Filter data in a PivotTable.
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
Have some working knowledge of Microsoft Excel
|04 May 2021||Tue (1 Day)||10:00 AM - 01:00 PM (PDT)|
|15 Jun 2021||Tue (1 Day)||01:00 PM - 04:00 PM (ET)|
|15 Jul 2021||Thu (1 Day)||01:00 PM - 04:00 PM (ET)|
|10 Aug 2021||Tue (1 Day)||01:00 PM - 04:00 PM (ET)|
Organize Data Using the Field List
Group and Ungroup Data
Summarize and show values
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!