Pivot Tables and Data Analysis
Summarising and analysing large data sets with pivot tables, slicers and calculated fields.
Course contents
- 1Preparing data for analysis
- 2Creating a pivot table and arranging its fields
- 3Grouping and calculated fields
- 4Slicers and pivot charts
- 5Refreshing data
What you gain from the course
You can turn thousands of rows into a clear report in minutes and answer management’s questions from the data.
Other courses in the same track
Analysis and reporting
Interactive Dashboards
Building an interactive dashboard that presents key figures with charts and filters.
20 training hours
Financial Reporting in Excel
Designing periodic financial reports that are linked to the data, update automatically and are ready for management.
20 training hours
Financial Modeling
Building a model that links the three statements, with assumptions, forecasts and sensitivity analysis.
30 training hours