Analyzing Business Data with Excel - Helion

ebook

Autor: Gerald Knight
ISBN: 978-05-965-5346-3
stron: 266, Format: ebook
Data wydania: 2006-01-03
Księgarnia: Helion

Cena książki: 118,15 zł (poprzednio: 137,38 zł)
Oszczędzasz: 14% (-19,23 zł)

Osoby, które kupiły tę książkę, wybierały także »

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.

Osoby które kupowały "Analyzing Business Data with Excel", wybierały także:

Windows Media Center. Domowe centrum rozrywki 66,67 zł, (8,00 zł -88%)
Ruby on Rails. Ćwiczenia 18,75 zł, (3,00 zł -84%)
DevOps w praktyce. Kurs video. Jenkins, Ansible, Terraform i Docker 190,00 zł, (39,90 zł -79%)
Przywództwo w świecie VUCA. Jak być skutecznym liderem w niepewnym środowisku 58,64 zł, (12,90 zł -78%)
Scrum. O zwinnym zarządzaniu projektami. Wydanie II rozszerzone 58,64 zł, (12,90 zł -78%)

Spis treści

Analyzing Business Data with Excel eBook -- spis treści

Analyzing Business Data with Excel
A Note Regarding Supplemental Files
Preface
- Who Should Read This Book
- Whats in This Book
- How to Use This Book Effectively
  - Typographical Conventions
- Sample Code
- Using Code Examples
- We'd Like Your Feedback!
- Safari Enabled
- Acknowledgments
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
11. The Trouble with Data
- 11.1. Numbers
- 11.2. Dates
- 11.3. Reports
- 11.4. Equivalence
12. Effective Display Techniques
- 12.1. Respect the Information and the Audience
- 12.2. Large Worksheets
- 12.3. Charts
- 12.4. Pictures and Other Objects
- 12.5. Complexity
- 12.6. Repeated Elements
- 12.7. Information Density
  - 12.7.1. Support and Grouping
- 12.8. Emphasis and Focus
  - 12.8.1. Metaphor
  - 12.8.2. Fonts
  - 12.8.3. Colors
  - 12.8.4. Background Interaction
Index
About the Author
Colophon
Copyright