Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365)

CHAPTER 1 Basic worksheet modelingCHAPTER 2 Range namesCHAPTER 3 Lookup functionsCHAPTER 4 The INDEX functionCHAPTER 5 The MATCH functionCHAPTER 6 Text functions and Flash FillCHAPTER 7 Dates and date functionsCHAPTER 8 The net present value functions: NPV and XNPVCHAPTER 9 The internal rate of return: IRR, XIRR, and MIRR functionsCHAPTER 10 More Excel financial functionsCHAPTER 11 Circular referencesCHAPTER 12 IF, IFERROR, IFS, CHOOSE, SWITCH, and the IS functionsCHAPTER 13 Time and time functionsCHAPTER 14 The Paste Special commandCHAPTER 15 Three-dimensional formulas and hyperlinksCHAPTER 16 The auditing tool and the Inquire add-inCHAPTER 17 Sensitivity analysis with data tablesCHAPTER 18 The Goal Seek commandCHAPTER 19 Using the Scenario Manager for sensitivity analysisCHAPTER 20 The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functionsCHAPTER 21 The SUMIF, AVERAGEIF, SUMIFS, AVERAGEIFS, MAXIFS, and MINIFS functionsCHAPTER 22 The OFFSET functionCHAPTER 23 The INDIRECT functionCHAPTER 24 Conditional formattingCHAPTER 25 Excel tables and table slicersCHAPTER 26 Spin buttons, scrollbars, option buttons, check boxes, combo boxes, and group list boxesCHAPTER 27 Importing data from a text file or documentCHAPTER 28 The Power Query EditorCHAPTER 29 Excel's new data typesCHAPTER 30 Summarizing data with histograms and Pareto chartsCHAPTER 31 Summarizing data with descriptive statisticsCHAPTER 32 Sorting in ExcelCHAPTER 33 Filtering data and removing duplicatesCHAPTER 34 Summarizing data with database statistical functionsCHAPTER 35 Array formulas and functionsCHAPTER 36 Excel's new dynamic array functionsCHAPTER 37 Validating dataCHAPTER 38 Using PivotTables and slicers to describe dataCHAPTER 39 The Data ModelCHAPTER 40 Power PivotCHAPTER 41 Consolidating dataCHAPTER 42 Creating subtotalsCHAPTER 43 Basic chartingCHAPTER 44 Advanced chartingCHAPTER 45 Filled and 3D MapsCHAPTER 46 SparklinesCHAPTER 47 Estimating straight-line relationshipsCHAPTER 48 Modeling exponential growthCHAPTER 49 The power curveCHAPTER 50 Using correlations to summarize relationshipsCHAPTER 51 Introduction to multiple regressionCHAPTER 52 Incorporating qualitative factors into multiple regressionCHAPTER 53 Modeling nonlinearities and interactionsCHAPTER 54 Analysis of variance: One-way ANOVACHAPTER 55 Randomized blocks and two-way ANOVACHAPTER 56 Using moving averages to understand time seriesCHAPTER 57 Ratio-to-moving-average forecast methodCHAPTER 58 An introduction to probabilityCHAPTER 59 An introduction to random variablesCHAPTER 60 The binomial, hypergeometric, and negative binomial random variablesCHAPTER 61 The Poisson and exponential random variableCHAPTER 62 The normal random variable and Z-scoresCHAPTER 63 Making probability statements from forecastsCHAPTER 64 Using the lognormal random variable to model stock pricesCHAPTER 65 Importing past stock prices, exchange rates, and cryptocurrency prices with the STOCKHISTORY functionCHAPTER 66 An introduction to optimization with Excel SolverCHAPTER 67 Using Solver to determine the optimal product mixCHAPTER 68 Using Solver to schedule your workforceCHAPTER 69 Using Solver to solve transportation or distribution problemsCHAPTER 70 Using Solver for capital budgetingCHAPTER 71 Using Solver for financial planningCHAPTER 72 Using Solver to rate sports teamsCHAPTER 73 The Winters method and the Forecast Sheet toolCHAPTER 74 Forecasting in the presence of special eventsCHAPTER 75 Warehouse location and the GRG Multistart and Evolutionary Solver enginesCHAPTER 76 Penalties and the Evolutionary SolverCHAPTER 77 The traveling salesperson problemCHAPTER 78 Weibull and beta distributions: Modeling machine life and duration of a projectCHAPTER 79 Introduction to Monte Carlo simulationCHAPTER 80 Calculating an optimal bidCHAPTER 81 Simulating stock prices and asset-allocation modelingCHAPTER 82 Fun and games: Simulating gambling and sporting-event probabilitiesCHAPTER 83 Using resampling to analyze dataCHAPTER 84 Pricing stock optionsCHAPTER 85 Determining customer valueCHAPTER 86 The economic order quantity inventory modelCHAPTER 87 Inventory modeling with uncertain demandCHAPTER 88 Queuing theory: The mathematics of waiting in lineCHAPTER 89 Estimating a demand curveCHAPTER 90 Pricing products by using tie-insCHAPTER 91 Pricing products by using subjectively determined demandCHAPTER 92 Nonlinear pricingCHAPTER 93 Use Analyze Data to find patterns in your dataCHAPTER 94 Recording macrosCHAPTER 95 The LET and LAMBDA functions and the LAMBDA helper functionsCHAPTER 96 Advanced sensitivity analysis