Accessing and Analyzing Data with Microsoft Excel

The business person's one-stop guide to data analysis with Microsoft Office

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.

Contents

1. Making Sense of Data
2. Basic Data Analysis Techniques
3. Analyzing Data with Microsoft Excel
4. Analyzing Data with PivotTable and PivotChart Reports
5. Analyzing Data with Microsoft Access
6. Analyzing Data with the Office Web Components
7. Introducing Online Analytical Processing
8. Analyzing OLAP Data with Microsoft Excel
9. Analyzing OLAP Data with Microsoft Data Analyzer
10. Working with XML Data in Excel and Access
11. Extending Office Data Analysis Features with Code
12. Maintaining Data Reporting and Analysis Systems