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
Finding out how to use Microsoft Outlook as a time management tool, so you can manage the flow of emails and keep track of time, is probably the best decision you'll ever make!

Level - Advanced
If you need to quickly and accurately make sense of your company's raw data, this Excel - KPI Dashboards course is for you. It introduces you to KPIs and dashboard design processes and will help you build an interactive KPI Dashboard.

Level - Advanced
This course outlines analytic tools of Microsoft Excel which can be very useful for business planning and modelling.

Level - Advanced
This course is all about time-savers in Microsoft Word. It shows how to automate standard documents and how to create your own shortcuts for frequently used tasks which you then can add to your toolbar or ribbon. This course is for you, if you are a confident Word user.

Courses - Frequently Asked Questions

Get answers to common queries.

FAQs