Excel 2007 PivotTables and PivotCharts: Your Visual Blueprint for Interpreting and Presenting Excel Data - Softcover

McFedries, Paul

Softcover

ISBN 10: 0470132310 ISBN 13: 9780470132319

Verlag: John Wiley & Sons Ltd, 2007

Inhaltsangabe

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

Über diesen Titel

Über die Autorin bzw. den Autor

Paul McFedries has been using and programming computers since the mid-1970s, and has been a fulltime technical writer since 1991. Paul has written more than 50 books that have sold over three million copies worldwide, including The Unofficial Guide to Microsoft Office 2007, Microsoft Office PowerPoint 2007: Top 100 Simplified Tips and Tricks, Teach Yourself VISUALLY Windows Vista, Windows Vista: Top 100 Simplified Tips and Tricks, and Teach Yourself VISUALLY Computers . Paul also runs Word Spy, a Web site dedicated to tracking new words and phrases (see www.wordspy.com).

Von der hinteren Coverseite

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

Details zur Ausgabe

• Verlag: John Wiley & Sons Ltd
• Erscheinungsdatum: 2007
• ISBN 10: 0470132310
• ISBN 13: 9780470132319
• Einband: Tapa blanda
• Sprache: Englisch
• Auflage: 2
• Anzahl der Seiten: 290
• Kontakt zum Hersteller: Nicht verfügbar