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.
- ISBN10 0471784893
- ISBN13 9780471784890
- Publish Date 1 March 2006
- Publish Status Out of Stock
- Out of Print 12 February 2010
- Publish Country US
- Imprint John Wiley & Sons Inc
- Format Paperback
- Pages 292
- Language English