Excel Topic 2: Creating and Working with Pivot Tables
Course Duration: 90 Minutes
Target Audience:
This session is intended for Excel users who wish to use Pivot Tables and Pivot Charts to analyse and summarise data quickly and effectively.
Course Objectives:
A Pivot Table is a reporting tool that produces 3D reports from spread sheet data. This session will explain the core concepts of Pivot Tables, and how to create, and manage a them.
Course Outline:
Course Introduction
Steps in Creating a Pivot Table
Selecting the Required Fields for the Pivot Table
Editing the Pivot Table
Formatting the Pivot Table
Updating and Refreshing a Pivot Table
Adding Data Fields and Change the Calculation Method
Showing Multiple Totals Across Columns
Grouping Fields for Data Analysis
Creating a Pivot Chart
Discussion and Question Time
Contact us today to enquire about all our courses, classroom and virtual training options. Follow us on Facebook and LinkedIn for latest updates.