Microsoft Excel Data Analysis and Business Modeling - Brossura

Winston, Wayne L.

Brossura

ISBN 10: 0735619018 ISBN 13: 9780735619012

Casa editrice: Microsoft Pr, 2004

Riassunto

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

Su questo libro

L'autore

Wayne L. Winston is a professor of Decision Sciences at Indiana University's Kelley School of Business and has earned numerous MBA teaching awards. For 20+ years, he has taught clients at Fortune 500 companies how to use Excel to make smarter business decisions. Wayne and his business partner Jeff Sagarin developed the player-statistics tracking and rating system used by the Dallas Mavericks professional basketball team. He is also a two time Jeopardy! champion.

Contenuti

IntroductionChapter 1: Range NamesChapter 2: Natural Language Range NamesChapter 3: Lookup FunctionsChapter 4: The INDEX FunctionChapter 5: The MATCH FunctionChapter 6: Text FunctionsChapter 7: Dates and Date FunctionsChapter 8: Evaluating Investments with Net Present Value CriteriaChapter 9: Internal Rate of ReturnChapter 10: Functions for Personal Financial Decisions: The PV, FV, PMT, PPMT, and IPMT FunctionsChapter 11: Circular ReferencesChapter 12: IF StatementsChapter 13: The Paste Special CommandChapter 14: The Auditing ToolChapter 15: Sensitivity Analysis with Data TablesChapter 16: The Goal Seek CommandChapter 17: Using the Scenario Manager for Sensitivity AnalysisChapter 18: Creating and Using Spinners for Sensitivity AnalysisChapter 19: The COUNTIF, COUNT, COUNTA, and COUNTBLANK FunctionsChapter 20: The SUMIF FunctionChapter 21: The OFFSET FunctionChapter 22: The INDIRECT FunctionChapter 23: Conditional FormattingChapter 24: An Introduction to Optimization with the Excel SolverChapter 25: Using Solver to Determine the Optimal Product MixChapter 26: Using Solver to Solve Transportation or Distribution ProblemsChapter 27: Using Solver to Schedule Your WorkforceChapter 28: Using Solver for Capital BudgetingChapter 29: Using Solver for Financial PlanningChapter 30: Using Solver to Rate Sports TeamsChapter 31: Importing Text or Microsoft Word Data into ExcelChapter 32: Importing Data from the Web into ExcelChapter 33: Validating DataChapter 34: Summarizing Data with HistogramsChapter 35: Summarizing Data with Descriptive StatisticsChapter 36: Using PivotTables to Describe DataChapter 37: Summarizing Data with Database Statistical FunctionsChapter 38: Filtering DataChapter 39: Consolidating DataChapter 40: Creating SubtotalsChapter 41: Estimating Straight Line RelationshipsChapter 42: Modeling Exponential GrowthChapter 43: The Power CurveChapter 44: Using Correlations to Summarize RelationshipsChapter 45: Introduction to Multiple RegressionChapter 46: Incorporating Qualitative Factors into Multiple RegressionChapter 47: Modeling Nonlinearities and InteractionsChapter 48: Analysis of Variance: One-Way ANOVAChapter 49: Randomized Blocks and Two-Way ANOVAChapter 50: Using Moving Averages to Understand Time SeriesChapter 51: Forecasting with Moving AveragesChapter 52: Forecasting in the Presence of Special EventsChapter 53: An Introduction to Random VariablesChapter 54: The Binomial and Hypergeometric Random VariablesChapter 55: The Poisson and Exponential Random VariableChapter 56: The Normal Random VariableChapter 57: Weibull and Beta Distributions: Modeling Machine Life and Duration of a ProjectChapter 58: Introduction to Monte Carlo SimulationChapter 59: Calculating an Optimal BidChapter 60: Simulating Stock Prices and Asset Allocation ModelingChapter 61: Fun and Games: Simulating Gambling and Sporting Event ProbabilitiesChapter 62: Using Resampling to Analyze DataChapter 63: Pricing Stock OptionsChapter 64: Determining Customer ValueChapter 65: The Economic Order Quantity Inventory ModelChapter 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 LineChapter 68: Estimating a Demand CurveChapter 69: Pricing Products with Tie-InsChapter 70: Pricing Products Using Subjectively Determined DemandChapter 71: Nonlinear PricingChapter 72: Array Formulas and FunctionsChapter 73: Picking Your Fantasy Football TeamAppendix : About the Author

Dettagli dell?edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2004
• ISBN 10: 0735619018
• ISBN 13: 9780735619012
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero edizione: 1
• Numero di pagine: 608