• Live Course: Financial Model Design

    Course Description

    How many times have you begun building a spreadsheet, only to have it evolve on you based on requests from users and managers? While this is a great compliment to your work and skills, these changes can cause our spreadsheets to grow and change to the point where we introduce errors and instability very easily.

    This course has been developed to teach users how to build solid, dynamic and stable financial modeling spreadsheets, all modeled on best practice rules.

    We’ll begin by looking at the key decisions that should be discussed and made before a single formula is entered. You’ll learn how to design models to invite valid data the first time, how to structure links, and how to make your models more auditable in the long term.

    Strategies covered in this course include:
    • Determining model scope
    • Structuring a financial model
    • Documentation strategies
    • Model friendliness
    • Protecting the model structure

    A variety of techniques will be employed to build a cash flow model for a fictional business. During this process, we’ll focus on how we can implement the techniques and strategies learned to give our models a better chance of standing the test of time.

    Target Audience:

    This course is intended for people who build Excel spreadsheets and feel comfortable in Excel. Basic PivotTable experience is required.

    Course Requirements

    This is a hands on course. All attendees are required to bring a laptop running Excel 2007 or higher.

    Course at a Glance:

    • Financial modeling theory
    • Building a basic cash flow model
      • Using IF to drive dynamic scenarios
      • Using GETPIVOTDATA functions to draw data from PivotTables
      • Data validation (proactive and reactive)
      • Conditional Formatting
      • Protecting the model

    Registration Includes

    • A full day of hands on, in class instruction (9:00AM - 4:30 PM)
    • Coffee breaks
    • Lunch
    • A certificate of attendance (for claiming Professional Development credits)
    • A wealth of information that will change the way you build Excel models forever

    Registration Details

    This course is currently being offered on the following dates/locations:

    Early Bird Price*
    Registration Link
    Don’t see a date/location that works for you? Request the course be run in your area. If we can make it work, we will!

    Other Courses

    Remember, you can always find all of our currently scheduled courses on our training calendar at http://www.excelguru.ca/forums/calendar.php


    I'm afraid that you must be logged in to comment or leave a testimonial. I wish it could be otherwise, but I'm trying to keep my site spam free for everyone's benefit. If you don't yet have an account it's completely free to sign up, and a very quick process. Simply click here to Register. Not only can you post a comment here, but it gives you full access to posts questions in our forum as well!


    If you already have an account, and just haven't logged in yet, what are you waiting for? Login Now!

  • Recent Knowledge Base Articles

    Ken Puls

    Making Pivot Table Hyperlinks Clickable

    If you’ve ever built a PivotTable that contains hyperlinks, you’ll notice that clicking the hyperlinks doesn’t do anything. This can be a bit frustrating as the reason you put that field on the Pivot in the first place is that it’s valuable information you want to use. When you click the hyperlink,... read more
    Ken Puls 2013-10-31, 01:58 AM
    Ken Puls

    Temperature Forecast Chart

    Some of the really cool charts that we can build in Excel involve the trick of combining multiple chart types together to make them happen. In this article, we’ll build one of those; a temperature chart that not only shows the forecasted high and low temperatures, but also the season highs and lows. The beauty of this chart is that it provides a lot of information, some of which essentially fades into the background until you really need it.
    ... read more
    Ken Puls 2013-03-21, 05:04 AM
    Ken Puls

    VLOOKUP for Pictures

    Something that can be very handy when you’re building a dashboard is to return a certain picture depending on a condition. We can use VLOOKUP to look up data in a table and return the corresponding value from a different column, but unfortunately we can’t do that with pictures... or can we?

    This example shows how to accomplish the equivlanet of a picture VLOOKUP, and is based on looking up a picture to display the appropriate... read more
    Ken Puls 2013-03-14, 05:47 AM
    Ken Puls

    Understanding How Conditional Formatting Rules Are Applied

    Conditional formatting in Excel is a powerful tool that allows you to dynamically format cells depending on the values of that or other cells’ data. In Excel 2007 the conditional formatting engine was re-written, opening things up to allow more than 3 conditional formats on any cell, as well as conditional formats that could overlap ranges. All in all, these were fantastic improvements that can lead to some very versatile and useful worksheets.

    Unfortunately, the user interface to control conditional formatting is not the most intuitive. The purpose of this article is to help you understand the way Excel applies rule precedence so that you can build powerful formatting rules of your own, without getting frustrated along the way.
    ... read more
    Ken Puls 2013-01-22, 06:30 AM