Patrick Curtis – Excel Modeling Course

In this module, we use In this module, we use 14 video lessons14 video lessons to explain best practices on how to gain maximum efficiency when navigating Excel (and Windows) for finance careers.  This includes an  to explain best practices on how to gain maximum efficiency when navigating Excel (and Windows) for finance careers.  This includes an exercise with aggressive benchmarkingexercise with aggressive benchmarking and a video solution to make sure you are building good habits for financial modeling and a video solution to make sure you are building good habits for financial modeling

In this module, we use In this module, we use 8 video lessons8 video lessons to expand upon the best practices in previous modules to learn conditional formatting and custom number formatting (among other topics).  This module also includes an  to expand upon the best practices in previous modules to learn conditional formatting and custom number formatting (among other topics).  This module also includes an exercise with aggressive benchmarkingexercise with aggressive benchmarking and a video solution to make sure you keep practicing until you are very productive… and a video solution to make sure you keep practicing until you are very productive…

In this module, we use In this module, we use 9 video lessons9 video lessons to help explain anchoring as well as basic and advanced math functions that will come up frequently on the job. This module also includes an exercise at the end with a video solution so you can see how an  to help explain anchoring as well as basic and advanced math functions that will come up frequently on the job. This module also includes an exercise at the end with a video solution so you can see how an actual investment banker uses theseactual investment banker uses these in the real world… in the real world…

In this module, we use In this module, we use 13 video lessons13 video lessons to dive into some of the more complex and foundational functions used throughout financial modeling.  This includes IF and Nested IF statements, ISERROR, Information Functions and more. We wrap up this module with another  to dive into some of the more complex and foundational functions used throughout financial modeling.  This includes IF and Nested IF statements, ISERROR, Information Functions and more. We wrap up this module with another challenging exercisechallenging exercise……

In this module, we use In this module, we use 8 video lessons8 video lessons to explore vlookup, hlookup, data validation as well as index and match and when it is best to use each in the context of financial modeling. We wrap up this module with another  to explore vlookup, hlookup, data validation as well as index and match and when it is best to use each in the context of financial modeling. We wrap up this module with another challenging exercise that tests your retention and speedchallenging exercise that tests your retention and speed……

In this module, we use In this module, we use 7 video lessons7 video lessons to explore data tables, naming cells, formula auditing and Scenarios so that you can take your Excel modeling to another level.  This module also includes another  to explore data tables, naming cells, formula auditing and Scenarios so that you can take your Excel modeling to another level.  This module also includes another timed benchmarking exercisetimed benchmarking exercise……

In this module, we use In this module, we use 7 video lessons7 video lessons to explore sorting, filtering and pivot tables which are used extensively when trying to analyze the various outcomes and input sensitivities in financial models.  Learn through doing with another  to explore sorting, filtering and pivot tables which are used extensively when trying to analyze the various outcomes and input sensitivities in financial models.  Learn through doing with another timed benchmarking exercisetimed benchmarking exercise……

In this module, we use In this module, we use 7 video lessons7 video lessons to explain best practices when navigating Excel.  This includes an  to explain best practices when navigating Excel.  This includes an exercise with aggressive benchmarkingexercise with aggressive benchmarking and a video solution to make sure you don’t move on until you have true mastery. and a video solution to make sure you don’t move on until you have true mastery.