Microsoft Excel - PivotTables/PivotCharts Course - Bunbury

Overview

Objectives of this course are to enable experienced users of Microsoft Excel to prepare data for analysis, increase their knowledge of PivotTables and PivotCharts and to effectively analyse the data.

    

This is best for

Anyone who needs to process, analyse and display data in an easy presentable layout.

      

Content

Preparing Data for Analysis

  • Understanding your source data & its limitations
  • Importing/exporting data

PivotTables

  • Understand PivotTable
  • Creating PivotTables
  • Dropping fields into a PivotTable
  • Manipulating PivotTable fields
  • Working with data calculations
  • Working with the slicer

PivotTable Features

  • Using compound fields
  • Counting in a PivotTable
  • Formatting PivotTable values
  • Working with PivotTable totals
  • Finding the Percentage of total and the Difference from
  • Grouping in Pivot Table reports
  • Creating calculated fields and items
  • Providing custom names
  • Sorting in a PivotTable

PivotCharts

  • Creating PivotCharts
  • Working with chart elements
  • Advanced chart options

 

 

 

Learning outcomes

Better understand how PivotTables can help you to make sense of large data sets. Use field grouping techniques to extract meaningful summaries of your data. Create PivotCharts from your data.

Prerequisites

Completion of Microsoft Excel Intermediate course or equivalent knowledge is required.

   

Duration

1/2 day

 

Investment

$295 GST free per person

Includes:

  • Experienced facilitator
  • Interactive, practical and hands on learning
  • Comprehensive take-home training and reference manual
  • Post-course Help Desk support
  • Certificate of Attendance for participants
  • Morning refreshments
  • Post course follow up

 

Enjoy Real People, Real Conversations, Real Results 

  

Software versions

Available for 2013, 2016 & 365

 

 

 

When

13 December 2019 (Half day)