Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Charts and Tutorials | Peltier Tech Blog

Peltier Tech Chart Utility



Using Pivot Tables and Pivot Charts in Microsoft Excel

This introduction has been contributed by Debra Dalgleish, Excel MVP.
Contextures, Copyright © 2002. All rights reserved.
Check out Debra's Excel Tips and Techniques.

Introduction to Pivot Tables in Excel

Debra takes a brief look at Pivot Tables -- what they are and how they work.

Pivot Table and Pivot Chart FAQs

Debra's Answers to Frequently Asked Questions (on Contextures).

Pivot Tables - Special Topics

Debra's list of Pivot Table Topics (on Contextures).

Working with Pivot Charts in Excel

Debra's tips and techniques for working effectively with Pivot Charts.

Pivot Tables, Pivot Charts, and Real Charts

Jon's TechTrax Article focused on abilities and shortcomings of Pivot Charts, and how to use regular charts to overcome their deficiencies (article on Tech Trax).

Pivot Table Programming

Debra's links to information on Programming Pivot Tables with VBA

Pivot Table and Pivot Chart Links

Debra and Jon's links to sites with Pivot Table and Pivot Chart information

Beginning Pivot Tables in Excel 2007: From Novice to Professional

Debra introduces Excel 2007 users to Pivot Tables, and covers their capabilities and features in depth. Pivot Tables were enhanced in Excel 2007, so even seasoned Pivot Table users will find this book useful.

Excel PivotTables Recipes: A Problem-Solution Approach

Debra follows a problem-solution format that covers the entire breadth of situations you might encounter when working with PivotTables, from planning and creating, to formatting and extracting data, to maximizing performance and troubleshooting. The book presents tips and techniques in this collection of recipes that cannot be found in Excel's Help section, and carefully explains the most confusing features of PivotTables.

Pivot Tables and Advanced Data Analysis

A list of books relating to pivot tables and data analysis, all of which Jon owns and uses, so you know they're good.


Intro | Pivot Tables | Pivot Charts | Programming Pivots (links only) | Pivot Links


Page copy protected against web site content infringement by Copyscape

Peltier Tech Chart Utility

Create Excel dashboards quickly with Plug-N-Play reports.

Peltier Technical Services, Inc.

Excel Chart Add-Ins | Training | Charts and Tutorials | PTS Blog

Peltier Technical Services, Inc., Copyright © 2014. All rights reserved.
You may link to this article or portions of it on your site, but copying is prohibited without permission of Peltier Technical Services.

Microsoft Most Valuable Professional

Microsoft Most Valuable Professional

My MVP Profile