Date & Time
Starts on Sunday
19 Apr 2026
1 sessions 10:00 AM - 6:00 PM
Registration Closing Date: 12 Apr 2026
Price
From $90.00 to $95.00
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
Requirements and Remarks:
For more information, please visit https://www.cckitcentre.org.sg
Organising Committee
Training Provider(s)

Ow Yeong Yin Leng has a Bachelor in Computer Science degree from the SIM. She was a programmer for Sanyo Airconditioners Manufacturing Pte Ltd. She...
Read More