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

Formulas

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

PivotCharts

  • Create PivotCharts
  • Format PivotCharts

PivotTables

  • 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