LEXICON is offering day-long training to harness your financial modeling skills and learn to prepare models with Lambda Functions and Dynamic Arrays along with dashboard reporting.
What you will 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
- Scenario Analysis
- Sensitivity Analysis
- Connection of data from multiple sources
- Use of Power Query and Power Pivot
- Dynamic Dashboard Preparation
Investment: Rs. 28,000/- Excluding Taxes
Deliverables
- 8 CPD Hours certificate
- Training Material
- Buffet lunch and 2 tea breaks
Schedule
When: Thursday 07 August, 2025 from 9:00am to 5:00pm
Where: PC Hotel, Lahore
Note: Bring your laptop with Office 365 Installed.
For Details
Miss Warda Taj 0328 8875000 | 0320 8875000 | info@lexicon.edu.pk
#FinancialModelingTraining #FinancialModelingWorkshop #FinancialModelingPakistan #FinancialModelingLahore #ValuationTraining #ExcelFinancialModeling #ExcelForFinance
#FinancialModelingAndValuation #DashboardReporting #ExcelTrainingPakistan #LEXICONBestFinancialModleingInstitute #TopFinancialModelingInstituteinLahore #TopFinancialModelingInstituteinPakistan #Top10FinancialModelingInstituteinPakistan #FinancialModelingtraininginLahore #FinancialModelingTraininginKarachi #FinancialModelingTraininginIslamabad #FinancialModelingTraininginRawalpindi #FinancialModelingCertification #BusinessValuationWorkshop #FinancialModelingCourse #Excel365 #ExcelTraining #ExcelDynamicArrays #ExcelLAMBDA #PowerQueryTraining
#PowerPivotTraining #ExcelDashboard #ExcelForFinancialAnalysis #AdvancedExcelTraining #DCFModel #NPVCalculation #IRRCalculation #ROIAnalysis #EnterpriseValue #ScenarioAnalysis
#SensitivityAnalysis #InvestmentAnalysis #CorporateFinanceTraining #FinancialModelingWorkshopPCHotelLahore #ExcelFinancialAnalysisTrainingLahore #FinancialModelingCertificationPakistan #FinancialModelingwithExcel365CourseLahore