PTS Utilities

Commercial Utilities developed by Peltier Technical Services

  Waterfall Chart
  Box and Whisker
 

Excel Books

Books that I own and use while developing in Excel

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.