You've collected reams of financial data from your business onto Microsoft Office Excel 2003 worksheets. Now you need to draw meaningful conclusions about your company's current status and future health from those numbers. PivotTable reports, a feature of Excel, can help you analyze your data from multiple perspectives, making it easier for you to discover patterns and exceptions and make faster, better business decisions.
You can use PivotTable reports to modify lists of numbers so that they emphasize key data. For example, a long list detailing a company's labor costs over the past year may not provide illuminating information at a glance. But the PivotTable and PivotChart Wizard make it a snap to rearrange the numbers in the data list so that you can immediately see how labor costs are allocated across departments.
After you've created a PivotTable report position — a configuration that highlights specific data — you can save that position so that you don't need to rebuild the PivotTable report again the next time you need to review the data.
Use the following information and tools to help you create PivotTable reports. You'll learn how to mine your business data for information that will improve your organization's performance.