Advanced Decision Financial Modeling Using Excel

Advanced Decision Financial Modeling Using Excel
The ability to create and understand financial models is one of the most valued skills in business and finance today.
Microsoft Excel and macros programming has been the dominant vehicle used by finance and corporate professionals in the preparation and utilization of the full range of financial models and other applications.
Some of the topics that will be discussed include:
-The 40 Excel functions that financial modelers use the most
-Best practice in modeling forecasted financial statements (Balance Sheet, Income Statement and Cash Flow Statement)
-The powerful combination of arrays, the offset function, the match function and drop down menus
-The danger of using IRR in isolation and possible solutions
-Modeling and automating ratio analysis in Excel