The real skill of most financial modellers is actually that they use a solid structure and they use the best function for the problem. In Excel, there are always lots of ways to achieve a solution but each way has its pros and cons. If you can just determine which formula to use, your modelling life will be much easier.
So how do we know which function or formula to use. Experience helps but we feel that everyone can work through this process to at least understand what type of function is required. Once you know this, you can search for the appropriate function.
To see the full course contents click here.