Byron Employment

Byron Employment. Over 71,618 Jobs Australia Wide.

Delivery Method

  • Classroom
  • Price: $350.00

Course Overview

This course is designed to develop experience and confidence in using Excel Pivot Tables to analyse data and produce sophisticated management reports.

Learn to create and work with Pivot Tables to view and analyse your data in a variety of ways. Discover how to perform a variety of calculations with Pivot Table Data. Learn to save time by re-using Pivot Table Reports as templates.

You will learn how to construct Pivot Tables and Charts to consolidate and summarise your data.

Prerequisites

Participants must be confident users of Excel who have equivalent knowledge of topics covered in the Excel 2000/2002/2003 Intermediate course.

Delivery

Classroom

Duration

1 day

Outline

Understanding Databases and Lists

Understanding Databases in Excel
Sorting and Filtering Data
Subtotals
Grouping and Outlining
Using a Data Form to manage data in  a list
Summarising Data with COUNTIF and SUMIF

PivotTable Fundamentals

What is a PivotTable?
Why should I use a Pivot Table?
What are the advantages?
PivotTable Terminology
Preparing your data for use in a PivotTable

Creating a PivotTable

Selecting the Data Source
PivotTable Fields List
Filterering data with Page Fields
Adding Fields
Removing Fields
Understanding the Field icons

Presenting Data in PivotTables

PivotTable Toolbar
Hiding and Unhiding Items
Sorting Data in a PivotTable
Using AutoSort
Advanced AutoSort
Refreshing a PivotTable Report
Inserting Data into the Data Source
Formatting Numerical Data
Selecting Parts of a PivotTable
PivotTable Formats
PivotTable Options
Change the Summary Function
Adding Multiple Data Fields
Changing Calculations
Hiding and Showing Row/Column Details
Displaying Data Details

Grouping Data

Grouping Data
Group by Dates
Group by Number
Ungrouping Data

Calculations in PivotTables

Changing custom calculations
Creating Calculated Fields
Calculated Items
Using GetPivotData() function to extract information from the PivotTable

Using Other Sources of Data

Selecting data from another Excel workbook
Connecting to an Database i.e. Microsoft Access database
Using a Saved Query as the data source
Using a Comma-delimited text file as the source of a PivotTable

Using PivotCharts

PivotChart terms
Modifying the Chart
Caution - Loss of Formatting in PivotCharts

Publishing PivotTables to the Web

Saving a PivotTables as a web page
Creating Interactive PivotCharts - Web
Adding Fields to a PivotChart - Browser

Analysing Data from Multiple Ranges

Setting up the PivotTable using multiple ranges
Using Multiple Page Fields

Re-using PivotTables

Requerying data
Using Saved queries
Automating PivotTable Updates
Saving a PivotTable Template

CLICK HERE TO BOOK THIS COURSE NOW!

WANT MORE INFORMATION?
CALL NOW ON (07) 3210 0002
CLICK ON THIS LINK TO ENQUIRE!

CLICK HERE TO
BOOK THIS COURSE NOW!
WANT MORE INFO?
CALL (07) 3210 0002 OR
CLICK HERE TO ENQUIRE

Search Courses

Quick Job Search