Certified Financial Modeller face-to-face workshop | 26-27 June

PLEASE NOTE THIS IS A TWO DAY FACE TO FACE PROGRAMME

Certified Financial Modeller

The Certified Financial Modeller programme run by Lexicon School of Business & Finance is endorsed by the Institute of Financial Accountants.

Many members, non-members and accounting & finance students have completed the two day programme to enhance their skills and awareness of financial modelling, reporting and advanced excel skills.

The programme will be run face to face at London Southbank University on 26 and 27 June 2024.

Financial Modelling, Valuation and dashboard reporting are very emerging skills required by every finance professional. Certified Financial Modeler (CFM) program is designed to provide in depth understanding of these skills in a practical manner.

The areas that you will learn:

• Excel Functions and Features Required for Financial Modeling
• Defined Names
• What if Analysis in Excel
• Model Structure
• Understanding Workbook, Worksheet and Cell formatting for model
• Financial Modeling Best Practices & Revenue Drivers
• Scenarios Analysis and Integration with model
• Sensitivity Analysis
• Preparation of Schedules for Financial Model
• Preparation of Valuation Model - Case Study
• Project Appraisal Calculations: NPV, IRR, Payback Period, Profitability Index
• Model Auditing Techniques to ensure quality.
• Getting data from multiple sources using power query
• Creating relationships among all sources using data modeling
• Data Analysis and Dashboard Reporting using Power Excel
• Advanced Excel skills
• Financial Model Preparation from scratch to advance level
• Data Analysis and Dashboard Reporting using Power Excel (Power Query & Power Pivot)

Delegates must take note of the following instructions.

• You must bring a laptop with charger.

Venue: London Southbank University Business School – Learning Lounge, 103 Borough Road, London, SE1 0AH

Timings: 9am to 5pm, with an hour for lunch and a mid-morning and mid-afternoon break.

Price:

• IFA members £185 (includes two-day programme and endorsed completion certificate)
• Non-members £235 (includes two-day programme and endorsed completion certificate)
• IFA Direct students £135 (includes two-day programme and endorsed completion certificate)

When: Wednesday 26 and Thursday 27 June 2024
Time: 9:00am - 5:00pm both days
Where: London Southbank University Business School – Learning Lounge, 103 Borough Road, London, SE1 0AH
CPD hours: 14.0
Price:

• IFA members £185 (includes two-day programme and endorsed completion certificate)
• Non-members £235 (includes two-day programme and endorsed completion certificate)
• IFA Direct students £135 (includes two-day programme and endorsed completion certificate)

About the speaker:

Abdul Shakoor, CMA (USA), FFA (UK), AFM

Abdul currently working as Chief Financial Officer (CFO) for TOSHIBA and BOSS Home Appliances is an experienced professional having diversified experience in the field of Financial Modeling, Budgeting and Forecasting, Data Analysis and visualisation in Power BI.

He is heading LEXICON Global organization and a Regional Director for Institute of Financial Accountants (IFA) UK for Pakistan. Previously he had been teaching as an adjunct faculty member in University of the Punjab, Air University, Islamabad and PAC Group having overall more than 12 years of experience.

Academically he is an:

• Fellow Financial Accountants (FFA) UK
• Certified Management Accountant (CMA) US
• Advanced Financial Modeler (AFM) from FMI Canada

He has provided open house and on-premises training on Accounting, Finance, Financial Modeling, Data Analysis in Power Excel, and Data Analysis in Power BI to leading organizations in Pakistan, UAE, and Egypt. He has trained hundreds of professionals from UK, Canada, South Africa Saudi Arabia, Dubai, Kuwait, Ghana, Nigeria and Afghanistan through live interactive programs.

LEXICON School of Business & Finance

LEXICON is a leading education and training organization offering IFA accredited and endorsed programs. The have offered numerous open house and on-premises trainings.