LEXICON is offering a day-long training to harness your financial modeling skills and learn to prepare models with Lambda Functions and Dynamic Arrays.
Register Here:
https://bit.ly/masteringfinmod
What will you learn?
• What is financial modeling and why you should learn.
• Introduction to new features in MS Excel 365 for financial Analysis
• Introduction to Dynamic Arrays
• Using to Dynamic Data Tables
• #Sign and Spilled array behavior
• New Excel functions, LAMBDAs, Sequence, Transpose, ByRow, ByCol, Sort
• Preparation of a complete model using dynamic array formulas
• Discounted Cash Flow Model – Case Study
• Calculation of NPV, IRR, ROI, Profitability Index and Payback period
• Calculation of Terminal Value
• Calculation of Enterprise Value
Investment: Rs. 25,000/- Excluding Taxes
Deliverables
• 8 CPD Hours certificate
• Training Material
• Buffet lunch and 2 tea breaks
When: Wednesday, July 9, 2025 from 9:00am to 5:00pm
Where: NUST University, Islamabad
Note: Bring your laptop with Office 365 Installed.
Register Here:
https://bit.ly/masteringfinmod
For Details
Miss Warda Taj 0328 8875000 | 0320 8875000 |
aW5mbyB8IGxleGljb24gISBlZHUgISBwaw==
Also check out other Workshops in Amritsar.
