Be a Financial Analyst! - Dice Analytics

Be a Financial Analyst!

Certified Financial Modeling, UK  

Dice Analytics in collaboration with Lexicon School of Business and Finance (LSBF) has arranged an informative 2 weeks extensive workshop on Certified Financial Modeler (CFM) UK. Financial Modeling and analysis are among the most highly-respected skills in the business world and job marketplace. From Banks, Accounting, Investment, Insurance and Business Decision-Making rely on complex analytical decisions every day. This financial modelling course will teach candidates to forecast the future performance of a company using a model built in Excel, candidates will learn the fundamentals of accounting, corporate finance, budgeting and forecasting and valuation.


By the completion of the course, the participant would be eligible for International Certification (CFM) by Institute of Financial Accountants (UK)!


You will further learn:


  • Identification and application of advanced excel functions essential for Financial Modeler
  • Apply best practices for financial modelling for preparation of model
  • Model structure designing based on pre-determined outputs & requirements
  • Apply best practices in capital structure modelling and financial appraisal methods
  • Build and incorporate Operating & Financial Schedules
  • Perform sensitivity and scenario analysis in financial modeling
  • Auditing Techniques in Excel to check the integrity and errors
  • Valuation, forecasting and strategic financial decision making
View Course Outline Reserve Your Seat



To be announced soon


2 Weeks (Mon – Fri)


07:00PM to 09:00PM


Limited spots available!

Meet the Trainers

Meet the trainers of this course who is an experienced financial analyst!


Mr. Abdul Shakoor

Founder LEXICON I CFO I Regional Director IFA-UK I PU Lecturer I Advanced Excel Trainer

He is an experienced professional in the field of accounting, finance and advanced Excel. He also teaches as an adjunct faculty member in University of the Punjab and representing Pakistan as Regional Director of Institute of Financial Accountants (IFA) UK. Previously, he was teaching IT from Accountants to CA students in PAC group of Colleges, a leading institute for Chartered Accountancy.

Course Outline

Week 1

    Advanced Excel Functions

    • Using Complex Excel Functions
    • Using Multi-sheet Formulas
    • Using What if Analysis
    • Goal Seek
    • Scenario Manager
    • Dynamic Vlookup
    • Fixed Asset Schedule
    • Loan Amortization


    Business Reporting and Financial Analyses

    • Pivot Table, analyzing with pivot tables
    • Slicers
    • Timeline
    • Charts, Smart Tables
    • Connection of Multiple Pivot Table
    • Connection of Multiple Slicers
    • Reporting through SUMIF, SUMIFS, Index & Match Etc.


    Taxation Implications in Financial Statements and Financial            Modeling

    • IF Function
    • Multiple IFS
    • Salaried & Non-Salaried Income Tax Calculator 2020
    • AOP Income Tax Calculator 2020
    • Tax Calculator on Rental Income Individual/AOP 2020
    • Capital Gain Tax Calculation with Tax Card 2020
    • IF AND Functions (Debtors/Creditors Ageing Report)


Week 2

    Fundamentals of Financial Modeling & Best Practices

    • Overview of Financial Modeling
    • Understanding Financial Statement Analysis
    • Learning Financial Modeling best practices
    • Financials Model Setup
    • Analysis Model
    • Data Table What-IF
    • NPV, ROI & Payback period
    • Comparison of two projects for financial decision making


    Financial Statement Projections Model & Visualization

    • Financial Model preparation and integration
    • Income Statement
    • Balance Sheet
    • Cash Flow Statement
    • Payroll


Price for an Individual
Rs 15,000 per person
Group of Two
7% Discount for a group of two people
Rs 13,950 per person
Group of Three
10% Discount for a group of Three people
Rs 13,500 per person
Group of Four
15% Discount for a group of four people
Rs 12,750 per person


Frequently Asked Questions

Who should attend the course?

Students and working professionals with the background of Finance!

Who are the Instructors?

What is the timing of the course?

Duration: 2 Weeks

Class Days: Monday – Friday

Timings: 07:00 PM to 09:00 PM

Can I get a job after this course?

Since our instructors are industry experts so they do train the students about practical world and also recommend the shining students in industry for relevant positions.

Will I get a certificate after this course?

Yes, you will be eligible for IFA-UK Certification at the completion of this course and you can get the certificate after paying £50 as a fee required by the IFA-UK Institute.

How much hands-on will be performed in this course?

Since our courses are led by Industry Experts so it is made sure that content covered in course is designed with hand on knowledge of more than 70-75 % along with supporting theory.

What are the PC requirements?

For this Professional course, you need to have a PC with minimum 4GB RAM.

How this course will be helpful for students?

This hands-on program will prepare and equip students with the in-demand skills required to become a successful Analyst – BI and start a career in the growing and lucrative field of Financial Modeling!

How this course will be helpful for Working Professionals?

This course will equip working professionals with the best practices and actionable knowledge needed to put you and your organization aligned with advance cloud services.

Reserve your Seat

You can reserve your seat  by filling the form below!


    Are you a: 
    StudentWorking Professional