Microsoft Excel 2013: Data Analysis and Business Modeling - Brossura

Winston, Wayne L.

Brossura

ISBN 10: 0735669139 ISBN 13: 9780735669130

Casa editrice: Microsoft Pr, 2014

Riassunto

Master the business modeling and analytic techniques with Microsoft Excel 2013, and help transform your data into bottom-line results. With this hands-on, scenario-focused guide from Excel expert and bestselling author Wayne Winston, you’ll learn how to use the new Data Model and Relationships features for integrating data from multiple tables, effectively building a relational data source inside an Excel workbook.

Gain the skills to solve real-world business problems with Excel 2013

• Model investment risks and returns
• Analyze your sales team’s effectiveness
• Create best, worst, and most-likely case scenarios
• Compare lease vs. buy, and calculate loan terms
• See how price, advertising, and seasonality affect sales
• Manage inventory with precision
• Quantify the value of customer loyalty
• Calculate your break-even number and ROI
• Maximize scheduling efficiency

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:

Introduction; What’s new in this edition; What you should know before reading this book; How to use this book; Using the companion content; Acknowledgments; Support & feedback; Chapter 1: Range names; 1.1 How can I create named ranges?; 1.2 Answers to this chapter’s questions; 1.3 Remarks; 1.4 Problems; Chapter 2: Lookup functions; 2.1 Syntax of the lookup functions; 2.2 Answers to this chapter’s questions; 2.3 Problems; Chapter 3: INDEX function; 3.1 Syntax of the INDEX function; 3.2 Answers to this chapter’s questions; 3.3 Problems; Chapter 4: MATCH function; 4.1 Answers to this chapter’s questions; 4.2 Problems; Chapter 5: Text functions; 5.1 Text function syntax; 5.2 Answers to this chapter’s questions; 5.3 Problems; Chapter 6: Dates and date functions; 6.1 Answers to this chapter’s questions; 6.2 Problems; Chapter 7: Evaluating investments by using net present value criteria; 7.1 Answers to this chapter’s questions; 7.2 Problems; Chapter 8: Internal rate of return; 8.1 Answers to this chapter’s questions; 8.2 Problems; Chapter 9: More Excel financial functions; 9.1 Answers to this chapter’s questions; 9.2 CUMPRINC and CUMIPMT functions; 9.3 Problems; Chapter 10: Circular references; 10.1 Answers to this chapter’s questions; 10.2 Problems; Chapter 11: IF statements; 11.1 Answers to this chapter’s questions; 11.2 Problems; Chapter 12: Time and time functions; 12.1 Answers to this chapter’s questions; 12.2 Problems; Chapter 13: The Paste Special command; 13.1 Answers to this chapter’s questions; 13.2 Problems; Chapter 14: Three-dimensional formulas; 14.1 Answer to this chapter’s question; 14.2 Problem; Chapter 15: The Auditing tool and Inquire add-in; 15.1 Answers to this chapter’s questions; 15.2 Problems; Chapter 16: Sensitivity analysis with data tables; 16.1 Answers to this chapter’s questions; 16.2 Problems; Chapter 17: The Goal Seek command; 17.1 Answers to this chapter’s questions; 17.2 Problems; Chapter 18: Using the Scenario Manager for sensitivity analysis; 18.1 Answer to this chapter’s question; 18.2 Remarks; 18.3 Problems; Chapter 19: The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions; 19.1 Answers to this chapter’s questions; 19.2 Remarks; 19.3 Problems; Chapter 20: The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions; 20.1 Answers to this chapter’s questions; 20.2 Problems; Chapter 21: The OFFSET function; 21.1 Answers to this chapter’s questions; 21.2 Remarks; 21.3 Problems; Chapter 22: The INDIRECT function; 22.1 Answers to this chapter’s questions; 22.2 Problems; Chapter 23: Conditional formatting; 23.1 Answers to this chapter’s questions; 23.2 Problems; Chapter 24: Sorting in Excel; 24.1 Answers to this chapter’s questions; 24.2 Problems; Chapter 25: Tables; 25.1 Answers to this chapter’s questions; 25.2 Problems; Chapter 26: Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes; 26.1 Answers to this chapter’s questions; 26.2 Problems; Chapter 27: The analytics revolution; 27.1 Answers to this chapter’s questions; Chapter 28: Introducing optimization with Excel Solver; 28.1 Problems; Chapter 29: Using Solver to determine the optimal product mix; 29.1 Answers to this chapter’s questions; 29.2 Problems; Chapter 30: Using Solver to schedule your workforce; 30.1 Answer to this chapter’s question; 30.2 Problems; Chapter 31: Using Solver to solve transportation or distribution problems; 31.1 Answer to this chapter’s question; 31.2 Problems; Chapter 32: Using Solver for capital budgeting; 32.1 Answer to this chapter’s question; 32.2 Problems; Chapter 33: Using Solver for financial planning; 33.1 Answers to this chapter’s questions; 33.2 Problems; Chapter 34: Using Solver to rate sports teams; 34.1 Answer to this chapter’s question; 34.2 Problems; Chapter 35: Warehouse location and the GRG Multistart and Evolutionary Solver engines; 35.1 Understanding the GRG Multistart and Evolutionary Solver engines; 35.2 Answers to this chapter’s questions; 35.3 Problems; Chapter 36: Penalties and the Evolutionary Solver; 36.1 Answers to this chapter’s questions; 36.2 Using conditional formatting to highlight each employee’s ratings; 36.3 Problems; Chapter 37: The traveling salesperson problem; 37.1 Answers to this chapter’s questions; 37.2 Problems; Chapter 38: Importing data from a text file or document; 38.1 Answer to this chapter’s question; 38.2 Problems; Chapter 39: Importing data from the Internet; 39.1 Answer to this chapter’s question; 39.2 Problems; Chapter 40: Validating data; 40.1 Answers to this chapter’s questions; 40.2 Remarks; 40.3 Problems; Chapter 41: Summarizing data by using histograms; 41.1 Answers to this chapter’s questions; 41.2 Problems; Chapter 42: Summarizing data by using descriptive statistics; 42.1 Answers to this chapter’s questions; 42.2 Problems; Chapter 43: Using PivotTables and slicers to describe data; 43.1 Answers to this chapter’s questions; 43.2 Problems; Chapter 44: The Data Model; 44.1 Answers to this chapter’s questions; 44.2 Problems; Chapter 45: PowerPivot; 45.1 Answers to this chapter’s questions; 45.2 Problems; Chapter 46: Power View; 46.1 Answers to this chapter’s questions; 46.2 Problems; Chapter 47: Sparklines; 47.1 Answers to this chapter’s questions; 47.2 Problems; Chapter 48: Summarizing data with database statistical functions; 48.1 Answers to this chapter’s questions; 48.2 Problems; Chapter 49: Filtering data and removing duplicates; 49.1 Answers to this chapter’s questions; 49.2 Problems; Chapter 50: Consolidating data; 50.1 Answer to this chapter’s question; 50.2 Problems; Chapter 51: Creating subtotals; 51.1 Answers to this chapter’s questions; 51.2 Problems; Chapter 52: Charting tricks; 52.1 Answers to this chapter’s questions; 52.2 Problems; Chapter 53: Estimating straight-line relationships; 53.1 Answers to this chapter’s questions; 53.2 Problems; Chapter 54: Modeling exponential growth; 54.1 Answer to this chapter’s question; 54.2 Problems; Chapter 55: The power curve; 55.1 Answer to this chapter’s question; 55.2 Problems; Chapter 56: Using correlations to summarize relationships; 56.1 Answer to this chapter’s question; 56.2 Problems; Chapter 57: Introduction to multiple regression; 57.1 Answers to this chapter’s questions; Chapter 58: Incorporating qualitative factors into multiple regression; 58.1 Answers to this chapter’s questions; Chapter 59: Modeling nonlinearities and interactions; 59.1 Answers to this chapter’s questions; 59.2 Problems for Chapters 57 and 58; Chapter 60: Analysis of variance: one-way ANOVA; 60.1 Answers to this chapter’s questions; 60.2 Problems; Chapter 61: Randomized blocks and two-way ANOVA; 61.1 Answers to this chapter’s questions; 61.2 Problems; Chapter 62: Using moving averages to understand time series; 62.1 Answer to this chapter’s question; 62.2 Problem; Chapter 63: Winters’s method; 63.1 Time series characteristics; 63.2 Parameter definitions; 63.3 Initializing Winters’s method; 63.4 Estimating the smoothing constants; 63.5 Remarks; 63.6 Problems; Chapter 64: Ratio-to-moving-average forecast method; 64.1 Answers to this chapter’s questions; 64.2 Problem; Chapter 65: Forecasting in the presence of special events; 65.1 Answers to this chapter’s questions; 65.2 Problems; Chapter 66: An introduction to random variables; 66.1 Answers to this chapter’s questions; 66.2 Problems; Chapter 67: The binomial, hypergeometric, and negative binomial random variables; 67.1 Answers to this chapter’s questions; 67.2 Problems; Chapter 68: The Poisson and exponential random variable; 68.1 Answers to this chapter’s questions; 68.2 Problems; Chapter 69: The normal random variable; 69.1 Answers to this chapter’s questions; 69.2 Problems; Chapter 70: Weibull and beta distributions: modeling machine life and duration of a project; 70.1 Answers to this chapter’s questions; 70.2 Problems; Chapter 71: Making probability statements from forecasts; 71.1 Answers to this chapter’s questions; 71.2 Problems; Chapter 72: Using the lognormal random variable to model stock prices; 72.1 Answers to this chapter’s questions; 72.2 Remarks; 72.3 Problems; Chapter 73: Introduction to Monte Carlo simulation; 73.1 Answers to this chapter’s questions; 73.2 Problems; Chapter 74: Calculating an optimal bid; 74.1 Answers to this chapter’s questions; 74.2 Problems; Chapter 75: Simulating stock prices and asset allocation modeling; 75.1 Answers to this chapter’s questions; 75.2 Problems; Chapter 76: Fun and games: simulating gambling and sporting event probabilities; 76.1 Answers to this chapter’s questions; 76.2 Problems; Chapter 77: Using resampling to analyze data; 77.1 Answer to this chapter’s question; 77.2 Problems; Chapter 78: Pricing stock options; 78.1 Answers to this chapter’s questions; 78.2 Problems; Chapter 79: Determining customer value; 79.1 Answers to this chapter’s questions; 79.2 Problems; Chapter 80: The economic order quantity inventory model; 80.1 Answers to this chapter’s questions; 80.2 Problems; Chapter 81: Inventory modeling with uncertain demand; 81.1 Answers to this chapter’s questions; 81.2 Problems; Chapter 82: Queuing theory: the mathematics of waiting in line; 82.1 Answers to this chapter’s questions; 82.2 Problems; Chapter 83: Estimating a demand curve; 83.1 Answers to this chapter’s questions; 83.2 Problems; Chapter 84: Pricing products by using tie-ins; 84.1 Answer to this chapter’s question; 84.2 Problems; Chapter 85: Pricing products by using subjectively determined demand; 85.1 Answers to this chapter’s questions; 85.2 Problems; Chapter 86: Nonlinear pricing; 86.1 Answers to this chapter’s questions; 86.2 Problems; Chapter 87: Array formulas and functions; 87.1 Ans...

Su questa edizione

• Editore: Microsoft Pr
• Data di pubblicazione: 2014
• ISBN 10: 0735669139
• ISBN 13: 9780735669130
• Rilegatura: Copertina flessibile
• Numero di pagine: 859