This book starts with some necessary general tools and then moves into more specific problem areas.
Chapter 1, Excel and Statistics
Covers averages, trends, correlation, distributions, and array formulas.
Chapter 2, Pivot Tables and Problem Solving
Examines pivot table basics and ways to modify data to make it work better with pivot tables.
Chapter 3, Workload Forecasting
Covers the application development process, worksheet organization, and forecasting techniques. This chapter includes an application that forecasts a typical workload.
Chapter 4, Modeling
Explores regression, problem definition, analysis, model construction, and interpretation of results.
Chapter 5, Measuring Quality
Works with statistical process control, X and Y charts, and application design. This chapter includes an application that uses statistical process control to measure quality in an operation.
Chapter 6, Monitoring Complex Systems
Examines data requirements, statistical techniques and logic, application design, and organization. This chapter includes an application that uses regression to monitor the relationship between metrics in a complex business process.
Chapter 7, Queuing
Applies formatting, VBA, and logic in an application that measures worker performance in a queuing operation.
Chapter 8, Custom Queuing Presentation
Continues the discussion of queuing with another application focusing on the status of the queue.
Chapter 9, Optimizing
Explains how to use Goal Seek and Solver for various kinds of problems.
Chapter 10, Importing Data
Covers importing from text files, databases, and XML.
Chapter 11, The Trouble with Data
Examines common problems with dates, numeric information, dealing with data in report form, and equivalence problems.
Chapter 12, Effective Display Techniques
Covers display design, color combination, dealing with complexity, and visual considerations.