Excel PivotTables and PivotCharts : your visual blueprint for creating dynamic spreadsheets

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.