Excel 2003 Pivot Tables - Level 1

Progressive Training & Development

Course

In Southwark

Price on request

The best Excel courses

See all

See all

Description

  • Type

    Course

  • Location

    Southwark

  • Class hours

    3h

An introduction to the power of Pivot Tables in MS Excel 2003.

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

You need to have basic knowledge of MS Excel 2003.  It would
help if you have used Pivot Tables in the past, but this is not
essential

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Course programme

DESCRIPTION
An introduction to the power of Pivot Tables in MS Excel 2003.

PREREQUISITES
You need to have basic knowledge of MS Excel 2003. It would help if you have used Pivot Tables in the past, but this is not essential

PIVOT TABLE FUNDAMENTALS
  • What is a Pivot Table
  • Why Should you use a Pivot Table
  • When Should you use a Pivot Table
  • The Anatomy of a Pivot Table
  • Pivot Tables Behind the Scenes
  • Limitations of Pivot Table Reports
CREATING A BASIC PIVOT TABLE
  • Preparing Your Data
  • Creating a Basic Pivot Table
  • Keeping up with Changes in your Data Source
CUSTOMIZING FIELDS IN A PIVOT TABLE
  • The Need to Customize
  • Displaying the Pivot Table Field Dialog box
  • Customising Field Names
  • Applying Numeric Formats in Data Fields
  • Changing Summary Calculations
  • Adding and Removing Subtotals
  • Using Running Total Options
FORMATTING YOUR PIVOT TABLE REPORT
  • Using AutoFormat
  • Applying your own Style
  • Setting Table Options
    • Grand totals for columns and rows
    • AutoFormat table
    • Subtotal hidden Page items
    • Merged Labels
    • Preserve Formatting
    • Repeat Item Labels on Each Printed Page
    • Mark Totals with *
    • Page Layout
    • For Error Values Show
    • For Empty Cells Show
    • Set Print Titles
    • Formatting a Pivot Table
CONTROLLING THE WAY YOU VIEW YOUR PIVOT DATA
  • Showing and Hiding Options
  • Sorting in a Pivot table
  • Producing Top 10 Reports
  • Group Pivot Fields
PERFORMING CALCULATIONS WITHIN YOUR PIVOT TABLE
  • Introducing Calculated Fields and Calculated Items
  • Rules and Shortcomings of Pivot Table Calculations
  • Managing and maintaining your Pivot Table Calculations

See related categories

Excel 2003 Pivot Tables - Level 1

Price on request

The best Excel courses

See all

See all