Accountants, Business support partners, marketing professionals project managers, quantity surveyors and entrepreneurs now need financial modeling skills to do their job effectively. The availability of data and the ever-powerful Microsoft Excel tool makes financial modeling a required skill. But what do you need to be good with financial modelling?

Any calculation that requires planning the use of resources with a view to testing the plan for feasibility, controlling implementation and sourcing for funds to implement projects will entail financial modeling. The knowledge of these models has always been in the body of knowledge of finance, accounting, quantity survey and the likes. However, You need Microsoft Excel knowledge, mainly Excel functions and formulas to build the necessary relationships between inputs and desired outputs so as to visualize how the numbers make the full plan.

Most of these functions are date functions for timing of the model and effecting changes based on timing. Additionally, you need logical and lookup functions to build scenarios. Then you need math and statistics functions to model relationships between quantities and outputs.

Below are short videos that you can watch to improve your use of Excel functions for financial modeling. More functions will be treated as the day go by. Make sure you do not miss out.


https://www.youtube.com/watch?v=LoYDrFLs7yo


https://www.youtube.com/watch?v=OoSKdiHjAzM


https://www.youtube.com/watch?v=uZosO-K-FOw


https://www.youtube.com/watch?v=uZosO-K-FOw&list=PLjE0lX1tSAktmCau4xOT7eynsdASgKDFe