Advanced Excel – Financial Modelling

Overview Schedule Dates Course Content Faqs

Course Overview

Financial modeling is one of the most sought-after skills required in today’s corporate world. The Advanced Excel with Financial Modeling course delivers a 360-degree insight into Advanced Excel and Financial Modeling techniques. This course focuses on practical learning of the concepts and trains professionals to construct consistent and realistic financial models in MNCs as well as small businesses using MS Excel.

Learning Options

Online Instructor Led

Learn from the comforts of your home/office with our expert trainers via online platforms.

Classroom Training

Face-to-face physical classroom training with max interactions at our 5* training venues.

Onsite Training

Learn in your own environment from our expert trainers for maximum impact.

Overseas Training

Choose your desired country for learning with our expert trainers.

Target Audiance

Business Analysts
Management Consultants
Project Managers
Corporate Finance Professionals
Budget Analysts

Schedule Dates

Advanced Excel – Financial Modelling

21 May 2024 - 22 May 2024

Advanced Excel – Financial Modelling

21 August 2024 - 22 August 2024

Advanced Excel – Financial Modelling

21 November 2024 - 22 November 2024

Advanced Excel – Financial Modelling

24 February 2025 - 25 February 2025

Course Content

What is Excel
Data Modeling

Future and present values in Excel
Calculating the rate of return of an investment with the IRR function
Calculating a complete loan schedule in Excel
Date functions in Excel

What are Pivot Tables
Applying Pivot Tables

Data visualization in Excel

Trend Analysis in Excel
Comparative Analysis in Excel
Value-based analysis in Excel
Correlation analysis in Excel
Time series analysis in Excel
Regression analysis in Excel

Financial modeling basics
What is a financial model?
Financial modeling – worst practices
Financial modeling – best practices
Financial modeling – The types of models
Financial modeling: level of detail in a model
Financial modeling: Forecasting guidelines
Building a complete model – Important consideration
Modeling the Income statement
Modeling the Balance sheet

The main value drivers when valuing a business
How to calculate Unlevered Free Cash Flow
How to calculate Weighted Average Cost of Capital (WACC)
How to calculate cost of debt
How to calculate cost of equity
Forecasting a firm’s financials
How to obtain Terminal Value
Discounting cash flows
How to obtain Enterprise and Equity Value
Mergers & Acquisitions

Capital budgeting

FAQs

Strong financial modeling skills are highly sought-after in various finance and business roles. This course can enhance your employability and earning potential.

Many providers offer additional resources such as practice exercises, case studies, and online communities to support your continued learning.

You’ll gain advanced skills in building robust and flexible financial models in Excel, covering topics like forecasting techniques, advanced functions, scenario analysis, data validation, and best practices.