Become UK Certified Modeler

Hands on, live interactive program

This batch includes lambda functions and preparation of model using dynamic array functions

Introduction

Financial Modeling & Analysis skills are most emerging and required by the industry and organizations. This program is endorsed by The Institute of Financial Accountants (IFA). After successfully completing the course the candidate will be provided with a completion certificate from the Institute of Financial Accountants (IFA) UK. 

Key Features

  • Competitive advantage with emerging skillset
  • Increased recognition with UK endorsement
  • Career Growth with most emerging skill set
  • Practical course with Hands on Practice
  • Online Interactive Instructor Led training
  • Recording of each session is provided
  • Trainer presentation and practice material is provided

Course Contents

  • What is financial modeling?
  • Why you should learn financial modeling skills?
  • Scope of financial modeling
  • Job prospects with financial modeling skills
  • What will the financial model tell us?
  • Understanding of function syntax
  • Date and time Functions
  • Logical functions
  • Array formulas
  • NPV, XNPV, IRR, XIRR, MIRR
  • PMT, IPMT, PPMT
  • Index, Match, Choose
  • Absolute and Relative Cell references
  • How to define name of cells and ranges
  • How to use name manager
  • Defining names from selection
  • Pros and cons of defined names
  • 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
  • How to perform What if Analysis in Excel
  • Use of Goal Seek
  • Data Table Option for more than one variable
  • One way and two way data tables
  • Understanding Workbook, Worksheet and Cell
    formatting for model
  • A detailed discussion on how to arrange workbook.
  • Best tabs structure for worksheets
  • How to format a sheet for a financial model
  • Cell formatting
  • Color coding of cells for easy understanding
  • Financial Modeling Best Practices
  • Strategies to build financial model.
  • Data Flow to integrate the model.
  • Strategies to forecast revenue for existing organizations and Startups.
  • What is Scenario Analysis
  • Selection of Economic and other indicators for scenarios
  • Scenarios List i.e Base, Best and Worst
  • Use of Combo Box and Data Validation for Scenario analysis
  • How to build scenario switch
  • Scenario switch integration with the model
  • Summary of each scenario
  • What is sensitivity Analysis
  • How to perform sensitivity Analysis
  • Use of Data Table in performing sensitivity Analysis
  • Revenue and pricing
  • Cost of Sales
  • HR and Payroll
  • Operating Costs
  • Working Capital
  • PPE Lapsing & Depreciation
  • Debt and Loan Amortization
  • Equity – Common & Preferred Equity
  • Income Tax – Current & Deferred Tax
  • How to integrate financial statements
  • Forecasted Income Statement
  • Forecasted Balance Sheet
  • Forecasted Cash Flow Statement
  • Understanding of Discounted Cash Flow (DCF) Model
  • Building of DCF mode with practical Case Study
  • Calculation of
    • NPV
    • IRR
    • Profitability Index (PI)
    • ROI- Return on Investment, and
    • Payback period
  • How to use built in checks to audit a financial model
  • Financial Modeling Auditing techniques
  • Understanding of Formula Auditing
  • Creating Pivot Table and analyzing data with pivot tables
  • How to add Slicers & Timeline
  • Connection of Multiple Pivot Tables
  • Getting and connecting data from multiple sources like excel, text, web, pdf and databases
  • Use of Power Query, Data Modeling and Power Pivot
  • Data Modeling to create relationship of multiple data sources
  • Preparation of Pivot tables using power pivot
  • Use of Pivot Charts to prepare dashboards.
  • How to create connection among multiple pivot charts
  • Principles of Dashboard Reporting
  • Use of slicers and timelines in dashboard
  • Preparation of a dynamic and integrated dashboard from a case study

Endorsed By

The Institute of Financial Accountants has endorsed this program.  After successfully completing the course the candidate will be provided with a completion certificate from the Institute of Financial Accountants (IFA) UK.  
 
The IFA is a full member of the International Federation of Accountants.

1 New Batch Starting Details

  • Starting From: Batch 53 is starting from May 19, 2025 (InshaAllah)
  • Program Duration: 2 Weeks  | 8 Sessions of 2 hours each
  • Class Days: Monday, Tuesday, Wednesday & Thursday
  • Class Timing: From 8:00pm to 10:00pm (GMT+5, Pakistan Time)
  • Medium of Instruction: English, as this is an international program

2 Program Deliverables

  • Practice Workbooks
  • Case studies
  • Financial Modeling Book
  • Comprehensive Notes
  • Sample Models
  • Recording of each session
  • LEXICON E-Certificate

3 Important Note

• Training Fee includes LEXICON e-Certificate
• IFA UK Certificate fee is separate than training fee
• Delivery of hard copy certificate is free across UK & Pakistan whereas for other countries actual delivery charges will apply

Fee Schedule

Training Fee: PKR 35,000/- | IFA UK Certificate Fee: GBP65

(Note: Training fee includes soft copy of LEXICON certificate, whereas for hardcopy of IFA UK certificate one has to pay, further the dispatch of hardcopy is free in UK and Pakistan whereas for any other country actual courier charges will apply)

Customer Reviews

Participants Testimonials

It was a great pleasure to be the part of CFM-UK training session conducted by LEXICON. The delivered session had a vast learning aspects adding value to my career & Job. The trainers associated with LEXICON are highly knowledgeable professionals. I am very thankful to LEXICON for opening a professional platform with multiple certifications.

Sania Sultan, CFM
Chief Accountant, Carrefour PAK

#Certified Financial Modeler (CFM) #Financial Modeling Certification UK #Financial Analysis Training #Financial Planning Courses UK #Investment Analysis Certification #Financial Modeling Courses London #UK Financial Modeling Certification #Excel Financial Modeling Training #Financial Forecasting Courses #Corporate Finance Training UK #Financial Planning and Analysis (FP&A) Certification #Financial Modeling for Investors #Advanced Financial Modeling #Financial Modeling for Banking and Finance #Professional Financial Modeling Certification “Become a certified financial modeler” “Enhance your financial analysis skills” “Master financial modeling with Excel” “Advance your finance career” “Improve financial forecasting accuracy” “Gain expertise in financial planning” “Develop investment analysis skills” “Achieve professional financial modeling certification” “Stay ahead in finance with CFM certification” “Transform financial decision-making” #LEXICON a best institute for financial modeling in Pakistan CFM in Islamabad CFM in Lahore #CFM in Karachi