|
 |
|
 |
 |
Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and...
|
by Paul McFedries
Sales Rank: 103118
|
Discount: 72 %
List Price: $26.99
$17.81
At Amazon
|
|
Paperback: 290 pages
Publisher: Visual; Pap/Onl edition November 5, 2007
Language: English
ISBN-10: 0470132310
ISBN-13: 978-0470132319
Product Dimensions:
9 x 7.4 x 0.7 inches
Shipping Weight: 1.3 pounds
Book Description
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.
Back Cover Copy
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
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
|
Excel 2007 PivotTables and PivotCharts: Your visual blueprint for interpreting and...
List Price: $26.99
Discount: 72 %
Available from Amazon
Price: $17.81
| |
|
|
|
|
