Excel: Design dynamic spreadsheet models

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

• 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

Review: The completed DDM cash exercise

• Reviewing the Completed Model
• Separating Data from Logic

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

Example: Drink

Drink Pricing Worksheet

Example: Capital budgeting

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

Exercise: Styles

• Introduction to Styles
• Creating Custom styles


• In Review
• Final Quiz


Canada is celebrating its 150th anniversary. We’re celebrating you, Canadian CPAs. Tell us why you’re proud to be a Canadian CPA. Then watch for our big celebration in July.

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