Excel PivotTables and PivotCharts Your Visual Blueprint for Creating Dynamic Spreadsheets

ISBN-10: 0470591617

ISBN-13: 9780470591611

Edition: 2nd 2010

Authors: Paul McFedries

List price: $21.99 Buy it from $9.41
30 day, 100% satisfaction guarantee

If an item you ordered from TextbookRush does not meet your expectations due to an error on our part, simply fill out a return request and then return it by mail within 30 days of ordering it for a full refund of item cost.

Learn more about our returns policy


Master two of the most powerful features of ExcelEven 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 learnersPractical, visual, and packed with content, this is the book you need to ramp up your Excel skills with PivotTables and PivotCharts.
New Starting from $26.74
what's this?
Rush Rewards U
Members Receive:
You have reached 400 XP and carrot coins. That is the daily max!
Study Briefs

Limited time offer: Get the first one free! (?)

All the information you need in one place! Each Study Brief is a summary of one specific subject; facts, figures, and explanations to help you learn faster.

Add to cart
Study Briefs
SQL Online content $4.95 $1.99
Add to cart
Study Briefs
MS Excel® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS Word® 2010 Online content $4.95 $1.99
Add to cart
Study Briefs
MS PowerPoint® 2010 Online content $4.95 $1.99
Customers also bought

Book details

List price: $21.99
Edition: 2nd
Copyright year: 2010
Publisher: John Wiley & Sons, Limited
Publication date: 6/25/2010
Binding: Paperback
Pages: 304
Size: 7.50" wide x 9.25" long x 0.75" tall
Weight: 1.320
Language: English

How To Use This Book
Understanding Pivottables And Pivotcharts
Understanding Data Analysis
Introducing the PivotTable
Learn PivotTable Benefits
Learn When to Use PivotTables
Explore PivotTable Features
Introducing the PivotChart
Building A Pivottable
Prepare Your Worksheet Data
Create a Table for a PivotTable Report
Build a PivotTable from an Excel Table
Build a PivotTable from an Excel Range
Recreate an Existing PivotTable
Manipulating Your Pivottable
Turn the PivotTable Field List On and Off
Customize the PivotTable Field List
Select PivotTable Items
Remove a PivotTable Field
Refresh PivotTable Data
Display the Details Behind PivotTable Data
Create a Chart from PivotTable Data
Enable the Classic PivotTable Layout
Add Multiple Fields to the Row or Column Area
Add Multiple Fields to the Data Area
Add Multiple Fields to the Report Filter
Publish a PivotTable to a Web Page
Convert a PivotTable to Regular Data
Delete a PivotTable
Changing The Pivottable View
Move a Field to a Different Area
Change the Order of Fields within an Area
Change the Report Layout
Sort PivotTable Data with AutoSort
Move Row and Column Items
Group Numeric Values
Group Date and Time Values
Group Text Values
Hide Group Details
Show Group Details
Ungroup Values
Filtering A Pivottable
Apply a Report Filter
Change the Report Filter Layout
Filter Row or Column Items
Filter PivotTable Values
Hide Items in a Row or Column Field
Use Search to Display Multiple Items
Show Hidden Items in a Row or Column Field
Filter a PivotTable with a Slicer
Connect a PivotTable to an Existing Slicer
Connect a Slicer to Multiple PivotTables
Customizing Pivottable Fields
Rename a PivotTable Field
Rename a PivotTable Item
Format a PivotTable Cell
Apply a Numeric Format to PivotTable Data
Apply a Date Format to PivotTable Data
Apply a Conditional Format to PivotTable Data
Show Items with No Data
Exclude Items from a Report Filter
Repeat Item Labels in Fields
Creating A Pivotchart
Understanding PivotChart Limitations
Create a PivotChart from a PivotTable
Create a PivotChart beside a PivotTable
Create a PivotChart from an Excel Table
Move a PivotChart to another Sheet
Filter a PivotChart
Change the PivotChart Type
Sort the PivotChart
Add PivotChart Titles
Move the PivotChart Legend
Display a Data Table with the PivotChart
Setting Pivottable Options
Apply a PivotTable Quick Style
Create a Custom PivotTable Quick Style
Preserve PivotTable Formatting
Rename the PivotTable
Turn Off Grand Totals
Merge Item Labels
Specify Characters for Errors and Empty Cells
Protect a PivotTable
Performing Pivottable Calculations
Change the PivotTable Summary Calculation
Create a Difference Summary Calculation
Create a Percentage Summary Calculation
Create a Running Total Summary Calculation
Create an Index Summary Calculation
Turn Off Subtotals for a Field
Display Multiple Subtotals for a Field
Creating Custom Pivottable Calculations
Introducing Custom Calculations
Understanding Custom Calculation Limitations
Insert a Custom Calculated Field
Insert a Custom Calculated Item
Edit a Custom Calculation
Change the Solve Order of Calculated Items
List Your Custom Calculations
Delete a Custom Calculation
Building Formulas For Pivottables
Introducing Formulas
Understanding Formula Types
Introducing Worksheet Functions
Understanding Function Types
Build a Function
Build a Formula
Work with Custom Numeric and Date Formats
Using Microsoft Query With Pivottables
Understanding Microsoft Query
Define a Data Source
Start Microsoft Query
Tour the Microsoft Query Window
Add a Table to the Query
Add Fields to the Query
Filter the Records with Query Criteria
Sort the Query Records
Return the Query Results
Importing Data For Pivottables
Understanding External Data
Import Data from a Data Source
Import Data from an Access Table
Import Data from a Word Table
Import Data from a Text File
Import Data from a Web Page
Import Data from an XML File
Create a PowerPivot Data Connection
Refresh Imported Data
Building More Advanced Pivottables
Create a PivotTable from Multiple Consolidation Ranges
Create a PivotTable from an Existing PivotTable
Create a PivotTable from External Data
Create a PivotTable Using PowerPivot
Automatically Refresh a PivotTable that Uses External Data
Save Your Password with an External Data Connection
Export an Access PivotTable Form to Excel
Reduce the Size of PivotTable Workbooks
Use a PivotTable Value in a Formula
Building A Pivottable From An Olap Cube
Understanding OLAP
Create an OLAP Cube Data Source
Create a PivotTable from an OLAP Cube
Show and Hide Details for Dimensions and Levels
Hide Levels
Display Selected Levels and Members
Display Multiple Report Filter Items
Include Hidden Items in PivotTable Totals
Performing What-if Analysis on the PivotTable
Create an Offline OLAP Cube
Learning Vba Basics For Pivottables
Open the VBA Editor
Add a Macro to a Module
Run a Macro
Set Macro Security
Assign a Shortcut Key to a Macro
Appendix: Glossary Of Pivottable Terms
Free shipping on orders over $35*

*A minimum purchase of $35 is required. Shipping is provided via FedEx SmartPost® and FedEx Express Saver®. Average delivery time is 1 – 5 business days, but is not guaranteed in that timeframe. Also allow 1 - 2 days for processing. Free shipping is eligible only in the continental United States and excludes Hawaii, Alaska and Puerto Rico. FedEx service marks used by permission."Marketplace" orders are not eligible for free or discounted shipping.

Learn more about the TextbookRush Marketplace.