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
     
 

View All Available Formats & Editions

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

See more details below

Overview

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

Read More

Product Details

ISBN-13:
9780470591611
Publisher:
Wiley
Publication date:
06/28/2010
Series:
Visual Blueprint Series, #30
Pages:
304
Sales rank:
205,468
Product dimensions:
7.30(w) x 9.00(h) x 0.80(d)

Related Subjects

Read an Excerpt

http://catalogimages.wiley.com/images/db/pdf/9780470591611.excerpt.pdf

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >