Master business modeling and analysis techniques with Microsoft Excel 2016, and transform data into bottom-line results. Written by award-winning educator Wayne Winston, this hands on, scenario-focused guide helps you use Excel's newest tools to ask the right questions and get accurate, actionable answers. This edition adds 150+ new problems with solutions, plus a chapter of basic spreadsheet models to make sure you're fully up to speed. -- Provided by publisher.

Includes index.

Machine generated contents note: Answers to this chapter's questions -- Problems -- How can I create named ranges? -- Using the Name box to create a range name -- Creating named ranges by using the Create From Selection option -- Creating range names by using the Define Name option -- The Name Manager -- Answers to this chapter's questions -- Remarks -- Problems -- Syntax of the lookup functions -- VLOOKUP syntax -- HLOOKUP syntax -- Answers to this chapter's questions -- Problems -- Syntax of the INDEX function -- Answers to this chapter's questions -- Problems -- Syntax of the MATCH function -- Answers to this chapter's questions -- Problems -- Text function syntax -- The LEFT function -- The RIGHT function -- The MID function -- The TRIM function -- The LEN function -- The FIND and SEARCH functions -- The REPT function -- The CONCATENATE and & functions -- The REPLACE function -- The VALUE function -- The UPPER, LOWER, and PROPER functions -- The CHAR function. Note continued: The CLEAN function -- The SUBSTITUTE function -- Answers to this chapter's questions -- Extracting data by using the Convert Text To Columns Wizard -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- CUMPRINC and CUMIPMT functions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answer to this chapter's question -- Remarks -- Problems -- Answers to this chapter's questions -- Remarks -- Problems -- Answers to this chapter's questions. Note continued: Problems -- Answers to this chapter's questions -- Remarks -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's question -- Problems -- Answer to this chapter's question -- Problems -- Answer to this chapter's question -- Handling other constraints -- Solving binary and integer programming problems -- Problems -- Answers to this chapter's questions -- Problems -- Answer to this chapter's question -- Why is our model not a linear Solver model? -- Problems -- Understanding the GRG Multistart and Evolutionary Solver engines -- How does Solver solve linear model problems?. Note continued: How does the GRG Nonlinear engine solve nonlinear optimization models? -- How does the Evolutionary Solver engine tackle nonsmooth optimization problems? -- Answer to this chapter's questions -- Problems -- Answers to this chapter's questions -- Using conditional formatting to highlight each employee's ratings -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's question -- Problems -- Answers to this chapter's questions -- Remarks -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Using conditional formatting to highlight outliers -- Problems -- Answers to this chapter's questions -- Remarks about grouping -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Questions answered in this chapter -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions. Note continued: Problems -- Answers to this chapter's questions -- Problems -- Answer to this chapter's question -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's question -- Problems -- Answer to this chapter's question -- Problems -- Answer to this chapter's question -- Filling in the correlation matrix -- Using the CORREL function -- Relationship between correlation and R-squared -- Correlation and regression toward the mean -- Problems -- Answers to this chapter's questions -- Answers to this chapter's questions -- Answers to this chapter's questions -- Problems for Chapters 57 through 59 -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's question -- Problem -- Time-series characteristics -- Parameter definitions -- Initializing Winters method. Note continued: Estimating the smoothing constants -- Remarks -- Problems -- Answers to this chapter's questions -- Problem -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Remarks -- Problems -- Answers to this chapter's questions -- The impact of risk on your decision -- Confidence interval for mean profit -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answer to this chapter's question -- Problems -- Answers to this chapter's questions -- Problems. Note continued: Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Thse back-order case -- The lost-sales case -- Problem -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answer to this chapter's question -- Problems -- Answer to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems -- Answers to this chapter's questions -- Problems.