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:<br>* Building a basic PivotTable? report<br>* Pivoting fields to different areas<br>* Filtering PivotTable data<br>* Organizing PivotTable data into groups<br>* Formatting a PivotTable<br>* Changing the summary calculation<br>* Creating custom calculations<br>* Publishing a PivotTable to the Web<br>* Creating a PivotChart? from a PivotTable<br>* Building a PivotTable from external data<br><br><br>"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."<br>--Rob L. Meerscheidt (The Woodlands, TX)<br>* High-resolution screen shots demonstrate each task<br>* Succinct explanations walk you through step by step<br>* Two-page lessons break big topics into bite-sized modules<br>* "Apply It" and "Extra" sidebars highlight useful tips