Microsoft Excel logo

Course duration

(we will customise to your learning requirements and timeframe)

Target audience

This course is designed for those who need to know how to use Pivot Tables in Microsoft Excel to report on data. Participants should have completed the Excel Introduction training course or have a good understanding of Microsoft Excel.

Download the PDF Course Outline.

Course Objectives

At the end of the course participants will be able to:

  • Create databases in Microsoft Excel
  • Do’s and Do nots of creating databases in Excel
  • Work with Pivot Tables to generate calculations
  • Create Pivot Charts


  • Elements of a Database
  • Create an Excel Database
  • Do’s & Don’ts
  • Modifying the Database Structure


  • Create PivotCharts
  • Format PivotCharts


  • What is a PivotTable?
  • Understand how PivotTables summarise data
  • Create a PivotTable
  • Work with the Pivot Table layout
  • Change designs
  • Sort and filter a PivotTable
  • Refresh a PivotTable
  • Change the data source
  • Group data by row labels
  • Format numbers within a Pivot Table
  • Create calculated fields

Other Excel Training Courses

Excel Introduction
Excel Intermediate
Excel Advanced
Excel Formulas and Functions

StressLess Learning, Microsoft Excel Training Experts