O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Accessing and Analyzing Data with Microsoft® Excel

Book Description

Master the data analysis capabilities in Microsoft® Office applications—from sorting, filtering, and formatting data to performing sophisticated what-if scenarios, analyzing multidimensional data, and creating automated data-analysis solutions.

Table of Contents

  1. Copyright
  2. Foreword
  3. Acknowledgments
  4. Introduction
  5. Making Sense of Data
    1. The Types of Data That You Can Analyze
    2. Using Data to Make Decisions
    3. Developing a Data Analysis Strategy
    4. Understanding Microsoft Data Analysis Software and Features
    5. Summary
  6. Basic Data Analysis Techniques
    1. Sorting Data
    2. Summarizing Data
    3. Trending Data
    4. Filtering Data
    5. Formatting Data
    6. Importing, Exporting, and Querying Data
    7. Charting Data
    8. Pivoting Data
    9. Working with Data Lists
    10. Working with Relational and Multidimensional Data
    11. Working with XML Data
    12. Summary
  7. Analyzing Data with Microsoft Excel
    1. Sorting and Filtering Data
    2. Using Worksheet Functions
    3. Applying Conditional Formatting
    4. Working with Charts
    5. Importing External Data
    6. Querying External Data
    7. Analyzing Data in Lists
    8. Using the Analysis ToolPak
    9. Using the Solver Add-In
    10. Summary
  8. Analyzing Data with PivotTable and PivotChart Reports
    1. Understanding PivotTable and PivotChart Reports
    2. Analyzing Data with PivotTable Reports
    3. Analyzing Data with PivotChart Reports
    4. Summary
  9. Analyzing Data with Microsoft Access
    1. Understanding Relational and Nonrelational Data
    2. Connecting to External Data
    3. Sorting and Filtering Data
    4. Querying Data
    5. Creating Reports
    6. Analyzing Data with PivotTable and PivotChart Views
    7. Using Access to Integrate with SQL Server Databases
    8. Analyzing Access Data over the Web
    9. Summary
  10. Analyzing Data with the Office Web Components
    1. Introducing the Office Web Components
    2. Creating Office Web Components
    3. Using the Spreadsheet Component
    4. Using the PivotTable Component
    5. Using the Chart Component
    6. Summary
  11. Introducing Online Analytical Processing
    1. The Case for OLAP
    2. What Is OLAP?
    3. Using OLAP Data to Make Better Business Decisions
    4. Understanding Online Transaction Processing
    5. Data Storage Options
    6. Using Microsoft Office to Analyze OLAP Data
    7. Summary
  12. Analyzing OLAP Data with Microsoft Excel
    1. Connecting to OLAP Data
    2. Working with OLAP Data
    3. Creating Offline Cubes
    4. Summary
  13. Analyzing OLAP Data with Microsoft Data Analyzer
    1. Introducing Microsoft Data Analyzer
    2. Connecting to OLAP Data
    3. Viewing and Analyzing Data with Data Analyzer
    4. Creating Custom Measures
    5. Making Better Business Decisions
    6. Summary
  14. Working with XML Data in Excel and Access
    1. The Case for XML
    2. Making Sense of XML Data
    3. Analyzing XML Data with Microsoft Excel
    4. Working with XML Data with Microsoft Access
    5. Summary
  15. Extending Office Data Analysis Features with Code
    1. Understanding Office Code: Macros and Procedures
    2. Understanding Office Code: Programmatic Object Models
    3. Extending the Data Analysis Features in Microsoft Excel
    4. Programming the Data Analysis Features in Microsoft Access
    5. Extending the Data Analysis Features in the Microsoft Office Web Components
    6. Extending the Data Analysis Features in Microsoft Data Analyzer
    7. Summary
  16. Maintaining Data Reporting and Analysis Systems
    1. Creating and Implementing Database Maintenance Plans
    2. Maintaining SQL Server 2000 Databases
    3. Maintaining SQL Server 2000 Desktop Engine Databases
    4. Maintaining Access Databases
    5. Maintaining SQL Server 2000 Analysis Services Systems
    6. Additional Reading
    7. Summary
  17. Data Analysis Quick Reference
    1. Microsoft Excel
    2. Working with OLAP Data in Excel
    3. PivotTable Reports and PivotChart Reports
    4. Microsoft Access
    5. Microsoft Office Web Components
    6. Microsoft Data Analyzer
  18. Additional Tools and Resources
    1. CD Extras
    2. Online Data Analysis Resources
  19. About the Author
  20. Index