"Master business modeling and analysis techniques with Microsoft Excel and transform data into bottom-line results. Award-winning educator Wayne Winston's hands-on, scenario-focused guide helps you use today's Excel to ask the right questions and get accurate, actionable answers. More extensively updated than any previous edition, new coverage ranges from one-click data analysis to STOCKHISTORY, dynamic arrays to Power Query, and includes six new chapters. Practice with over 900 problems, many based on real challenges faced by working analysts." -- Provided by publisher

"Microsoft Press"--Page [4] of cover "Published with the authorization of Microsoft Corporation by Pearson Education, Inc., Includes index

Chapter 1 Basic worksheet modeling -- Chapter 2 Range names -- Chapter 3 Lookup functions -- Chapter 4 The INDEX function -- Chapter 5 The MATCH function -- Chapter 6 Text functions and Flash Fill -- Chapter 7 Dates and date functions -- Chapter 8 The net present value functions: NPV and XNPV -- Chapter 9 The internal rate of return: IRR, XIRR, and MIRR functions -- Chapter 10 More Excel financial functions -- Chapter 11 Circular references -- Chapter 12 IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functions -- Chapter 13 Time and time functions -- Chapter 14 The Paste Special command -- Chapter 15 Three-dimensional formulas and hyperlinks -- Chapter 16 The auditing tool and the Inquire add-in -- Chapter 17 Sensitivity analysis with data tables -- Chapter 18 The Goal Seek command -- Chapter 19 Using the Scenario Manager for sensitivity analysis -- Chapter 20 The Countif, Countifs, Count, Counta, and Countblank Functions -- Chapter 21 The Sumif, Averageif, Sumifs. Averageifs, Maxifs, and Minifs Functions -- Chapter 22 The Offset Function -- Chapter 23 The Indirect Function -- Chapter 24 Conditional Formatting -- Chapter 25 Excel tables and table slicers -- Chapter 26 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxes -- Chapter 27 Importing data from a text file or document -- Chapter 28 The Power Query Editor -- Chapter 29 Excel's new data types -- Chapter 30 Summarizing data with histograms and Pareto charts -- Chapter 31 Summarizing data with descriptive statistics -- Chapter 32 Sorting in Excel -- Chapter 33 Filtering data and removing duplicates -- Chapter 34 Summarizing data with database statistical functions -- Chapter 35 Array formulas and functions -- Chapter 36 Excel's new dynamic array functions -- Chapter 37 Validating data -- Chapter 38 Using PivotTables and slicers to describe data -- Chapter 39 The Data Model -- Chapter 40 Power Pivot -- Chapter 41 Consolidating data -- Chapter 42 Creating subtotals -- Chapter 43 Basic charting -- Chapter 44 Advanced charting -- Chapter 45 Filled and 3D Maps -- Chapter 46 Sparklines -- Chapter 47 Estimating straight-line relationships -- Chapter 48 Modeling exponential growth -- Chapter 49 The power curve -- Chapter 50 Using correlations to summarize relationships -- Chapter 51 Introduction to multiple regression -- Chapter 52 Incorporating qualitative factors into multiple regression -- Chapter 53 Modeling nonlinearities and interactions -- Chapter 54 Analysis of variance: One-way ANOVA -- Chapter 55 Randomized blocks and two-way ANOVA -- Chapter 56 Using moving averages to understand time series -- Chapter 57 Ratio-to-moving-average forecast method -- Chapter 58 An introduction to probability -- Chapter 59 An introduction to random variables -- Chapter 60 The binomial, hypergeometric, and negative binomial random variables -- Chapter 61 The Poisson and exponential random variable -- Chapter 62 The normal random variable and Z-scores -- Chapter 63 Making probability statements from forecasts -- Chapter 64 Using the lognormal random variable to model stock prices -- Chapter 65 Importing past stock prices, exchange rates, and cryptocurrency prices with the STOCKHISTORY function -- Chapter 66 An introduction to optimization with Excel Solver -- Chapter 67 Using Solver to determine the optimal product mix -- Chapter 68 Using Solver to schedule your workforce -- Chapter 69 Using Solver to solve transportation or distribution problems -- Chapter 70 Using Solver for capital budgeting -- Chapter 71 Using Solver for financial planning -- Chapter 72 Using Solver to rate sports teams -- Chapter 73 The Winters method and the Forecast Sheet tool -- Chapter 74 Forecasting in the presence of special events -- Chapter 75 Warehouse location and the GRG Multistart and Evolutionary Solver engines -- Chapter 76 Penalties and the Evolutionary Solver -- Chapter 77 The traveling salesperson problem -- Chapter 78 Weibull and beta distributions: Modeling machine life and duration of a project -- Chapter 79 Introduction to Monte Carlo simulation -- Chapter 80 Calculating an optimal bid -- Chapter 81 Simulating stock prices and asset-allocation modeling -- Chapter 82 Fun and games: Simulating gambling and sporting-event probabilities -- Chapter 83 Using resampling to analyze data -- Chapter 84 Pricing stock options -- Chapter 85 Determining customer value -- Chapter 86 The economic order quantity inventory model -- Chapter 87 Inventory modeling with uncertain demand -- Chapter 88 Queuing theory: The mathematics of waiting in line -- Chapter 89 Estimating a demand curve -- Chapter 90 Pricing products by using tie-ins -- Chapter 91 Pricing products by using subjectively determined demand -- Chapter 92 Nonlinear pricing -- Chapter 93 Use Analyze Data to find patterns in your data -- Chapter 94 Recording macros -- Chapter 95 The LET and LAMBDA functions and the LAMBDA helper functions -- Chapter 96 Advanced sensitivity analysis