Accessing and Analyzing Data with Microsoft Excel (Bpg-Other)

Chapter 1: Making Sense of Data

Objectives

All About Data

Chapter 2: Basic Data Analysis Techniques

Objectives

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Chapter 3: Analyzing Data with Microsoft Excel

Objectives

Your Turn

Your Turn

Your Turn

Putting It Together

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Installing the Analysis ToolPak

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Putting It Together

Your Turn

Chapter 4: Analyzing Data with PivotTable and PivotChart Reports

Objectives

Putting It Together

Putting It Together

Your Turn

Putting It Together

Your Turn

Your Turn

Chapter 5: Analyzing Data with Microsoft Access

Objectives

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Putting It Together

Your Turn

Your Turn

Your Turn

Putting It Together

Your Turn

Chapter 6: Analyzing Data with the Office Web Components

Objectives

Your Turn

Your Turn

our Turn

Putting It Together

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Your Turn

Chapter 7: Introducing Online Analytical Processing

Objectives

Chapter 8: Analyzing OLAP Data with Microsoft Excel

Objectives

Data Connection File Types

Your Turn

Your Turn

Chapter 9: Analyzing OLAP Data with Microsoft Data Analyzer

Objectives

Your Turn

Your Turn

Your Turn

Multidimensional Expressions

Your Turn

Your Turn

Chapter 10: Working with XML Data in Excel and Access

Objectives

Your Turn

Your Turn

Your Turn

Putting It Together

Chapter 11: Extending Office Data Analysis Features with Code

Objectives

Your Turn

Your Turn

Chapter 12: Maintaining Data Reporting and Analysis Systems

Objectives