Explanation

Excel provides interactive tools for summarizing and analyzing large amounts of data.

Topics Covered

  • PivotTable
  • PivotChart
  • Slicer
  • Timeline

Key Concepts

PivotTable: Summarizes data quickly using fields such as Rows, Columns, Values and Filters.

PivotChart: Creates a chart based on PivotTable data.

Slicer: Provides clickable buttons for filtering PivotTable data.

Timeline: Provides an interactive way to filter date-based PivotTable data.

Example

A company has thousands of sales records. A PivotTable can quickly show:

  • Total sales by product
  • Sales by salesperson
  • Sales by city
  • Monthly sales

A Slicer can then allow the user to filter the report by product or salesperson.

Practice

Create a sales dataset with at least 20 records and create:

  1. A PivotTable
  2. A PivotChart
  3. A Slicer
  4. A Timeline for the date field
PreviousNext