Excel Pivot Tables and Pivot Charts: Your Visual Blueprint for Creating Dynamic Spreadsheets - Softcover

McFedries, Paul

Softcover

ISBN 10: 0471784893 ISBN 13: 9780471784890

Verlag: John Wiley & Sons Inc, 2006

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 100 key techniques for creating PivotTables and PivotCharts, including: building a basic PivotTable, report Pivoting fields to different areas, filtering PivotTable data, organizing PivotTable data into groups, formatting a PivotTable, changing the summary calculation, creating custom calculations, publishing a PivotTable to the Web, creating a PivotChart from a PivotTable, and building a PivotTable from external data.'I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss' - Rob L. Meerscheidt (The Woodlands, TX). 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.

Über diesen Titel

Über die Autorin bzw. den Autor

Paul McFedries is the president of Logophilia Limited, a technical writing company. While now primarily a writer, Paul has worked as a programmer, consultant, and Web site developer. Paul has written over 40 books that have sold over three million copies worldwide. These books include the Wiley titles Teach Yourself VISUALLY Windows XP, Second Edition, Top 100 Simplified Tips and Tricks for Windows XP, Second Edition, and Teach Yourself VISUALLY Computers, Fourth Edition.

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 100 key techniques for creating PivotTables and PivotCharts, including:

• Building a basic PivotTable® report
• Pivoting fields to different areas
• Filtering PivotTable data
• Organizing PivotTable data into groups
• Formatting a PivotTable
• Changing the summary calculation
• Creating custom calculations
• Publishing a PivotTable to the Web
• Creating a PivotChart® from a PivotTable
• Building a PivotTable from external data

"I was stuck on an Excel problem for two days. Finally I opened one of your books, and there was a macro to accomplish exactly what I needed! You made me look good to the boss."
?Rob L. Meerscheidt (The Woodlands, TX)

• 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

Details zur Ausgabe

• Verlag: John Wiley & Sons Inc
• Erscheinungsdatum: 2006
• Sprache: Englisch
• ISBN 10: 0471784893
• ISBN 13: 9780471784890
• Einband: Tapa blanda
• Anzahl der Seiten: 292
• Kontakt zum Hersteller: Nicht verfügbar
• Verantwortliche Person: Nicht verfügbar