Workshop 3: Excel Modeling and Analysis Tools

Prerequisite: Workshop 1 or experience with Excel formulas and the use of Excel functions

Functions

• Financial
• Logical
• Lookup

Data tables and charts

Pivot table

Optimization with Solver

• Loading the Solver
• Linear models
• Nonlinear models
• Integer variables
  

Monte Carlo Simulation

• Random number generation using Excel functions
• Random number generation with Analysis Toolpak
• Statistical analysis
  

Decision Trees with Treeplan

analysis.xls

analysis-complete.xls

Revised August 26, 2005 by J N Hagstrom