Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and presenting Excel data

Paul McFedries

  • 出版商: Hungry Minds
  • 出版日期: 2007-11-05
  • 售價: $1,010
  • 貴賓價: 9.5$960
  • 語言: 英文
  • 頁數: 290
  • 裝訂: Paperback
  • ISBN: 0470132310
  • ISBN-13: 9780470132319
  • 相關分類: Excel






Though many consumers know the basics of using Excel, few users understand the powerful capabilities of the PivotTable and PivotChart features. These tools can help turn long lists of unreadable data into dynamically generated, easy-to-read tables and charts that highlight useful and pertinent business information. Companies rely on this type of data from marketing, accounting, and finance to help make better decisions about products, sales and even human resources. Charts are interactive, allowing the consumer to tweak results with the click of a mouse and PivotTables allow you to fuse data from several sources into one document. This book shows users how to work with PivotTables and PivotCharts to make sense of their data. It covers features such as: understanding PivotTable benefits and uses; creating and customizing PivotTables; using PivotTables to analyze 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; publishing PivotTables to the Web; multiple consolidation of data, for example, summarizing annual fiscal data by quarters; preparing financial reporting, budgeting, and data analysis across departments; and using VBA to create macros that automate frequently used PivotTable tasks.

From the Back 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 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® PivotTable® forms to Excel

  • Using Microsoft Query with PivotTables

  • "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