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

Lessons

  1. 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. 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. 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.

Module practice

Module quiz

1. Which chart compares sales across five regions?
2. Where do you drag a field to list one row per product?
3. Which tool finds the input that gives a target result?
4. How is a text field summarised when placed in Values?
5. What must you do after the source of a PivotTable changes?
6. Why is a column chart with a value axis starting at 900 misleading?

‹ Working with dataAdvanced Excel ›