Pivot Table Data Crunching


June 2005

Pivot Table Data Crunching

White collar productivity would skyrocket if everyone actually understood how to use Pivot Tables.

H.C.


Product Details
  • 274 Pages
  • Publisher: QUE Publishing
  • ISBN: 0789734354

"Summarize 60,000 rows of data in seconds!"

The functionality behind pivot tables was actually invented by folks at the Lotus Advanced Technology Group in the late 1980s. Originally available only for Steve Job's NeXT computer, the technology became widely available in 1992 with the release of Improv. During Microsoft's bitter battle with Lotus for spreadsheet supremacy, the concept was added to Excel's data menu. Not many people understand how to actually make use of pivot tables.

As a data analyst in 1992, Bill Jelen quickly discovered the power behind pivot tables. "It was possible to create summary reports before Pivot Tables, but you had to build complicated DSUM formulas and weave them into an obscure feature called / Data Table 2. It would take an hour and make your head spin. If I ever tried to explain the process to a spreadsheet novice, their eyes would glaze over. It was something that was simply impossible to learn. Once Pivot Tables were added to Excel, anyone who can drag a mouse can create stunning summary reports in seconds.

"If you can drag a mouse, you can create a basic pivot table"

Imagine that you have 60,000 rows of transactional data like this:

Sample data
Sample data

Your department VP asks for a summary table showing sales by product and region. Without a pivot table, you are going to be learning CSE formulas or using the conditional sum wizard in combination with Data - Filter - Advanced Filter. But, with a pivot table, you can convert the 60,000 rows of data to this summary report with four mouse clicks and three mouse drags.

Create Pivot Table
Create Pivot Table

Once you have a pivot table, then one additional mouse drag allows you to transform the report to show detail by the customer or any other field.

Transform easily
Transform easily

Both of the above summary reports were created in seconds instead of hours.

"Includes features rarely seen in a pivot table!"

As if Pivot Tables were not powerful enough, you can also use them to create Top 10 reports or charts for each region, or tables showing year over year growth. Learn how to use Pivot Tables with Access or OLAP data. See how to use VBA to automate the creation of charts for each product or customer. This book will allow you to stop wasting time with obscure methods (I have to read Aladin's post every time that I try to use SUMPRODUCT...). This book will enable you to do analyses that were previously time-prohibitive. Become the Excel superstar in your office with just a few clicks of the mouse.

  • Introduction
  • 1. Pivot Table Fundamentals
  • 2. Creating a Basic Pivot Table
  • 3. Customizing Fields in a Pivot Table
  • 4. Formatting Your Pivot Table Report
  • 5. Controlling the Way You View Your Pivot Data
  • 6. Performing Calculations Within Your Pivot Tables
  • 7. Creating and Using Pivot Charts
  • 8. Using Disparate Data Sources for Your Pivot Table
  • 9. Using External Data Sources for Your Pivot Table
  • 10. Leveraging the Power of OLAP Cubes
  • 11. Enhancing Your Pivot Table Reports with Macros
  • 12. Using VBA to Create Pivot Tables
  • A. Solutions to Common Questions and Issues with Pivot Tables

Where to Buy

This product is currently out of stock and unavailable.


Other Editions


Pivot Table Data Crunching Microsoft Excel 2007

December 2006

This book consolidates all the best functionality of pivot tables into one guide that provides you with a meaningful tutorial, offering practical solutions to day-to-day problems.


Microsoft Excel 2019 Pivot Table Data Crunching

January 2019

Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.


Pivot Table Data Crunching: Microsoft Excel 2016

November 2015

Use Excel 2016 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control! Even if you’ve never created a pivot table before, this book will help you leverage all their amazing flexibility and analytical power.


Pivot Table Data Crunching: Microsoft Excel 2010

October 2010

PivotTables may be Excel's most powerful feature, but Microsoft has estimated that only 15% of Excel users take advantage of them. That's because PivotTables (and their companion feature, PivotCharts) have a reputation for being difficult to learn. Not any more!


Pivot Table Data Crunching Microsoft Excel 2013

January 2013

Use Excel 2013 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours… understand exactly what’s going on in your business… take control, and stay in control!