WhatsApp : +918121020333 / +919849510373

India: +91 40 6050 1418

USA: +1 516 8586 242

UK: +44 (0)203 371 0077

Financial Modeling Ms Excel Training

Financial Modeling Ms Excel Training

Financial Modeling Ms Excel Training Introduction

Financial Modeling Ms Excel Online Training Course Content

Spreadsheet modelling techniques
  • Basic structure (separation of data from processing & output)
  • Cell referenced formulas (no hard coding of data)
  • Modularisation (break a complex model into simple bits)
  • Prototype development & refinement
  • Sensitivity analysis
  • Troubleshooting & debugging
  • Reasonability testing (common sense)
Microsoft Excel functions & methods useful for the modeling
  • Named cell ranges
  • Lookup the functions
  • Conditional functions (IF, COUNTIF, SUMIF)
  • Financial functions (IRR, NPV)
  • Formula nesting (pros & cons)
  • Auto filters
  • Advanced filters
  • Goal seeking
  • Conditional formatting
  • Navigation buttons
Automating your model with the macros
  • Pros & cons
  • Setting the macro security level
  • Recording & running simple macros
  • The Visual Basic editor
  • Modifying a recorded macro for the general use.
Protecting your model from the undesired changes
  • Model structure
  • Locking cells
  • Worksheet & workbook protection
  • Password protection
  • Cross checks & error reports
  • Data validation
Output presentation (tips for effective reporting of results)
  • The importance of documentation
  • Spread sheet model multimedia
  • Adding sound to your model
  • Providing video with your model
  • Make your model talk