Pivot tables are one of Excel's most powerful features. A pivot table allows you to extract the significance from a large, detailed data set.
A pivot table is an incredibly powerful tool inExcel that can be used to analyze, explore and summarize your data.
Pivot Tables are in their element with huge amounts of data and allow you to create reports from this data in seconds.
Benefits
At the end of this course you will have a greater understanding of the functionality and potential of Pivot Tables.
You will be able to construct and manipulate complex summaries and analyses of data using Pivot Table tools, control visual and data formatting, manage and add to the statistical analysis of your data, deal with varying data sources, automate, troubleshoot and utilise Pivoted data in many different contexts.
Below is a list of our content to be cover on Pivot Tables.
What is a Pivot Table - and Why Do You Care?
Insert a Pivot Table/Â Creating Your First Pivot Table
Source Data Best Practices / Preparing and Using Database Data
Drag fields - Filter / Report / Column / Value
Totals and Sub-TotalsÂ
Choosing Pivot Table Layouts and Grouping
Basic and custome Shorting
Formula calculation
Change Summary Calculation
Two-dimensional Pivot Table
Creating Pivot Chart ans dashboard
Pivot report filter
View this Course
Audio/Video Quality
Certified
You have 
