g Text Version
Beauty & Self
Books & Music
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
News & Politics
Religion & Spirituality
Travel & Culture
TV & Movies

Bored? Games!
Take a Quiz
Rate My Photo

Folklore and Mythology
Women's Fashion
Holiday/Seasonal Cooking
Hiking & Backpacking
New Age
Weight Loss

All times in EST

Full Schedule
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor


Pivot Table Data Crunching Review

Guest Author - Chris Curtis

Published in 2006 by Pearson Technology Group, Pivot Table Data Crunching Review was written by Bill Jelen and Michael Alexander. Both Jelen and Alexander have extensive experience consulting and developing office solutions for clients worldwide. Jelen is the webmaster for one of the top Excel websites MrExcel.com. Alexander’s website is datapigtechnologies.com. Both sites are excellent resources for information on Excel.

Pivot Table Data Crunching provides comprehensive coverage of Pivot Table techniques from the basics to the advanced skills. I have taught pivot tables in a Fortune 100 company and developed my own training materials because I could not find a text book that specifically tackled the subject matter of Pivot Tables. With the release of Pivot Table Data Crunching, I would now use this book supplemented with my own materials.

Excel provides a variety of powerful tools for managing and analyzing data. Statistically, 50% of Excel users utilize about 20% of its power. The Pivot Table feature is one of the most under utilized utilities, yet provides an amazing functionality for summarizing and analyzing large amounts of data. This book will help you unleash the power of the Pivot Table and improve your productivity and the quality of your analyses.

The book is written in an easy to understand language. Each new concept is fully illustrated with meaningful figures to visually get the ideas across. Throughout the book, you will find Case Studies to help users conceptualize under what circumstances to use a Pivot Table and are illustrative of the concepts presented in the chapter. The data source for the book is downloadable at MrExcel.com. There are notes, practical tips, and cautions imbedded in both the text and case studies that provide additional guidance, many that can be used generally within Excel.

There are 13 Chapters in the book. Chapter headings are as follows:

• Pivot Table Fundamentals
• Creating a Basic Pivot Table
• Formatting Your Pivot Table Report
• Controlling the Way you View your Pivot Data
• Performing Calculations within your Pivot Tables
• Creating and Using Pivot Charts
• Using Disparate Data Sources for you Pivot Table
• Using External Data Sources for your Pivot Table
• Leveraging the Power of OLAP cubes
• Enhancing your Pivot Table Report with Macros
• Using VBA to Create Pivot Tables
• Exhibit A is a solution guide to common questions and issues with Pivot Table.

What I like about this book is that it builds your skills as you progress through the chapters. Although there is some very advanced concepts and techniques in this book, you don’t need to be a technology guru to get something from it.

Add Pivot+Table+Data+Crunching+Review to Twitter Add Pivot+Table+Data+Crunching+Review to Facebook Add Pivot+Table+Data+Crunching+Review to MySpace Add Pivot+Table+Data+Crunching+Review to Del.icio.us Digg Pivot+Table+Data+Crunching+Review Add Pivot+Table+Data+Crunching+Review to Yahoo My Web Add Pivot+Table+Data+Crunching+Review to Google Bookmarks Add Pivot+Table+Data+Crunching+Review to Stumbleupon Add Pivot+Table+Data+Crunching+Review to Reddit

RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map

For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter

Past Issues

Printer Friendly
tell friend
Tell a Friend
Email Editor

Content copyright © 2015 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map


Past Issues

Less than Monthly

BellaOnline on Facebook

| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2015 Minerva WebWorks LLC. All rights reserved.

BellaOnline Editor