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

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

Update your knowledge and strengthen your network at this must-attend conference covering the most important issues and trends affecting audit committee members.

It’s probable that someone you know is deep in debt. If you are observant, you might see one of these seven signs.