Skip to main content

Excel 365: PivotTables and PivotCharts E-Learning Course

In this course, learners will be shown how to use PivotTables as an easy way to hide data or change the display scheme without having to change the Excel spreadsheet itself or the data in it. This allows one to clearly display and evaluate complex Excel spreadsheets with a large number of data records.

Instruction on PivotCharts will also be given to enable data visualisation using charts.

Course Features
Content Version
Application Group
Learning Time
1 hour and 25 minutes
Number of Learning Videos
Languages Available
Course Design
  • Videos with Audio Narration and Closed-Captions
  • Practice Interactive Exercises
  • Tips and Printable PDF's
  • Chapter Tests
  • Personalized Learning Recommendations
  • Comprehensive Final Test with Certificate
  • Compatible with Desktop and Mobile Devices
  • SCORM and xAPI Support for LMS Deployement
Course Topics

Creating and setting up a PivotTable

  • Understanding PivotTables
  • Preparing data for PivotTable creation
  • Creating a PivotTable
  • Defining rows and values in a PivotTable
  • Rearranging the fields of a PivotTable
  • PivotTable: Adding items from a field as columns
  • Moving and deleting PivotTables

Filtering and grouping data

  • PivotTable: Grouping data
  • Adding a global filter to a PivotTable
  • Filtering a PivotTable with a slicer
  • PivotTable: Inserting a timeline

Changing the look

  • Formatting a PivotTable
  • PivotTable: Inserting a blank row after each group item
  • Splitting page field items onto separate sheets
  • Applying report layouts to a PivotTable

Performing calculations

  • PivotTable: Defining the calculation function
  • PivotTable: Defining a function for subtotals
  • PivotTable: Adding a calculated field

Refreshing PivotTable data

  • Updating a PivotTable
  • Changing the data source of a PivotTable

Creating and setting up a PivotChart

  • Understanding PivotCharts
  • Creating a PivotChart
  • Selecting and arranging PivotChart fields

Customising a PivotChart

  • Changing the calculation function of a PivotChart
  • Changing the chart style for a PivotChart
  • Changing the chart type of a PivotChart
  • Changing the data source of a PivotChart
This Course is Included in our Course Packages