Create bookmark
Microsoft® Excel Data Analysis and Business Modeling
Notes
Please login to add notes
- + Cover
- Table of Contents
- Introduction
- Chapter 1 Range Names
- Chapter 2 Natural Language Range Names
- Chapter 3 Lookup Functions
- Chapter 4 The INDEX Function
- Chapter 5 The MATCH Function
- Chapter 6 Text Functions
- Chapter 7 Dates and Date Functions
- Chapter 8 Evaluating Investments with Net Present Value Criteria
- Chapter 9 Internal Rate of Return
- Chapter 10 Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT Functions
- Chapter 11 Circular References
- Chapter 12 IF Statements
- Chapter 13 The Paste Special Command
- Chapter 14 The Auditing Tool
- Chapter 15 Sensitivity Analysis with Data Tables
- Chapter 16 The Goal Seek Command
- Chapter 17 Using the Scenario Manager for Sensitivity Analysis
- Chapter 18 Creating and Using Spinners for Sensitivity Analysis
- Chapter 19 The COUNTIF, COUNT, COUNTA, and COUNTBLANK Functions
- Chapter 20 The SUMIF Function
- Chapter 21 The OFFSET Function
- Chapter 22 The INDIRECT Function
- Chapter 23 Conditional Formatting
- Chapter 24 An Introduction to Optimization with the Excel Solver
- Chapter 25 Using Solver to Determine the Optimal Product Mix
- Chapter 26 Using Solver to Solve Transportation or Distribution Problems
- Chapter 27 Using Solver to Schedule Your Workforce
- Chapter 28 Using Solver for Capital Budgeting
- Chapter 29 Using Solver for Financial Planning
- Chapter 30 Using Solver to Rate Sports Teams
- Chapter 31 Importing Text or Microsoft Word Data into Excel
- Chapter 32 Importing Data from the Web into Excel
- Chapter 33 Validating Data
- Chapter 34 Summarizing Data with Histograms
- Chapter 35 Summarizing Data with Descriptive Statistics
- Chapter 36 Using PivotTables to Describe Data
- Chapter 37 Summarizing Data with Database Statistical Functions
- Chapter 38 Filtering Data
- Chapter 39 Consolidating Data
- Chapter 40 Creating Subtotals
- Chapter 41 Estimating Straight Line Relationships
- Chapter 42 Modeling Exponential Growth
- Chapter 43 The Power Curve
- Chapter 44 Using Correlations to Summarize Relationships
- Chapter 45 Introduction to Multiple Regression
- Chapter 46 Incorporating Qualitative Factors into Multiple Regression
- Chapter 47 Modeling Nonlinearities and Interactions
- Chapter 48 Analysis of Variance: One-Way ANOVA
- Chapter 49 Randomized Blocks and Two-Way ANOVA
- Chapter 50 Using Moving Averages to Understand Time Series
- Chapter 51 Forecasting with Moving Averages
- Chapter 52 Forecasting in the Presence of Special Events
- Chapter 53 An Introduction to Random Variables
- Chapter 54 The Binomial and Hypergeometric Random Variables
- Chapter 55 The Poisson and Exponential Random Variable
- Chapter 56 The Normal Random Variable
- Chapter 57 Weibull and Beta Distributions: Modeling Machine Life and Duration of a Project
- Chapter 58 Introduction to Monte Carlo Simulation
- Chapter 59 Calculating an Optimal Bid
- Chapter 60 Simulating Stock Prices and Asset Allocation Modeling
- Chapter 61 Fun and Games: Simulating Gambling and Sporting Event Probabilities
- Chapter 62 Using Resampling to Analyze Data
- Chapter 63 Pricing Stock Options
- Chapter 64 Determining Customer Value
- Chapter 65 The Economic Order Quantity Inventory Model
- Chapter 66 Determining the Reorder Point: How Low Should I Let My Inventory Level Go Before I Reorder?
- Chapter 67 Queuing Theory: The Mathematics of Waiting in Line
- Chapter 68 Estimating a Demand Curve
- Chapter 69 Pricing Products with Tie-Ins
- Chapter 70 Pricing Products Using Subjectively Determined Demand
- Chapter 71 Nonlinear Pricing
- Chapter 72 Array Formulas and Functions
- Chapter 73 Picking Your Fantasy Football Team
- About the Author
Master the techniques that business analysts at leading companies use to transform data into bottom-line results. For more than a decade, well-known consultant and business professor Wayne Winston has been teaching corporate clients and MBA students the most effective ways to use Microsoft Excel for data analysis, modeling, and decision making. Now this award-winning educator shares the best of his classroom experience in this practical, business- focused guide. Each chapter advances your data analysis and modeling expertise using real-world examples and learn-by-doing exercises. You also get all the book’s problem-and-solution files on CD—for all the practice you need to solve complex problems and work smarter with Excel.
Learn how to solve real business problems with Excel!
Create best, worst, and most-likely scenarios for sales
Calculate how long it would take to recoup a project’s startup costs
Plan personal finances, such as computing loan terms or saving for retirement
Estimate a product’s demand curve
Simulate stock performance over a year
Determine which product mix will yield the greatest profits
Interpret the effects of price and advertising on sales
Assign a dollar value to customer loyalty
Manage inventory and order quantities with precision
Create customer service queues with short wait times
Estimate the probabilities of equipment failure
Model business uncertainties
Get new perspectives on data with PivotTable dynamic views
Help predict quarterly revenue, outcomes of sporting events, presidential elections, and more!
On the CD:
Practice files for all the book’s exercises
Solutions for problem sets
Fully searchable eBook
A Note Regarding the CD or DVD
The print version of this book ships with a CD or DVD. For those customers purchasing one of the digital formats in which this book is available, we are pleased to offer the CD/DVD content as a free download via O'Reilly Media's Digital Distribution services. To download this content, please visit O'Reilly's web site, search for the title of this book to find its catalog page, and click on the link below the cover image (Examples, Companion Content, or Practice Files). Note that while we provide as much of the media content as we are able via free download, we are sometimes limited by licensing restrictions. Please direct any questions or concerns to booktech@oreilly.com.
Test the closed alpha on paperc.com
Book Details
Authors
Categories
Computers > Desktop Applications > Spreadsheets
Publishers
Publication year : 2009
License: All rights reserved ©
Times read: 67

