Learn from the Scholars. Become a Pro

Upcoming Webinars


PMP certification Guide
Mr. Whiz Chua



Mr. Whiz Chua has worked as a Trainer, Teacher, Speaker, Consultant, Manager, Managing Partner, Engineer, andAnalyst at top reputed companies. He has more than 7 years of experience in Quality Management, Project Management, Human Resource Management, International Real Estate, Facility Management, Energy Management, Service Management, IT Security &Networking, and System Engineering. With deep knowledge in Financial Modeling, he has trained a lot of participants who are now working at a highly designated post in MNC’s. Mr. Whiz Chua himself is the chairman of Strategy and Innovation Committee in IFMA Singapore and provides training in Financial Modeling.

Course Benefits

  • You’ll be showered with better career prospects and higher pay packages.
  • The course also helps you prepare for exams conducted by government organizations and financial institutions.
  • You will learn how to create your own Financial Model.
  • Banks use Financial Modeling for disbursement of loans. The course will hence help enhance your chances of getting an opportunity to work in the banking sector.

Course Overview

Do you know how to put data to work? What if we tell you that numbers in a spreadsheet can predict the present and past business activities? 
Only a Financial Model Expert can understand how to use data for forecasting the future activities of a business. And, if you want to be the one, get enrolled in ScholarsPro Financial Modeling Training course and gain expertise from industry experts.
This training course will help you learn the essential elements and processes of quantitative modeling through a series of lectures and assignments. At the end of this training, you will see yourself creating your own financial models with much ease and efficiency. 


The course covers following modules:
  • Financial Modeling Principles
  • Valuation Principles
  • Advanced Functions, Tools, and Charting
  • Using Macros & VBA for Financial Modeling

Who should join Financial Modeling Certification Training Course?

  • Individuals engaged in professions like Investment, Equity Research, Credit, Project, Mergers & Acquisitions, Corporate Finance, Critical Thinking, and Analytical Skills.
  • CA, CFA and FRM’s will also benefit from the Financial Modeling Course
  • Graduates, Post-Graduates, MBA’s can enhance their skills with this training course
  • The program is also suited for commerce students and professionals working on business plans, MS-Excel, and other related fields

Pre-requisites/ Eligibility Criteria

Any Individual having a strong will to work in the Finance sector can take up this course. You need not satisfy any specific academic background to undergo this training session. All you need to attend the training program is workingknowledge of MS-Excel, creating balance sheets, and related functions.

Course Contents

Day 1: Financial Modeling Principles
Using MS-Excel for Financial Modeling
Here we will learn how to use MS-Excel in Financial Modeling. Using Excel Tools, shortcuts, Formulas, Arrays and Functions. Editing and custom formatting in Excel.
Best Practices to be used in Financial Models
Learn how to build a Financial Model efficiently using advanced techniques and tips from our mentors. Know the best practices to be used to do your task faster.
Modeling Growth Drivers
Learn how to identify revenue drivers and components which the driver should hold. Understand the components and factors of growth drivers
Depreciation, Cost Drivers, Asset and Debt Schedules
Understanding the assets that caused depreciation and setting up the schedule. Know what is a debt schedule and its components in Financial Modeling
Day 2: Valuation Principles
Projecting cash flow statement
Understand the cash flow forecast to know that a business has the cash to run it or need to expand it. How to create cash flow worksheet and record it
Handling circular references 
Learn how to find, enable, use, allow or remove circular references. Understanding what are direct circular references and indirect circular references.
Financial ratio analysis
How to evaluate financial ratio analysis to know the financial condition of the organization, comparing the statements of organization and know about liabilities and assets
Valuation using DCF & Comparables
Compare which one is better among Discounted Cash Flows (DCF) and Comparables to evaluate future cash flows. Variations of DCF Model and advantages of comparables and DCF
Scenario analysis and Building valuation dashboards 
Analyzing the current scenario of company and prediction of its Financial Status. Know how to create reports and build valuation dashboards.
Q & A
Question and answer session on the topics discussed in Module
Day 3: Advanced Functions, Tools & Charting
Learn the techniques by which you can create financial models easily and in an effective manner. You will be introduced to new concepts of MS-Excel and its functions
Advanced Tools in Excel for Auditing Financial Models
Learn how to use Excel Formulas and building block-functions in Excel.  Understand how to search and retrieve data from multiple sheets with Lookup Functions.
Mastering Financial Functions 
You will get to know how to use functions in MS-Excel sheet for financial purpose. Learn usage of VLOOKUP, MATCH, INDEX, COUNTIF, SUMIF and AVERAGEIF functions.
Advanced Charting Techniques in Excel
Learn the advanced charts to be used to create financial Model. Advance Charting includes Chart With-in Charts, Line Charts with tolerance Lines, Sunburst Chart etc.
Day 4: Using Macros & VBA for Financial Modeling
Implementing Monte Carlo Simulation
We will learn how to calculate Monte Carlo Simulation method in Excel to know risk analysis in finance, project management, energy, manufacturing, engineering, research and development.
Learn modeling of commodity prices by various methods and concepts of volatilities, trailing volatilities, interconnections & relationships
Foreign Exchange & Corporate Bonds
Know about Foreign Exchange units in finance and corporate bonds
Q & A
Question and answer session on the topics discussed in Module and further opportunities in Financial Modeling.
Financial Modeling Certification Training Course will enable you to master Excel Skills and Create Financial Models


Will I receive any certificate?

Yes! Once you complete the course, you’ll be provided with a Course Completion Certificate from ScholarsPro.

How can my doubts and queries be resolved?

You can clear your doubts on a weekly basis from your mentors. If you have any queries regarding the course, you can also drop us a mail or call our support team for any assistance.

What will I learn from this course?

You will start with learning MS-Excel functionalities followed by creation of a Financial Model based on real-time situations.

What are the career opportunities upon pursuing Financial Modeling Certification Training Course?

Individuals, who are confident enough to create a Financial Model on their own, can work in finance sector like banks and companies as a Project Manager.

What is the duration of Financial Modeling Certification course?

The sessions are conducted over a period of 4 days, where you’ll be taught about all the essential concepts and lessons required to effectively create a Financial Model.

Our members make ScholarsPro community

I liked the pace and the methodology. However, it would be better if could see some of the terms explained in greater detail.
I joined this course because I was working with a project related to Finance. Since, I was new to the advanced charting tools, I took help of this course and it did help me.
I feel obliged to review this course. Great content and methodology. I see myself a master of Finance tool and techniques. Thank you guys for making me a pro in my field.
I want to learn DCF and this course helped me in doing that. I get to learn about how financial statements are related. Everything went smoothly.
Learned new techniques, lookup functions, charting and much more in the most lucid manner. Thank you guys for the support.
I knew nothing when I joined this training and now I am able to use Macros and VBA in real time situations. All thanks to the training that I received from Scholars Pro.
Insightful course! I would strongly recommend it to all. Excellent work you do Scholars Pro.

Enterprises we helped to UPSKILL

Financial Modeling Certification Training Course
4.1stars based on3800Learners
FB Twitter YouTube LinkedIn Google+