Mastering Pivot Table (V2010) (MDA139)

16 March 2017 - 16 March 2017

Module A : Introducing Pivot Table
• Create basic pivot table
• Changing pivot table view and layout
• Changing Summary Calculation
• Create useful pivot driven view
• Customize pivot table view by year, quarter and month
• Creating percent distribution view and YTD total view

Module B : Beyond Basics
• Creating Slicers and formatting Slicers
• Control multiple Pivot Table
• Create pivot table using consolidation range
• Create pivot table from external source
• Create pivot table using basic SQL
• Using slicer as form controls
• Using conditional formatting with pivot table
• Calculated field and calculated item
• Create Dynamic Pivot Table
• Managing and Maintaining Pivot Table Calculations
• Viewing Excel 2010 pivot table on the SkyDrive

Module C : Working with Pivot Chart
• Create basic Pivot Chart
• Limitation of Pivot Chart
• Create standalone charts that are connected to your pivot table
• Disconnecting charts from pivot tables
• Tricks to overcome the limitation of pivot chart
• Create Dashboard using pivot table and pivot chart

Module D : Using Internal Data and Power View
• Understanding the Internal Data Model
• Creating and Building data model
• Build relationships
• Using data model in pivot table
• Using external data sources in your internal Data Model
• Creating a Power View Dashboard
• Working with Power View Charts
• Power View Map

1 day

Program 100% Claimable Under SBL Scheme
PSDC Members: RM 430/pax
Non-Members: RM 480/pax

16 March 2017
3 November 2017