---

Analyzing Business Data with Excel

ISBN: 0596100736
EAN: 2147483647

Year: 2006
Pages: 101

Authors: Gerald Knight

BUY ON AMAZON

• Analyzing Business Data with Excel
• Table of Contents
• 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
• SYMBOL
• A
• B
• C
• D
• E
• F
• G
• H
• I
• J
• L
• M
• N
• O
• P
• Q
• R
• S
• T
• V
• W
• X
• Z