Star Wars Sale
 
 

Special Offers see all

Enter to WIN!

Weekly drawing for $100 credit. Subscribe to PowellsBooks.news for a chance to win.
Privacy Policy

More at Powell's


Recently Viewed clear list


The Powell's Playlist | June 18, 2014

Daniel H. Wilson: IMG The Powell’s Playlist: Daniel H. Wilson



Like many writers, I'm constantly haunting coffee shops with a laptop out and my headphones on. I listen to a lot of music while I write, and songs... Continue »
  1. $18.87 Sale Hardcover add to wish list

    Robogenesis

    Daniel H. Wilson 9780385537094

spacer
Qualifying orders ship free.
$31.50
New Trade Paper
Ships in 1 to 3 days
Add to Wishlist
available for shipping or prepaid pickup only
Available for In-store Pickup
in 7 to 12 days
Qty Store Section
2 Remote Warehouse Personal Computers- Desktop Applications- Spreadsheets

Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf)

by

Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf) Cover

 

Synopses & Reviews

Publisher Comments:

Take full advantage of Excel's interpretive power

Why do you need another book on Excel? Because this one is devoted to PivotTables and PivotCharts, Excel's powerful tools that enable you to pull meaningful information from masses of seemingly meaningless data—information you can actually use.

If you're new to PivotTables, this book is for you. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You'll learn to work with multidimensional data and even how to create and manipulate PivotTables using VBA.

Most important, you'll discover what these tools can do for you. Are you ready?

Peter Aitken's Chart Toppers

  • Topper # 1 Understanding and Creating PivotTables
  • Topper # 2 Using Excel 2007's PivotTable Tools

  • Topper # 3 Working with PivotCharts

  • Topper # 4 Using External and Multidimensional Data

  • Topper # 5 Programming PivotTables with VBA

Synopsis:

* Demonstrates how to work with PivotTable components, confidently use PivotCharts, use PivotTables with multi-dimensional data, get hard data from a PivotTable, and more

Synopsis:

Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.

Synopsis:

  • Excel is the standard among spreadsheet applications with an installed base of hundreds of millions, and has proven to be a valuable tool in many different industries
  • This book helps readers take their Excel 2007 skills to the next level by offering key information on PivotTables and PivotCharts, which are powerful tools within Excel used for analyzing, summarizing, and organizing data to reveal meanings that would not otherwise be visible
  • Walks readers through the untapped capabilities of PivotTables and PivotCharts by combining both reference and tutorial approaches
  • Many chapters include a case study that illustrates how to apply Excel solutions in the real world
  • Demonstrates how to work with PivotTable components, confidently use PivotCharts, use PivotTables with multi-dimensional data, get hard data from a PivotTable, and more
  • About the Author

    Peter G. Aitken has written some 45 books and hundreds of articles on computer topics. His consulting firm, PGA Consulting, focuses on services involving Excel, including programming, custom templates, and troubleshooting. Peter is the coauthor of Excel 2007 Formulas and Functions For Dummies (Wiley).

    John Walkenbach, Series Editor, has written more than 30 Excel books, including Excel 2007 VBA Programming For Dummies and Excel 2007 Bible, also from Wiley. Visit his popular Spreadsheet Page at www.j-walk.com/ss.

    Table of Contents

    Introduction.

    Part I: PivotTable Fundamentals.

    Chapter 1: Understanding PivotTables and Charts.

    Chapter 2: Understanding Data Sources for PivotTables.

    Chapter 3: Using PivotTable Tools and Formatting.

    Part II: PivotTables and Charts: Going Beyond the Basics.

    Chapter 4: Working with PivotTable Components.

    Chapter 5: More About PivotTable Components.

    Chapter 6: Understanding and Using PivotCharts.

    Part III: Getting the Most out of PivotTables and Charts.

    Chapter 7: Using PivotTables with Multidimensional Data.

    Chapter 8: Getting Hard Data from a PivotTable.

    Chapter 9: PivotTable Alternatives.

    Chapter 10: Programming PivotTables with VBA.

    Appendix A: Troubleshooting PivotTables and PivotCharts.

    Appendix B: Excel Version Differences for PivotTables.

    Appendix C: An Excel Chart Primer.

    Index.

    Product Details

    ISBN:
    9780470104873
    Author:
    Aitken, Peter G.
    Publisher:
    Wiley
    Subject:
    Spreadsheets - Excel
    Subject:
    Business
    Subject:
    Electronic spreadsheets
    Subject:
    Spreadsheets - General
    Subject:
    Business -- Computer programs.
    Subject:
    Personal Computers-Applications
    Subject:
    Microsoft Excel
    Subject:
    Personal Computers-Desktop Applications-Spreadsheets
    Copyright:
    Edition Description:
    WebSite Associated w/Book
    Series:
    Mr. Spreadsheet's Bookshelf
    Series Volume:
    4
    Publication Date:
    20070702
    Binding:
    Electronic book text in proprietary or open standard format
    Grade Level:
    General/trade
    Language:
    English
    Illustrations:
    Y
    Pages:
    312
    Dimensions:
    9.18x7.40x.68 in. .99 lbs.

    Related Subjects

    Computers and Internet » Personal Computers » Desktop Applications » Spreadsheets

    Excel 2007 PivotTables and PivotCharts (Mr. Spreadsheet's Bookshelf) New Trade Paper
    0 stars - 0 reviews
    $31.50 In Stock
    Product details 312 pages John Wiley & Sons - English 9780470104873 Reviews:
    "Synopsis" by , * Demonstrates how to work with PivotTable components, confidently use PivotCharts, use PivotTables with multi-dimensional data, get hard data from a PivotTable, and more
    "Synopsis" by , Devoted entirely to PivotTables and PivotCharts, this book shows you how to take full advantage of these powerful tools, which enable you to pull meaningful information from masses of seemingly meaningless data. Loaded with illustrations and real-world examples, it takes you step by step through creating a PivotTable; formatting, filtering, and grouping data; creating PivotCharts from those data; and more. You’ll learn to work with multidimensional data, how to create and manipulate PivotTables using VBA, and—most importantly—you’ll discover what these tools can do for you.
    "Synopsis" by ,
  • Excel is the standard among spreadsheet applications with an installed base of hundreds of millions, and has proven to be a valuable tool in many different industries
  • This book helps readers take their Excel 2007 skills to the next level by offering key information on PivotTables and PivotCharts, which are powerful tools within Excel used for analyzing, summarizing, and organizing data to reveal meanings that would not otherwise be visible
  • Walks readers through the untapped capabilities of PivotTables and PivotCharts by combining both reference and tutorial approaches
  • Many chapters include a case study that illustrates how to apply Excel solutions in the real world
  • Demonstrates how to work with PivotTable components, confidently use PivotCharts, use PivotTables with multi-dimensional data, get hard data from a PivotTable, and more
  • spacer
    spacer
    • back to top
    Follow us on...




    Powell's City of Books is an independent bookstore in Portland, Oregon, that fills a whole city block with more than a million new, used, and out of print books. Shop those shelves — plus literally millions more books, DVDs, and gifts — here at Powells.com.