Excel - PivotTables and PivotCharts

Level - Advanced
This course concentrates on creating PivotTables and PivotCharts to present business data for analysis. It also focuses on how best to manage the underpinning business data using List Management techniques.

Location
Date
Duration

1 Day

Time (AWST)
Address
Participants
Total

Overview

The Excel Pivottables and Pivotcharts course will give you an understanding of how to set up the data to be analysed using Tables. After completion of this course you will be able to create PivotTables and PivotCharts, group items and filter data and build formulas to better analyse your business data.

Content

  • Work with business data using List Management (Tables)
  • Create PivotTables
  • Group items
  • Filter data using Slicers
  • Add formulas to the PivotTable using Calculated Fields
  • Create PivotCharts
  • Format PivotCharts.

Learning Outcomes

Participants should be able to:

  • Set up the data to be analysed using Tables
  • Create PivotTables and PivotCharts
  • Build formulas to better analyse the business data.
Related Results

Level - Fundamental
This course provides you with the skills needed to create highly professional slides and presentations with Microsoft PowerPoint.

Level - Advanced
This course concentrates on Excel’s advanced functions that will allow you to work more efficiently with business data.

Level - Intermediate
This course focuses on expanding your knowledge of Microsoft Excel’s functions and understanding how to write well-structured formulas.

Level - Intermediate
Well-designed documents represent and showcase your organisation and can have a great impact. This course introduces you to important design ideas and principles and shows you techniques for effective document design using text, graphics and other visual elements.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs