BIBLIO is the largest independent book marketplace in the world, with over 100 million books.

Skip to content

Excel Pivottables and Pivotcharts: Your Visual Blueprint for Creating Dynamic
Stock photo: cover may vary

Excel Pivottables and Pivotcharts: Your Visual Blueprint for Creating Dynamic Spreadsheets Paperback - 2010 - 2nd Edition

by Paul McFedries

Add to wish list

Reader reviews for Excel Pivottables and Pivotcharts: Your Visual Blueprint for Creating Dynamic Spreadsheets

Write a review for this book

There are no reviews for this book yet. Be the first to write a review!

Your review will be anonymous unless you login or create an account first.

Overall rating
Remember: You’re rating the book as a work, not the seller or the condition of the specific copy you purchased!

Important Terms and Guidelines

  • Please focus on the book’s content and context. Also, add any personal comments as to how you enjoyed the book. Substantiate your likes and dislikes. You may make comparisons to other books.
  • Reviews must be at least 140 characters in length.
  • Please do not reveal critical plot elements.
  • This is not a help line. Contact customer support if you need help.
Your review must not include:
  • Obscenities, discriminatory language, or other insulting language not suitable for public domain
  • Advertisements, “spam” content, or references to other products, offers or websites.
  • Email addresses, URLs, phone numbers, physical addresses or other contact information.
  • Overly critical comments about other reviews or reviewers
  • Time-sensitive material (i.e. promotional tours, seminars, lectures, etc.)
  • Availability, price, or alternative ordering/shipping information

From the publisher

Master two of the most powerful features of Excel

Even if you use Excel all the time, you may not be up to speed on two of Excel's most useful features. PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document. Now you can learn how to tap these powerful Excel tools with this practical guide.

Using a series of step-by-step tutorials and easy-to-follow screenshots, this book shows you in a visual way how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.

  • Explains the benefits PivotTables and PivotCharts, two powerful features of Excel that allow users to create dynamic spreadsheets
  • Covers creating and customizing, analyzing business data, building custom calculations, linking to external data sources (including Access databases, Word tables, Web pages, XML data, SQL Server databases, and OLAP cubes), creating macros to automate tasks, and more
  • Uses step-by-step tutorials and easy-to-follow screenshots, a "learn by seeing" approach for visual learners

Practical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.

From the rear cover

Welcome to the only guidebook series that takes a visual approach to professional-level computer topics. Open the book and you'll discover step-by-step screen shots that demonstrate over 135 key techniques with Excel PivotTables and PivotCharts, including:

  • Creating a table for a PivotTable report

  • Converting a PivotTable to regular data

  • Changing the Report Filter layout

  • Formatting PivotTable cells

  • Displaying a data table with a PivotChart

  • Performing PivotTable calculations

  • Building formulas for PivotTables

  • Filtering records with Query criteria

  • Creating an OLAP cube data source

  • Learning VBA basics for PivotTables

  • High-resolution screen shots demonstrate each task

  • Succinct explanations walk you through step by step

  • Two-page lessons break big topics into bite-sized modules

  • "Apply It" and "Extra" sidebars highlight useful tips

Details

  • Title Excel Pivottables and Pivotcharts: Your Visual Blueprint for Creating Dynamic Spreadsheets
  • Author Paul McFedries
  • Binding Paperback
  • Edition number 2nd
  • Edition 2
  • Pages 304
  • Volumes 1
  • Language ENG
  • Publisher Visual
  • Publication date 2010-06-28
  • Features Glossary, Index, Price on Product - Canadian, Table of Contents
  • ISBN 9780470591611 / 0470591617
  • Weight 1.33 lbs (0.60 kg)
  • Dimensions 9 x 7.3 x 0.7 in (22.86 x 18.54 x 1.78 cm)
  • Category Computers - Spreadsheets
  • Library of Congress subjects Electronic spreadsheets
  • Library of Congress Catalogue Number 2010926851
  • Dewey Decimal Code 005.54

About the author

Paul McFedries is a full-time technical writer. Paul has been authoring computer books since 1991 and he has more than 70 books to his credit. Paul's books have sold more than three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Excel 2010; Excel 2010 Visual Quick Tips; Teach Yourself VISUALLY Windows 7; and Teach Yourself VISUALLY Office 2008 for Mac. Paul is also the proprietor of Word Spy (www.wordspy.com and twitter.com/wordspy), a Web site that tracks new words and phrases as they enter the language. Paul invites you to drop by his personal Web site at www.mcfedries.com or to follow him on Twitter at twitter.com/paulmcf.
Back to top↑

More Copies for Sale

Show all copies
Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

by McFedries, Paul

  • Used
  • Very good
Condition
Very good
Edition
2
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
BooksRun
Item price
A$8.21
Free Delivery to USA

Show details

Description:
Visual. 2. Very Good. It's a well-cared-for item that has seen limited use. The item may show minor signs of wear. All the text is legible, with all pages included. It may have slight markings and/or highlighting.
Add to wish list
Item price
A$8.21
Free Delivery to USA
Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

by McFedries, Paul

  • Used
Condition
New
Edition
2
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
Academic Book Solutions Inc.
Biblio Top Seller
Item price
A$8.51
A$5.66 Delivery to USA

Show details

Description:
Visual, 2010-06-28. 2. Used - Like New. Used Like New, no missing pages, no damage to binding, may have a remainder mark.
Add to wish list
Item price
A$8.51
A$5.66 Delivery to USA
Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

by McFedries, Paul

  • Used
Condition
Used
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
Wonder Book
Item price
A$9.30
A$5.66 Delivery to USA

Show details

Description:
Visual. Used - Very Good. Very Good condition. 2nd edition. A copy that may have a few cosmetic defects. May also contain light spine creasing or a few markings such as an owner’s name, short gifter’s inscription or light stamp.
Add to wish list
Item price
A$9.30
A$5.66 Delivery to USA
Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

by McFedries, Paul

  • Used
Condition
New
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
Wonder Book
Item price
A$9.77
A$5.66 Delivery to USA

Show details

Description:
Visual. Used - Like New. Like New condition. 2nd edition. A near perfect copy that may have very minor cosmetic defects.
Add to wish list
Item price
A$9.77
A$5.66 Delivery to USA
Excel PivotTables and PivotCharts : Your Visual Blueprint for Creating Dynamic Spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts : Your Visual Blueprint for Creating Dynamic Spreadsheets

by McFedries, Paul

  • Used
Condition
Used
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
Better World Books
Biblio Top Seller
Item price
A$10.75
Free Delivery to USA

Show details

Description:
Wiley & Sons, Incorporated, John. Used - Very Good. Pages intact with possible writing/highlighting. Binding strong with minor wear. Dust jackets/supplements may not be included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.
Add to wish list
Item price
A$10.75
Free Delivery to USA
Excel PivotTables and PivotCharts : Your Visual Blueprint for Creating Dynamic Spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts : Your Visual Blueprint for Creating Dynamic Spreadsheets

by McFedries, Paul

  • Used
Condition
Used
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
2
Seller
Better World Books
Item price
A$10.75
Free Delivery to USA

Show details

Description:
Wiley & Sons, Incorporated, John. Used - Good. Pages intact with minimal writing/highlighting. The binding may be loose and creased. Dust jackets/supplements are not included. Stock photo provided. Product includes identifying sticker. Better World Books: Buy Books. Do Good.
Add to wish list
Item price
A$10.75
Free Delivery to USA
Excel Pivottables and Pivotcharts: Your Visual Blueprint for Creating Dynamic Spreadsheets

Excel Pivottables and Pivotcharts: Your Visual Blueprint for Creating Dynamic Spreadsheets

by McFedries, Paul

  • Used
  • Very good
  • Paperback
Condition
Very good
Binding
Paperback
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
ThriftBooks
Biblio Top Seller
Item price
A$11.30
Free Delivery to USA

Show details

Description:
Visual, 2010. Paperback. Very Good. May have limited writing in cover pages. Pages are unmarked. ~ ThriftBooks: Read More, Spend Less.Dust jacket quality is not guaranteed.
Add to wish list
Item price
A$11.30
Free Delivery to USA
Excel PivotTables and PivotCharts : Your Visual Blueprint for Creating Dynamic Spreadsheets

Excel PivotTables and PivotCharts : Your Visual Blueprint for Creating Dynamic Spreadsheets

by Paul McFedries

  • Used
  • as new
  • Paperback
Condition
New
Binding
Paperback
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
ThriftBooks
Biblio Top Seller
Item price
A$11.30
Free Delivery to USA

Show details

Description:
Wiley & Sons, Incorporated, John, 2010. Paperback. As New. Disclaimer:An apparently unread copy in perfect condition. Dust cover is intact; pages are clean and are not marred by notes or folds of any kind. At ThriftBooks, our motto is: Read More, Spend Less.Dust jacket quality is not guaranteed.
Add to wish list
Item price
A$11.30
Free Delivery to USA
Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

by McFedries, Paul

  • Used
  • Paperback
Condition
Used
Edition
2
Binding
Paperback
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
1
Seller
Ergodebooks
Item price
A$11.88
Free Delivery to USA

Show details

Description:
Wiley-Interscience, 2010-06-28. 2. paperback. Used: Good. 7.30x0.70x9.00. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$11.88
Free Delivery to USA
Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets
Stock photo: cover may vary

Excel PivotTables and PivotCharts: Your visual blueprint for creating dynamic spreadsheets

by McFedries, Paul

  • New
  • Paperback
Condition
New
Edition
2
Binding
Paperback
ISBN 10 / ISBN 13
9780470591611 / 0470591617
Quantity available
6
Seller
Ergodebooks
Item price
A$29.85
Free Delivery to USA

Show details

Description:
Wiley-Interscience, 2010-06-28. 2. paperback. New. 7.30x0.70x9.00. Buy with confidence. Excellent Customer Service & Return policy.
Add to wish list
Item price
A$29.85
Free Delivery to USA
Show all copies
Back to top↑

Please wait a moment while we load the requested page.