Excel: Designing stable spreadsheet models

Return To Event Page
This is the agenda for Table of contents
Table of contents
 
Introduction

• Welcome
• What is a Spreadsheet “Model”?
• Planning Models: Essential Groundwork
• Modeling Best Practices
• Dynamic Modeling Techniques

 
Exercise: Working through the DDM cash exercise

• Examining the “Vlookup” Function
• Using “Vlookup” in Dynamic Modeling
• Using the “IF” Function and Comments in Dynamic Modeling

 
Conditional formatting

Conditional Formatting

 
Exercise: Working through the DDM cash exercise (Continued)

• Using Conditional Formatting
• Putting the Model to Work with Cash Flows
• Using Outlining to Compress Model Sections

 
Review: The completed DDM cash exercise

• Reviewing the Completed Model
• Separating Data from Logic

 
Exercise: Styles

• Introduction to Styles
• Creating Custom styles

 
Example: Drink

Drink Pricing Worksheet

 
Example: Capital budgeting

• Using Models for Capital Budgeting
• Using Models for Sensitivity Analysis

 
Conclusion

• In Review
• Final Quiz

Highlights

Gain practical organizational insights and learn from industry experts at this annual event for not-for-profit financial leaders.