Excel Pivot Tables Recipe Book

Klappentext:

Pivot Tables are one of the Microsoft Excel spreadsheet s hidden gems. They are simultaneously powerful and intimidating to Office users. They allow you to quickly summarize and analyze large amounts of data in lists and tables--independent of the original data layout in your spreadsheet--by dragging and dropping columns to different rows, columns, or summary positions. This ability to create neat, informative summaries out of huge lists of raw data is an immensely powerful tool, and one that is rapidly growing in popularity.

Pivot Tables are a growth area with huge numbers of people beginning to realize the powerful tools they have available on their desktops (as evidenced by the success of our previous Pivot Tables book (A Complete Guide to PivotTables: A Visual Approach, 1-59059-432-0). This book is a complement to that. It provides its readers with an indispensable quick-reference to solve the common problems that beset Excel users venturing into this area for the first time. It s succinct problem-solution style, and willingness to discuss the practical details of Pivot Table use set it apart from the competition.

Inhaltsverzeichnis:

Creating a Pivot Table.- Sorting and Grouping Pivot Table Data.- Calculations in a Pivot Table.- Formatting a Pivot Table.- Extracting Pivot Table Data.- Modifying a Pivot Table.- Updating a Pivot Table.- Securing a Pivot Table.- Maximize Pivot Table Performance.- Publishing a Pivot Table.- Printing a Pivot Table.- Troubleshooting a Pivot Table.- Pivot Charts.- Programming a Pivot Table.

Themen:

• Excel 2002; Spezielle Anwendungsbereiche
• Excel 2003; Spezielle Anwendungsbereiche

Verwandte Themen:

• Excel 2000; Spezielle Anwendungsbereiche
• Excel 2007; Spezielle Anwendungsbereiche
• Excel 97; Spezielle Anwendungsbereiche
• Excel; Spezielle Anwendungsbereiche
• Excel 2010; Spezielle Anwendungsbereiche
• Datenanalyse
• Personalwesen
• Excel 2010; Einführung
• Wirtschaftsrechnen; Schulbuch
• Controlling