Course overview
This module will enable you to summarise, analyse and present summary data using PivotTable reports, and to visualise that summary data using PivotChart reports, so you can see comparisons, patterns and trends in large numerical data lists.

Who should attend
Delegates should feel confident in the topics covered in the Data Analysis module.

Learning outcomes
At the end of the module, you will be able to:
• Explore features available working within identified limitations using the PivotTable and PivotChart wizard
• Create PivotTable reports using the PivotTable tab and available fields to present detailed summarized data
• Create PivotCharts using the PivotChart tab; format and layout for best effect to display summarized data in chart form effectively

Course contents
Understanding best practice
Understanding how to correctly layout a data list

Creating PivotTable reports
Creating a PivotTable based on an existing data list
Understanding the PivotTable layout and options
Moving and removing fields within the PivotTable

Creating PivotChart reports
Creating a PivotChart based on an existing data list
Understanding the PivotChart layout and options
Using the PivotChart tab to manipulate the PivotChart, e.g. chart type, legend, data table
Formatting the PivotChart

Home

© Alpha Training | Telephone 020 8658 6994 | Email admin@alphatraining.com