1. Basic spreadsheet modeling
2. Range names
3. Lookup functions
4. The INDEX function
5. The MATCH function
6. Text functions
7. Dates and date functions
8. Evaluating investment by using net present value criteria
9. Internal rate of return
10. More Excel financial functions
11. Circular references
12. IF statements
13. Time and time functions
14. The Paste Special command
15. Three-dimensional formulas and hyperlinks
16 The auditing tool
17. Sensitivity analysis with data tables
18. The Goal Seek command
19. Using the Scenario Manager for sensitivity analysis
20. The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
21. The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
22. The OFFSET function
23. The INDIRECT function
24. Conditional formatting
25. Sorting in Excel
26. Tables
27. Spin buttons, scroll bars, option buttons, check
boxes, combo boxes, and group list boxes
28. The analytics revolution
29. An introduction to optimization with Excel Solver
30. Using Solver to determine the optimal product mix
31. Using Solver to schedule your workforce
32. Using Solver to solve transportation or distribution problems
33. Using Solver for capital budgeting
34 Using Solver for financial planning
35. Using Solver to rate sports teams
36. Warehouse location and the GRG Multistart and Evolutionary Solver engines
37. Penalties and the Evolutionary Solver
38. The traveling salesperson problem
39. Importing data from a text file or document
40. Validating data
41. Summarizing data by using histograms and Pareto charts
42. Summarizing data by using descriptive statistics
43. Using PivotTables and slicers to describe data
44. The Data Model
45. Power Pivot
46. Power View and 3D Maps
47. Sparklines
48. Summarizing data with database statistical functions
49. Filtering data and removing duplicates
50. Consolidating data
51. Creating subtotals
52. Charting tricks
53. Estimating straight-line relationships
54. Modeling exponential growth
55. The power curve
56. Using correlations to summarize relationships
57. Introduction to multiple regression
58. Incorporating qualitative factors into multiple regression
59. Modeling nonlinearities and interactions
60. Analysis of variance: One-way ANOVA
61. Randomized blocks and two-way ANOVA
62. Using moving averages to understand time series
63. Winters method
64. Ratio-to-moving-average forecast method
65. Forecasting in the presence of special events
66. An introduction to probability
67. An introduction to random variables
68. The binomial, hypergeometric, and negative binomial random variables
69. The Poisson and exponential random variable
70. The normal random variable and Z-scores
71. Weibull and beta distributions: Modeling machine life and duration of a project
72. Making probability statements from forecasts
73. Using the lognormal random variable to model stock prices
74. Introduction to Monte Carlo simulation
75. Calculating an optimal bid
76. Simulating stock prices and asset allocation modeling
77. Fun and games: Simulating gambling and sporting-event probabilities
78 Using resampling to analyze data
79. Pricing stock options
80. Determining customer value
81. The economic order quantity inventory model
82. Inventory modeling with uncertain demand
83. Queuing theory: The mathematics of waiting in line
84. Estimating a demand curve
85. Pricing products by using tie-ins
86. Pricing products by using subjectively determined demand
87. Nonlinear pricing
88. Array formulas and functions
89. Recording macros
