Microsoft Office & 365 Apps
Excel - Data Analysis with PivotTables
A focused half day on PivotTables: prepare your data, create and analyse PivotTables and present the results clearly with PivotCharts.
Half dayIntermediate3 modules
About this course
A focused half day on PivotTables: prepare your data, create and analyse PivotTables and present the results clearly with PivotCharts.
Curriculum
3 modules
- 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
- Summarize PivotTable Data
- Organize PivotTable Data
- Filter PivotTable Data
- Format a PivotTable
- Refresh and Change PivotTable Data
- Create a PivotChart
- Manipulate PivotChart Data
- Format a PivotChart
Who it's for
Excel users who summarise data.
Before you start
- Excel - Part 1 & Part 2 or equivalent experience.
Related courses
More in Microsoft Office & 365 Apps →Advanced
55205 Mastering Microsoft Project 2016
Microsoft Office & 365 Apps
View course →Intermediate
55234 SharePoint 2016 Site Collections and Site Owner Administration
Microsoft Office & 365 Apps
View course →Intermediate
55238 SharePoint Online for Administrators
Microsoft Office & 365 Apps
View course →Advanced
55301 Mastering Microsoft Project 2019
Microsoft Office & 365 Apps
View course →Intermediate
55342 Supporting and Troubleshooting Windows 11
Microsoft Office & 365 Apps
View course →Intermediate
Access - Customize Tables
Microsoft Office & 365 Apps
View course →Let's plan your next step together.
Tell us the course or certification you have in mind and we'll send the outline, upcoming dates, fees and private-team options.