The MS Excel Financial Modeling training course is designed for professionals of all backgrounds with a need to use MS Excel in financial models and business analysis. Course coverage will include the use of analytical techniques such as internal rate of return (IRR) and net present value (NPV). Implementation and use of the IRR and NPV functions in MS Excel as well as numerous other spreadsheet techniques including lookup functions, conditional sum and if formulas, autofilters, and conditional formatting will be explored in detail.
Familiar with basic MS Excel navigation including creating the basic formula calculations of Sum and Average.
The MS Excel Financial Modeling workshop is suitable for everyone who can use Excel to perform simple tasks and who wants to become familiar with and master, Excel tools, formulas and functions necessary for use in their financial models and business analysis in Excel. The course content covers Intermediate to Advanced Excel usage in basic models.