Consolidating Data Using a Pivot Table

Table of Contents

This Book

Special Edition Using Microsoft Excel 97

Search

About the Author

Acknowledgments

We'd Like to Hear from You!

Introduction

Pt. I. Everyday Worksheet Tasks

Pt. II. Publishing and Browsing on the Web

Pt. III. Creating and Formatting Charts and Maps

Pt. IV. Optimizing Excel

Pt. V. Analyzing the Worksheet

Ch. 25. Manipulating and Analyzing Data

Ch. 26. Building Forms with Controls

Ch. 27. Using the Power of Pivot Tables

Working with Pivot Tables

Understanding Pivot Tables

Creating a Pivot Table

Editing Your Pivot Table

Updating a Pivot Table

Specifying the Source Data

Filtering Data by Creating Page Fields

Consolidating Data Using a Pivot Table

Using More Than One Field

Creating a Pivot Table from Another Pivot Table

Creating a Chart from a Pivot Table

Saving Files with Pivot Tables

Ch. 28. Analyzing and Reporting with Pivot Tables

Ch. 29. Linking, Embedding, and Consolidating Worksheets

Ch. 30. Auditing Workbooks and Worksheets

Ch. 31. Solving with Goal Seek and Solver

Ch. 32. Testing Multiple Solutions with Scenarios

Ch. 33. Using the Analysis ToolPak

Pt. VI. Managing Lists or Databases

Pt. VII. Using Excel with Office and Workgroups

Pt. VIII. Customizing and Automating Excel

Index

Consolidating Data Using a Pivot Table

Often, the data you want to summarize is located in more than one range—sometimes even in several different worksheets. If the ranges have a similar structure and common row and column labels, you can group them together for analysis in a single pivot table.

▸ See Consolidating Worksheets

PREVIEW

Not a subscriber?

Start A Free Trial

This Book

Search

Contents

Chapter 27. Using the Power of Pivot Tab... > Consolidating Data Using a Pivot Tab...

Consolidating Data Using a Pivot Table