Provides more than one hundred techniques for creating PivotTables and PivotCharts.
Read More
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
Read Less