Font size:

- MDA Training - 

Learn how to build better formulas in Excel 2007 / 2003.  This course will guide you in using industry standard methods and techniques to help you increase the accuracy of your financial model and speed up your model building process.  Desktop widgets are available as part of the course to provide you with additional video assistance.

Title:  How to build better formulas in Excel

Instructor:  Scott Powell

Session length:  24 Slides / 21 minutes

Anticipated completion time:  45 minutes

Quiz:  5 questions - no time limit

Course expiry:  3 months after initial viewing


Objectives:
1) Build flexibility into financial forecasts.
2) Break down complex calculations.
3) Minimize errors in Excel models.
4) Understand Excel function syntax.

Skills gained:

1) Learn how to use names to make your financial model robust and easy to follow.
2) Use VLOOKUP tables to enable flexibility in your model.
3) Learn the correct syntax so that you are confident your formulas are accurate.  

Course Content:
1) Build flexibility into financial forecasts instead of hardcoding numbers into your model.
2) Break down complex calculations into steps so that your numbers are easy to follow.
3) Minimize errors in Excel models.
4) Understand Excel function syntax so that you can be confident your formulas are accurate.


Register Now
Fundamentals of financial modeling: Key design issues - Better formulas Online course
  • Course ID:
    198352
  • Duration:
    n/a
  • Price:
    $50