Analysis and charts
Choosing and formatting charts, summarising lists with PivotTables, and answering what-if questions with Goal Seek, data tables and scenarios.
About 4 hours of study
Learning objectives
- Choose and build clear charts
- Summarise data with PivotTables
- Model what-if questions
Lessons
- 1
Charts and sparklines Intermediate
Choosing the right chart for a question, creating and formatting column, bar, line, pie, scatter and combo charts, chart elements and axes, and tiny in-cell sparklines.
- 2
PivotTables Intermediate
Summarising thousands of rows in seconds: building a PivotTable from a Table, rows, columns, values and filters, value field settings, grouping dates, slicers, PivotCharts and refreshing.
- 3
What-if analysis: Goal Seek, data tables and scenarios Advanced
Asking "what if" of a model: Goal Seek to find the input that gives a target result, one- and two-variable data tables, Scenario Manager for named sets of inputs, and an introduction to Solver.