Table of Contents

Analyzing Business Data with Excel
By Gerald Knight
...............................................
Publisher: O'Reilly
Pub Date: January 2006
ISBN: 0-596-10073-6
Pages: 262

Table of Contents  | Index

		Copyright
		Preface
			Who Should Read This Book
			What's in This Book
			How to Use This Book Effectively
			Sample Code
			Using Code Examples
			We'd Like Your Feedback!
			Safari® Enabled
			Acknowledgments
		Chapter 1.  Excel and Statistics
			Section 1.1.  Array Formulas
			Section 1.2.  Addressing Cells Indirectly
			Section 1.3.  Statistical Functions
		Chapter 2.  Pivot Tables and Problem Solving
			Section 2.1.  Pivot Table Basics
			Section 2.2.  Changing the Data
			Section 2.3.  Pivot Table Options
		Chapter 3.  Workload Forecasting
			Section 3.1.  The Procedure
			Section 3.2.  Building an Application
		Chapter 4.  Modeling
			Section 4.1.  Regression
			Section 4.2.  Defining the Problem
			Section 4.3.  Refining Metrics
			Section 4.4.  Analysis
			Section 4.5.  Building the Model
			Section 4.6.  Analyzing the Results
			Section 4.7.  Testing Non-Linear Relationships
		Chapter 5.  Measuring Quality
			Section 5.1.  Statistical Process Control
			Section 5.2.  Running the Application
			Section 5.3.  Application Design
			Section 5.4.  Customizing the Application
		Chapter 6.  Monitoring Complex Systems
			Section 6.1.  The Application
			Section 6.2.  The Data
			Section 6.3.  Settings
			Section 6.4.  Workarea
			Section 6.5.  Macros
		Chapter 7.  Queuing
			Section 7.1.  The Data
			Section 7.2.  The Application
			Section 7.3.  The Logic
		Chapter 8.  Custom Queuing Presentation
			Section 8.1.  The Application
			Section 8.2.  The Data
			Section 8.3.  The Logic
			Section 8.4.  VBA
			Section 8.5.  Extending the Application
		Chapter 9.  Optimizing
			Section 9.1.  Goal Seek
			Section 9.2.  The Solver
		Chapter 10.  Importing Data
			Section 10.1.  Text Files
			Section 10.2.  Databases
			Section 10.3.  XML
		Chapter 11.  The Trouble with Data
			Section 11.1.  Numbers
			Section 11.2.  Dates
			Section 11.3.  Reports
			Section 11.4.  Equivalence
		Chapter 12.  Effective Display Techniques
			Section 12.1.  Respect the Information and the Audience
			Section 12.2.  Large Worksheets
			Section 12.3.  Charts
			Section 12.4.  Pictures and Other Objects
			Section 12.5.  Complexity
			Section 12.6.  Repeated Elements
			Section 12.7.  Information Density
			Section 12.8.  Emphasis and Focus
		About the Author
		Colophon
		Index