Code: EXLPT
Length: 3 Hours
Overview
Harness the power of advanced PivotTable features.
Delivery format(s)
OBJECTIVES
PREREQUISITES
To ensure your success in this course, it is recommended that you have completed courses Microsoft Excel - Data Analysis and Reporting or possess equivalent knowledge.
WHAT YOU’LL LEARN
Upon successful completion of this course, you will be able to use Excel advanced PivotTable functionality to analyse your raw data.
You will:
• Prepare data for PivotTable reporting and create PivotTables from various data sources.
• Analyze Data Using PivotTables.
• Work with PivotCharts.
COURSE OUTLINE
Preparing Data & Creating PivotTables
• Prepare Data
• Create a PivotTable from a Local Data Source
• Create a PivotTable from Multiple Local Data Sources
• Create a PivotTable from an External Data Source
Analysing Data Using PivotTables
• Summarize PivotTable Data
• Organize PivotTable Data
• Filter PivotTable Data
• Format a PivotTable
• Refresh and Change PivotTable Data
Working with PivotCharts
• Create a PivotChart
• Manipulate PivotChart Data
• Format a PivotChart