Books & Videos

Table of Contents

  1. Chapter 1 Excel and Statistics

    1. Array Formulas

    2. Addressing Cells Indirectly

    3. Statistical Functions

  2. Chapter 2 Pivot Tables and Problem Solving

    1. Pivot Table Basics

    2. Changing the Data

    3. Pivot Table Options

  3. Chapter 3 Workload Forecasting

    1. The Procedure

    2. Building an Application

  4. Chapter 4 Modeling

    1. Regression

    2. Defining the Problem

    3. Refining Metrics

    4. Analysis

    5. Building the Model

    6. Analyzing the Results

    7. Testing Non-Linear Relationships

  5. Chapter 5 Measuring Quality

    1. Statistical Process Control

    2. Running the Application

    3. Application Design

    4. Customizing the Application

  6. Chapter 6 Monitoring Complex Systems

    1. The Application

    2. The Data

    3. Settings

    4. Workarea

    5. Macros

  7. Chapter 7 Queuing

    1. The Data

    2. The Application

    3. The Logic

  8. Chapter 8 Custom Queuing Presentation

    1. The Application

    2. The Data

    3. The Logic

    4. VBA

    5. Extending the Application

  9. Chapter 9 Optimizing

    1. Goal Seek

    2. The Solver

  10. Chapter 10 Importing Data

    1. Text Files

    2. Databases

    3. XML

  11. Chapter 11 The Trouble with Data

    1. Numbers

    2. Dates

    3. Reports

    4. Equivalence

  12. Chapter 12 Effective Display Techniques

    1. Respect the Information and the Audience

    2. Large Worksheets

    3. Charts

    4. Pictures and Other Objects

    5. Complexity

    6. Repeated Elements

    7. Information Density

    8. Emphasis and Focus

  1. Colophon