Accessing and Analyzing Data with Microsoft Excel (Paperback)

Description:

Sharpen your data analysis skills with tools from the Microsoft Office suite.

Master the tools that transform the information in spreadsheets, databases, and servers into faster, better business decisions. Packed with expert insights and practical Your Turn exercises, this essential guide shows how to use the data analysis capabilities in Microsoft® Office applications to capture data, analyze trends, identify risks—and seize opportunities. It covers everything from mastering the basics of sorting, filtering, and formatting data to performing sophisticated what-if scenarios, analyzing multidimensional data, and even creating automated data-analysis solutions.

Discover how to turn data into results!

• Help numbers tell the story with compelling, well-designed Excel charts, graphs, and reports
• Use PivotTable® and PivotChart® dynamic views to detect patterns and evaluate trends
• Use Data Analyzer to perform detailed analyses and present information in dynamic pie charts, bar graphs, and other views
• Publish and analyze data over the Web using Office Web Components
• Learn techniques to interpret—and exchange—XML data
• Analyze large databases using the OLAP features in Microsoft Excel
• Write code to automate data analysis and reporting solutions
• Implement a database maintenance plan that helps keep data accurate, accessible, and secure

Get tools and sample files on CD, including:

• Add-ins for Microsoft Access and Excel, including Report Manager, XML Spreadsheet, and OLAP CubeCellValue
• Dozens of sample PivotTables and PivotCharts to experiment with
• Office XP Web Component Toolpack
• Multimedia Data Analyzer tutorial
• Fully searchable eBook
• More code, databases, and extras to put your data to work!

Table of Contents:

Foreword

Acknowledgments

 Introduction

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

A   Data Analysis Quick Reference

B   Additional Tools and Resources

INDEX