Excel 2007 PivotTables and PivotCharts

ebook Your visual blueprint for interpreting and presenting Excel data · Visual Blueprint

By Paul McFedries

cover image of Excel 2007 PivotTables and PivotCharts

Sign up to save your library

With an OverDrive account, you can save your favorite libraries for at-a-glance information about availability. Find out more about OverDrive accounts.

   Not today

Find this title in Libby, the library reading app by OverDrive.

Download Libby on the App Store Download Libby on Google Play

Search for a digital library with this title

Title found at these libraries:

Library Name Distance
Loading...

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 130 key techniques for working with PivotTables and PivotCharts, including:

  • Building PivotTables from Excel ranges
  • Customizing PivotTable field lists
  • Converting PivotTables to regular data
  • Grouping numeric, text, or date/time values
  • Developing various summary calculations
  • Turning a PivotTable into a PivotChart
  • Displaying data tables with a PivotChart
  • Creating an OLAP cube data source
  • Exporting Access(r) PivotTable(r) forms to Excel
  • Using Microsoft Query with PivotTables

EXTRA Apply It

  • "Apply It" and "Extra" sidebars highlight useful tips
  • 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

The EPUB format of this title may not be compatible for use on all handheld devices.

Excel 2007 PivotTables and PivotCharts