Pivot Table Data Crunching: Microsoft Excel 2010 [NOOK Book]

Overview

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! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining...

See more details below
Pivot Table Data Crunching: Microsoft Excel 2010

Available on NOOK devices and apps  
  • NOOK Devices
  • Samsung Galaxy Tab 4 NOOK 7.0
  • Samsung Galaxy Tab 4 NOOK 10.1
  • NOOK HD Tablet
  • NOOK HD+ Tablet
  • NOOK eReaders
  • NOOK Color
  • NOOK Tablet
  • Tablet/Phone
  • NOOK for Windows 8 Tablet
  • NOOK for iOS
  • NOOK for Android
  • NOOK Kids for iPad
  • PC/Mac
  • NOOK for Windows 8
  • NOOK for PC
  • NOOK for Mac

Want a NOOK? Explore Now

NOOK Book (eBook)
$15.49
BN.com price
(Save 44%)$27.99 List Price

Overview

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! In this book, Excel legends Bill Jelen ("MrExcel") and Michael Alexander teach PivotTables and PivotCharts step-by-step, using realistic business scenarios that any Excel user can intuitively understand. Jelen and Alexander go far beyond merely explaining PivotTables and PivotCharts: they present practical "recipes" for solving a wide range of business problems. Drawing on more than 30 combined years of Excel experience, they provide tips and tricks you won't find anywhere else, and show exactly how to sidestep common mistakes. Coverage includes: " Creating PivotTables, customizing them, and changing the way you view them " Performing calculations within PivotTables " Using PivotCharts and other visualizations " Analyzing multiple data sources with PivotTables " Sharing PivotTables with others " Working with and analyzing OLAP data " Making the most of Excel 2010's powerful new PowerPivot feature " Using Excel 2010's Slicer to dynamically filter PivotTables " Enhancing PivotTables with macros and VBA code This book is part of the new MrExcel Library series, edited by Bill Jelen, world-renowned Excel expert and host of the enormously popular Excel help site, MrExcel.com.

  • Teaches PivotTables, PivotCharts, and Excel 2010's new PowerPivot feature through real-world scenarios that make intuitive sense to users at all levels
  • Includes proven PivotTable recipes for instant on-the-job results
  • Helps Excel users avoid common pitfalls and mistakes
  • Part of the brand-new MrExcel Library series, edited by Excel legend Bill Jelen
Read More Show Less

Product Details

  • ISBN-13: 9780789746689
  • Publisher: Pearson Education
  • Publication date: 11/3/2010
  • Series: MrExcel Library
  • Sold by: Barnes & Noble
  • Format: eBook
  • Edition number: 1
  • Pages: 384
  • Sales rank: 511,094
  • File size: 28 MB
  • Note: This product may take a few minutes to download.

Meet the Author

Bill Jelen, known worldwide as MrExcel, presents live Excel seminars to accountants throughout the U.S. His 20 books on Microsoft Excel include Special Edition Using Excel 2007, Pivot Table Data Crunching, and VBA and Macros for Microsoft Excel. Honored as a Microsoft MVP for Excel, he has produced 500 episodes of his "Learn Excel from MrExcel" video podcast. Michael Alexander, is a Microsoft Certified Application Developer (MCAD), Senior Program Manager for a top Texas technology firm, and principal of DataPigTechnologies, a developer of Excel tutorials. He is author of several books on data analysis with Access and Excel.
Read More Show Less

Table of Contents

Introduction
1. Pivot Table Fundamentals
2. Creating Basic Pivot Table
3. Customizing a Pivot Table
4. Controlling the Way you View your PivotTable
5. Performing Calculations Within your PivotTables
6. Using Pivot Charts and Other Visualizations
7. Analyzing Disparate Data Sources with PivotTables
8. Sharing PivotTables with Others
9. Working With and Analyzing OLAP Data
10. Excel PowerPivot
11. Enhancing PivotTables with Macros
12. Using VBA to Create Pivot Tables
13. Advanced PivotTable Tips and Tricks
Appendix A. Finding PivotTable Commands on the Ribbon
Read More Show Less

Customer Reviews

Average Rating 3.5
( 8 )
Rating Distribution

5 Star

(3)

4 Star

(1)

3 Star

(1)

2 Star

(1)

1 Star

(2)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing all of 8 Customer Reviews
  • Anonymous

    Posted April 22, 2012

    I highly recommend this book it is best of class

    I highly recommend this book it is best of class.
    Also explains data slicers

    Was this review helpful? Yes  No   Report this review
  • Anonymous

    Posted December 25, 2010

    No text was provided for this review.

  • Anonymous

    Posted April 9, 2011

    No text was provided for this review.

  • Anonymous

    Posted April 10, 2011

    No text was provided for this review.

  • Anonymous

    Posted February 18, 2011

    No text was provided for this review.

  • Anonymous

    Posted December 26, 2010

    No text was provided for this review.

  • Anonymous

    Posted February 4, 2014

    No text was provided for this review.

  • Anonymous

    Posted December 30, 2010

    No text was provided for this review.

Sort by: Showing all of 8 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)