Excel Pivot Tables

Audience

Prerequisites

Individuals who will be designing, coding, maintaining, testing, and/or debugging with ADS/0

Students must be able to:

       Bullet List1 Style

       Bullet List1 Style

Description

At the conclusion of this class you will be able to create, modify and format PivotTables.  You will also gain an understanding of how Pivot Charts can be used to display data visually.

Goals/Objectives

       List the components of ADS/0

       List the tasks required to design an ADS/0 application.

       Determine if an application is a good candidate for ADS/0

       Define data

       Write a basic procedure

       Design, code and debug basic dialog.

       Code a procedure

       Understand the data security & integrity issues involved with using ADS/0

Outline/Table of Contents

Creating & Delivering PivotTable Reports

        Introduction to PivotTables

        Changing PivotTable Layout

        Modifying PivotTable Reports

        Formatting PivotTable Reports

Customizing the Appearance and Layout

        Sorting PivotTable Data

        Printing PivotTable Reports

Summarizing with Totals& Formulas

Retrieving and Refreshing Data

Creating Multiple PivotTables

PivotChart

        Working with PivotCharts

        Making a Regular Chart using PivotTable Data

Publishing PivotTable Data to the Web

Advanced Options

Linking PivotTables to External Sources