-
Chapter 1 Basic spreadsheet modeling
-
Chapter 2 Range names
-
Chapter 3 Lookup functions
- Chapter 4 The INDEX function
-
Chapter 5 The MATCH function
-
Chapter 6 Text functions
-
Chapter 7 Dates and date functions
- Chapter 8 Evaluating investment by using net present value criteria
-
Chapter 9 Internal rate of return
-
Chapter 10 More Excel financial functions
-
Chapter 11 Circular references
-
Chapter 12 IF statements
-
Chapter 13 Time and time functions
-
Chapter 14 The Paste Special command
-
Chapter 15 Three-dimensional formulas and hyperlinks
-
Chapter 16 The auditing tool
-
Chapter 17 Sensitivity analysis with data tables
-
Chapter 18 The Goal Seek command
-
Chapter 19 Using the Scenario Manager for sensitivity analysis
-
Chapter 20The COUNTIF, COUNTIFS, COUNT, COUNTA, and COUNTBLANK functions
-
Chapter 21 The SUMIF, AVERAGEIF, SUMIFS, and AVERAGEIFS functions
-
Chapter 22 The OFFSET function
-
Chapter 23 The INDIRECT function
-
Chapter 24 Conditional formatting
-
Chapter 25 Sorting in Excel
-
Chapter 26 Tables
-
Chapter 27 Spin buttons, scroll bars, option buttons, check
-
boxes, combo boxes, and group list boxes
-
Chapter 28 The analytics revolution
-
Chapter 29 An introduction to optimization with Excel Solver
-
Chapter 30 Using Solver to determine the optimal product mix
-
Chapter 31 Using Solver to schedule your workforce
-
Chapter 32 Using Solver to solve transportation or distribution problems
-
Chapter 33 Using Solver for capital budgeting
-
Chapter 34 Using Solver for financial planning
-
Chapter 35 Using Solver to rate sports teams
-
Chapter 36 Warehouse location and the GRG Multistart and Evolutionary Solver engines
-
Chapter 37 Penalties and the Evolutionary Solver
- Chapter 38 The traveling salesperson problem
- Chapter 39 Importing data from a text file or document
- C