Business runs on information and this essential guide explains how to use Microsoft Excel and other Microsoft Office tools to capture and analyze data for better decision making and problem solving. The author, a member of the Microsoft Office team, provides expert insights and guidance for business information workers at all levels from the sales rep tracking quotas on a spreadsheet to the executive making critical go and no-go decisions for an entire division. The book introduces the data analysis and storage tools in Office 2000 and Office XP, including Excel spreadsheets, PivotTable® and PivotChart® dynamic views, Microsoft Access databases, Office Web components, and Microsoft Data Analyzer. Readers learn when and how to use these tools to capture, analyze, manipulate, refine, and present data to support key business processes. Advanced data analysts and solution developers will also find information on online analytical processing (OLAP) systems, XML data, and automating data reporting and analysis.