Course overview
The aim of this module is to enable you to get the bigger picture from your data.

Who should attend
Delegates should feel confident in the topics covered in the Excel Sorting and Filtering Data Lists 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 toolbar and available fields to present detailed summarized data
• Create PivotCharts using the PivotChart toolbar; 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
Using the PivotTable and PivotChart wizard
Limitations of using PivotTable and PivotChart wizard
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
Using the PivotTable
Using the PivotTable toolbar
Selecting data and grouping selections
Using the PivotTable field list
Changing field settings
Showing detail and drilling down
Refreshing PivotTable data
Creating PivotChart reports
Creating a PivotChart based on an existing data list
Understanding the PivotChart layout and options
Using the PivotChart
Using the Chart toolbar to manipulate the PivotChart, e.g. chart type, legend, data table
Formatting the PivotChart
Refreshing PivotChart data

Related courses

Creating and Editing
Worksheets and Workbooks
Basic Formulas
Charts
Linking Spreadsheets and Formulas
Advanced Formulas
Sorting and Filtering Data Lists
Summarising Data Lists
Templates and Macros

Home

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