Analyzing Business Data with Excel 1st edition by Gerald Knight 9780596553463 0596553463

Analyzing Business Data with Excel 1st edition by Gerald Knight  – Ebook PDF Instant Download/Delivery.9780596553463, 0596553463
Full download Analyzing Business Data with Excel 1st edition  after payment

Product details:

ISBN 10: 0596553463
ISBN 13: 9780596553463 
Author: Gerald Knight

As one of the most widely used desktop applications ever created, Excel is familiar to just about everyone with a computer and a keyboard. Yet most of us don’t know the full extent of what Excel can do, mostly because of its recent growth in power, versatility, and complexity. The truth is that there are many ways Excel can help make your job easier-beyond calculating sums and averages in a standard spreadsheet. Analyzing Business Data with Excel shows you how to solve real-world business problems by taking Excel’s data analysis features to the max. Rather than focusing on individual Excel functions and features, the book keys directly on the needs of business users. Most of the chapters start with a business problem or question, and then show you how to create pointed spreadsheets that address common data analysis issues. Aimed primarily at experienced Excel users, the book doesn’t spend much time on the basics. After introducing some necessary general tools, it quickly moves into more specific problem areas, such as the following: Statistics Pivot tables Workload forecasting Modeling Measuring quality Monitoring complex systems Queuing Optimizing Importing data If you feel as though you’re getting shortchanged by your overall application of Excel, Analyzing Business Data with Excel is just the antidote. It addresses the growing Excel data analysis market head on. Accountants, managers, analysts, engineers, and supervisors-one and all-will learn how to turn Excel functionality into actual solutions for the business problems that confront them.

Analyzing Business Data with Excel 1st Table of contents:

1. Excel and Statistics

1.1. Array Formulas

1.2. Addressing Cells Indirectly

1.3. Statistical Functions

1.3.1. The Average

1.3.1.1. AVERAGEA

1.3.1.2. DAVERAGE

1.3.1.3. Trimmed average

1.3.1.4. Moving average

1.3.2. Changes in the Average

1.3.2.1. Growth

1.3.3. Distributions

1.3.3.1. Normal distributions

1.3.3.2. Exponential distributions

1.3.3.3. Gamma distribution

1.3.3.4. Binomial distribution

1.3.4. Correlation

2. Pivot Tables and Problem Solving

2.1. Pivot Table Basics

2.1.1. Populating the Table

2.1.2. Sorting and Filtering

2.1.3. Multiple Data Items

2.1.4. Working with Rows and Columns

2.1.5. Adding a PivotChart

2.1.6. Multiple Layers and Pages

2.1.7. Drilling Down

2.2. Changing the Data

2.2.1. Categorical Information

2.2.2. Scalar Information

2.3. Pivot Table Options

3. Workload Forecasting

3.1. The Procedure

3.1.1. Data

3.1.2. Predictions

3.1.2.1. Find the lag

3.1.2.2. Find the average

3.1.2.3. Adjust for the trend

3.1.3. Determine the Confidence Interval

3.1.4. Manage Anomalies

3.2. Building an Application

3.2.1. Design

3.2.2. List the Requirements

3.2.3. Consider the Source of Data

3.2.4. Presentation

3.2.5. Conventions and Names

3.2.6. Named Values and Ranges on Settings

3.2.7. The Named Values on the Workarea Sheet

3.2.8. Named Ranges on Workarea

3.2.9. Other Important Links on Workarea

3.2.10. Linking to the Data

3.2.11. Visual Basic

3.2.12. Formatting

3.2.13. Running the Application

3.2.14. Customizing the Application

4. Modeling

4.1. Regression

4.2. Defining the Problem

4.3. Refining Metrics

4.4. Analysis

4.5. Building the Model

4.6. Analyzing the Results

4.7. Testing Non-Linear Relationships

5. Measuring Quality

5.1. Statistical Process Control

5.1.1. Choosing Metrics

5.1.2. X and S Charts

5.2. Running the Application

5.3. Application Design

5.3.1. The Data Sheet

5.3.2. The Workarea Sheet

5.3.3. The Controls on the Display Sheet

5.3.4. Linking the Workarea Sheet to the Data Sheet

5.3.4.1. Calculations on the Workarea Sheet

5.3.5. The Display Sheet

5.3.5.1. The scroll

5.3.5.2. Other parts of the Display sheet

5.4. Customizing the Application

5.4.1. Changing the Display Sheet

5.4.2. Adding Logic

5.4.3. Adding a Macro

6. Monitoring Complex Systems

6.1. The Application

6.2. The Data

6.3. Settings

6.3.1. Independent Columns

6.3.2. The Alternate

6.3.3. The Lag

6.3.4. The Out of Limits Message

6.3.5. The Current Column

6.3.6. The Current Row

6.3.7. The Sensitivity

6.4. Workarea

6.4.1. LastRow

6.4.2. Columns Used

6.4.3. LastColumn

6.4.4. StartRow

6.4.5. IsOut

6.4.6. The Data Area

6.4.7. The Regression Area

6.4.8. The Combo Box Data Area

6.4.9. The Main Display Area

6.5. Macros

7. Queuing

7.1. The Data

7.2. The Application

7.3. The Logic

7.3.1. Using a Tag Sort on Linked Information

7.3.2. Invisible Rectangles

7.3.3. The Agent Detail Area

7.3.4. The Chart Area

7.3.5. The Timeline

7.3.6. Navigation

8. Custom Queuing Presentation

8.1. The Application

8.2. The Data

8.3. The Logic

8.4. VBA

8.5. Extending the Application

9. Optimizing

9.1. Goal Seek

9.1.1. Setting a Price

9.1.2. A Quadratic Equation

9.1.3. A Matrix Problem

9.1.4. Using Goal Seek in a Macro

9.2. The Solver

9.2.1. Finding Two Values at Once

9.2.2. Regression with the Solver

9.2.3. A Problem with Constraints

9.2.4. Zero/One Problem

9.2.5. Running the Solver with a Macro

9.2.6. Common Problems with the Solver

9.2.7. Applications

10. Importing Data

10.1. Text Files

10.1.1. Fixed Length Files

10.1.2. Delimited Files

10.2. Databases

10.2.1. Linking Tables

10.3. XML

People also search for Analyzing Business Data with Excel 1st :

    
excel module 10 analyzing data with business intelligence tools
    
using excel to analyse data
    
can excel analyze data
    
using excel for business analysis