By Wyane Wilson
Grasp enterprise modeling and research concepts with Microsoft Excel 2013, and rework facts into bottom-line effects. Written by means of award-winning educator Wayne Winston, this hands-on, scenario-focused advisor indicates you the way to exploit the most recent Excel instruments to combine facts from a number of tables—and the best way to successfully construct a relational facts resource within an Excel workbook.
Solve genuine enterprise issues of Excel—and sharpen your edge
Summarize info with PivotTables and Descriptive Statistics
discover new tendencies in predictive and prescriptive analytics
Use Excel pattern Curves, a number of regression, and exponential smoothing
grasp complicated Excel services comparable to OFFSET and INDIRECT
Delve into key monetary, statistical, and time functions
Make your charts more advantageous with the ability View tool
Tame advanced optimization issues of Excel Solver
Run Monte Carlo simulations on inventory costs and bidding models
practice vital modeling instruments corresponding to the Inquire add-in
Table of Contents
Chapter 1. diversity names
Chapter 2. look up functions
Chapter three. INDEX function
Chapter four. fit function
Chapter five. textual content functions
Chapter 6. Dates and date functions
Chapter 7. comparing investments through the use of internet current price criteria
Chapter eight. inner fee of return
Chapter nine. extra Excel monetary functions
Chapter 10. round references
Chapter eleven. IF statements
Chapter 12. Time and time functions
Chapter thirteen. The Paste distinct command
Chapter 14. 3-dimensional formulas
Chapter 15. The Auditing instrument and Inquire add-in
Chapter sixteen. Sensitivity research with information tables
Chapter 17. The target search command
Chapter 18. utilizing the situation supervisor for sensitivity analysis
Chapter 19. The COUNTIF, COUNTIFS, count number, COUNTA, and COUNTBLANK functions
Chapter 20. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
Chapter 21. The OFFSET function
Chapter 22. The oblique function
Chapter 23. Conditional formatting
Chapter 24. Sorting in Excel
Chapter 25. Tables
Chapter 26. Spinner buttons, scroll bars, choice buttons, money bins, combination bins, and staff record boxes
Chapter 27. The analytics revolution
Chapter 28. Introducing optimization with Excel Solver
Chapter 29. utilizing Solver to figure out the optimum product mix
Chapter 30. utilizing Solver to agenda your workforce
Chapter 31. utilizing Solver to resolve transportation or distribution problems
Chapter 32. utilizing Solver for capital budgeting
Chapter 33. utilizing Solver for monetary planning
Chapter 34. utilizing Solver to fee activities teams
Chapter 35. Warehouse situation and the GRG Multistart and Evolutionary Solver engines
Chapter 36. consequences and the Evolutionary Solver
Chapter 37. The touring salesclerk problem
Chapter 38. uploading information from a textual content dossier or document
Chapter 39. uploading facts from the Internet
Chapter forty. Validating data
Chapter forty-one. Summarizing info by utilizing histograms
Chapter forty two. Summarizing facts through the use of descriptive statistics
Chapter forty three. utilizing PivotTables and slicers to explain data
Chapter forty four. the information Model
Chapter forty five. PowerPivot
Chapter forty six. strength View
Chapter forty seven. Sparklines
Chapter forty eight. Summarizing information with database statistical functions
Chapter forty nine. Filtering information and removal duplicates
Chapter 50. Consolidating data
Chapter fifty one. developing subtotals
Chapter fifty two. Charting tricks
Chapter fifty three. Estimating straight-line relationships
Chapter fifty four. Modeling exponential growth
Chapter fifty five. the ability curve
Chapter fifty six. utilizing correlations to summarize relationships
Chapter fifty seven. creation to a number of regression
Chapter fifty eight. Incorporating qualitative components into a number of regression
Chapter fifty nine. Modeling nonlinearities and interactions
Chapter 60. research of variance: one-way ANOVA
Chapter sixty one. Randomized blocks and two-way ANOVA
Chapter sixty two. utilizing relocating averages to appreciate time series
Chapter sixty three. Winters’s method
Chapter sixty four. Ratio-to-moving-average forecast method
Chapter sixty five. Forecasting within the presence of certain events
Chapter sixty six. An advent to random variables
Chapter sixty seven. The binomial, hypergeometric, and destructive binomial random variables
Chapter sixty eight. The Poisson and exponential random variable
Chapter sixty nine. the conventional random variable
Chapter 70. Weibull and beta distributions: modeling computing device existence and period of a project
Chapter seventy one. Making likelihood statements from forecasts
Chapter seventy two. utilizing the lognormal random variable to version inventory prices
Chapter seventy three. creation to Monte Carlo simulation
Chapter seventy four. Calculating an optimum bid
Chapter seventy five. Simulating inventory costs and asset allocation modeling
Chapter seventy six. enjoyable and video games: simulating playing and carrying occasion probabilities
Chapter seventy seven. utilizing resampling to research data
Chapter seventy eight. Pricing inventory options
Chapter seventy nine. picking out buyer value
Chapter eighty. the industrial order volume stock model
Chapter eighty one. stock modeling with doubtful demand
Chapter eighty two. Queuing concept: the math of ready in line
Chapter eighty three. Estimating a requirement curve
Chapter eighty four. Pricing items through the use of tie-ins
Chapter eighty five. Pricing items by utilizing subjectively decided demand
Chapter 86. Nonlinear pricing
Chapter 87. Array formulation and capabilities
