1Advanced MS Excel Features like DB function, data visualization, complex function, index match, XNPV/ XIRR, PMT/IPMT and mathematical functions.
2Calculation and interpretation of advanced financial decisions on MS Excel like capital budgeting (with risk analysis), financial analytics, valuation of equity (DDM, CAPM, arbitrage pricing model etc.), portfolio creation and evaluation, option pricing and risk management through derivatives.
3Preparing and presenting dashboard reports.