logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA
Irish Culture
Home Finance


dailyclick
All times in EST

Low Carb: 8:00 PM

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

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


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 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


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


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


BellaOnline Editor