SPECIALISTS IN FINANCIAL MODELLING

In this video:

  • Difference between an exact match and close match in lookup functions
  • Flat tiering calculations
  • Using tiered calculations to put population data into age brackets
  • Progressive tiering tables such as income tax calculations

Additional Resources

Book Cover

Dummies Book coverIf you signed up for the Online Financial Modelling Bundle then you will be receiving either a hard copy or ebook version of “Using Excel for Business and Financial Modelling” as well as “Financial Modeling in Excel for Dummies” by Danielle Stein Fairhurst included in your registration.  If you’d like to upgrade to the bundle and complete all three courses, please contact us and we can upgrade your registration!  Note that these books act as handy study companions to this course for additional supplementary reading and exercises.  Purchase of the books is recommended, but not required to complete the course.

Please note:

To move forward to the next video, you must mark this video complete. To mark the video complete, please watch the video or if you would like to skip the video, just click on the video time line right at the end to enable the ‘Mark Video Complete’ button. See instructions on the Student Dashboard here for more information.