Wayne L. Winston. -- [S.l.] : Microsoft Press, 2014.

xxvi, 859 p.; 23 cm.

ISBN 978-0-7356-6913-0.

Incluye índice.

Contenido: Introduction -- Range games -- Lookup functions -- INDEX function -- MATCH function -- Text functions -- Dates and date functions -- Evaluating investments by using net present value criteria -- Internal rate of return -- More Excel financial functions -- Circular references -- IF statements -- Time and time functions -- The Paste Special command -- Three-dimensional formulas -- The Auditing tool and Inquire add-in -- Sensitivity analysis with data tables -- The Goal Seek command -- Using the Scenario Manager for sensitivity analysis -- The COUNFIT, COUNFITS, COUNT, COUNTA, and COUNTBLANK functions -- The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions -- The OFFSET function -- The INDIRECT function -- Conditional formating -- Sorting in Excel -- Tables -- Spinner buttons, scroll bars, option buttons, check boxes, combo boxes, and group list boxes -- The analytic revolution -- Introducing optimization with Excel Solver -- Using Solver to determine the optimal product mix -- Using Solver to schedule your workforce -- Using Solver to solve transportation or distribution problems -- Using Solver for capital budgeting -- Using solver for financial planning -- Using Solver to rate sports teams -- Warehouse location and the GRG Multistart and Evolutionary Solver engines -- Penalties and the Evolutionary Solver -- The traveling salesperson problem -- Importing data from a text file or document -- Importing data from the Internet -- Validating data -- Summarizing data by using histograms -- Summarizing data by using descriptive statistics -- Using PivotTables and slicers to describe data -- The Data Model -- PowerPivot -- Power View -- Sparklines -- Summarizing data with database statistical functions -- Filtering data and removing duplicates -- Consolidating data -- Creating subtotals -- Charting tricks -- Estimating straight-line relationships -- Modeling exponential growth -- The power curve -- Using correlations to summarize relationships -- Introduction to multiple regression -- Incorporating qualitative factors into multiple regression -- Modeling nonlinearities and interactions -- Analysis of variance: one-way ANOVA -- Randomized blocks and two-way ANOVA -- Using moving averages to understand time series -- Winterss method -- Ratio-to-moving-average forecast method -- Forecasting in the presence of special events -- An introduction to random variables -- The binomial, hypergeometric, and negative binomial random variables -- The Poisson and exponential random variable -- The normal random variable -- Weibull and beta distributions: modeling machine life and duration of a project -- Making probability statements from forecasts -- Using the longnormal random variable to model stock prices -- Introduction to Monte Carlo simulation -- Calculating and optimal bid -- Simulating stock prices asset allocation modeling -- Fun and games: simulating gambling and sporting event probabilities -- Using resampling to analyze data -- Principing stock options -- Determining customer value -- The economic order quantity inventory model -- Inventory modeling with uncertain demand -- Queuing theory: the mathematics of waiting in line -- Estimating a demand curve -- Pricing products by using tie-ins -- Pricing products by using subjectively determined demand -- Nonlinear pricing -- Array formulas and fuctions.