Course Description

The participants will learn:
•Introduction to PivotTable
•Preparing data source to be use in PivotTable
•Creating the PivotTable
•Using external data source in PivotTable
•About PivotTable Fields Pane
•About PivotTable structure
•Building up the PivotTable
•Pivoting the PivotTable
•Show report filter pages
•Removing field from the PivotTable
•Managing PivotTable
•Grouping fields
•Sorting and filtering PivotTable data
Moving the Slicer
Changing the Slicer Style
Applying Filter Using Slicer
Clearing Filter Using Slicer
Deleting the Slicer
Elements of the Timeline
Changing the filter types of the Timeline
Applying filter with Timeline
Add another criterion to an existing filter
Clearing filter in the Timeline
Moving & resizing the Timeline
Changing the Timeline style
Deleting the Timeline
•Refreshing PivotTable
•Formatting the PivotTable
•Summarizing PivotTable Data
•Working with PivotChart
•Printing PivotTables
•Calculation in PivotTable
•Create calculated field
•Edit calculated field
•Delete calculated field
•Create calculated item
•Edit calculated item
•Delete calculated item
•% of Grand Total
•% of Column Total
•% of Row Total
•% of Parent Row Total
•% of Parent Column Total
•% of Parent Total
•Running Total In
•Running Total In
•Rank Smallest to Largest
•Rank Largest to Smallest
•% of
•Difference From
•Difference From