PivotTables & Charts
What you will be able to do
- Build and group PivotTables
- Use slicers, timelines and calculated fields
- Choose and clean up the right chart
- Build a sales analysis pack
17 lessons and projects. Short, practical steps in a spreadsheet, with real Excel for the features a browser cannot run.
Outline
Module 1: PivotTables
- Preparing data for a pivotReal Excel
- Your first PivotTableReal Excel
- Rows, columns, values and filtersReal Excel
- Summarise by and Show Values AsReal Excel
- Grouping datesReal Excel
- Grouping numbers and itemsReal Excel
- Sorting and Top 10 filtersReal Excel
- Calculated fieldsReal Excel
- Slicers and timelinesReal Excel
- Refreshing, changing the source, GETPIVOTDATAReal Excel
- Report-ready pivotsReal Excel
Module 2: Charts
- Choosing the right chartReal Excel
- Clean report formattingReal Excel
- Combo chart with a second axisReal Excel
- Waterfall chartReal Excel
- PivotCharts and SparklinesReal Excel
Project: sales analysis pack
Completing it earns a certificate of completion. It is not an accreditation or a professional qualification.
Start free