Gain the Latest Sophisticated Techniques to Improve Usability, Reliability and Your Efficiency in Your Financial Models

Advanced Financial Modelling & Valuation Training Course

This course is designed to provide you with a range of techniques, ideas, concepts and methodologies that will take your modelling skills to the next level.

EH Free Account Signup

Have a question? Email us at: support@ethanhathaway.com or visit the help center.

Available as:

Self-Study Online
In-House Customised/Bespoke

Trusted By

Take Your Financial Modelling Skills to the Next Level

This course is designed to provide you with a range of techniques, ideas, concepts and methodologies that will take your modelling skills to the next level.

How You Benefit from this Course

Ethan Hathaway Advanced Financial Modelling Digital Badge of Completion
Ethan Hathaway Advanced Financial Modelling Digital Badge of Completion – Earn this when you complete the course!
  • To provide experienced modellers with a deeper understanding of financial modelling methodologies, techniques and approaches.
  • To provide you with a structured approach to modelling that generates models that are reliable, robust, controlled, extendable and easy to use.
  • To provide solutions to common modelling problems.

BONUS: As an attendee, you also receive:

  • Worked examples
  • Suggested Solutions
  • Reference Materials
  • Large variety of templates

The speaker has successfully made the course fun and meaningful.

The speaker has successfully made the course fun and meaningful.

Lot of discoveries can relate things effectively…what I liked most about this course was the discovery of significant functions of Excel which was previously I have no interest in making use of it.
A.A.
DHL, Singapore

Advanced Financial Modelling Course Agenda Highlights

Part 1: Building Blocks

Financial Modelling in Excel

  • Key functions used in modelling
  • Advanced range names, including formulas and naming conventions
  • Pivot Tables
  • Scenarios, sensitivity, data tables
  • Best practice guidelines and spreadsheet modelling standards

Financial Modelling Overview

  • Modelling fundamentals
  • Steps in model building
  • Key concepts

Part 2: Advanced Modelling Techniques

Model Components

  • Capital budgeting & depreciation modelling
  • Debt modelling
  • Capital Structure
  • Ratio analysis
  • Tax considerations
  • Inflation
  • Reporting considerations: changing timescales, changing currencies, units

Specific Purpose Modelling

  • Company valuation & financial statement simulation
  • Project evaluation
  • Mergers & Acquisitions
  • Divestiture
  • High-growth companies

Part 3: Advanced Modelling Applications

  • Multi-variable Monte Carlo Simulations
  • Introduction to VBA Macros: useful functions and macros, and how to apply these to models
  • Working with other people’s models
  • Tracking and recording model changes

***Note: the online distance learning version may vary from the live course.

EH Free Account Signup

Have a question? Email us at: support@ethanhathaway.com or visit the help center.

Who Will Benefit

  • Accountants
  • Corporate financiers & Investment bankers
  • Financial Controllers
  • Finance staff
  • Commercial bankers
  • Business and financial analysts

This is an intermediate to advanced level course.

This is good continuation for past attendees of the Financial Modelling in Excel course

What Clients Say About Our Training

A lot of fun exercise to help me understand about finance matters.

A lot of fun exercise to help me understand about finance matters.
G.G.
Chevron, Singapore

I learned more than I expected…

I learned more than I expected and impressed with our instructor’s expertise.
A.C.
Project Director, APCOL Pte Ltd, Singapore

Interactive sessions & extremely knowledgeable instructor…

Jeff has been an excellent trainer & somone who is approachable & most willing to share & help even beyond the scope of the course…Interactive sessions & extremely knowledgeable instructor…This is a good course definitely showing a glimpse of how much Excel can provide.
K.J.
Borouge, Singapore

I’m impressed by the instructor’s professionalism & clear explanations of functions that I’ve never heard of that I could use

There were a lot of practical examples that could be brought into my daily work. Good & clear explanations of difficult concepts…I’m impressed by the instructor’s professionalism & clear explanations of functions that I’ve never heard of that I could use.
K.S.
DHL, Singapore

There are lots of exercise so that it makes me understand more about formula & model.

There are lots of exercise so that it makes me understand more about formula & model.
M.K.
Finance, Chevron Energy Development, Thailand

The course well-fit my knowledge & met my expectation perfectly.

The coverage of the syllabus & the material is well-fit. A very good introduction to Financial Modelling. The course well-fit my knowledge & met my expectation perfectly.
C.A.
Corporate Finance, CLP Ltd, Hong Kong

Even more interested to discover more.

Concrete examples. Small group. Good interaction with the speaker…Impressions after attending the course: Positive. Even more interested to discover more.
C.T.
Natixis, Singapore

I like the workshop as Speaker willingly and unselfness to share his knowledge and skills.

I like the workshop as Speaker willingly and unselfness to share his knowledge and skills.
L.D.
Borouge, Singapore
EH Free Account Signup

Have a question? Email us at: support@ethanhathaway.com or visit the help center.

What You Get When You Upgrade to EH+:

On-Demand Premium Courses

Access to our library or Premium Self-study online courses include on-demand video and/or text-based lessons with 6 to 12 months access (depending on your plan).
Go at your own pace.

Digital Downloads

Courses include digital resources, such as course slide decks, additional reading, exercises & more

Access Multiple Courses for the Price of One

You’re essentially getting access to an entire library of premium courses for the price of one.

Certification Exams

Your membership includes access to ALL eligible certification exams.

Anywhere Access

Access the course(s) anywhere with an Internet-enabled device. (*Our own mobile app is in the works)

Digital Certificates

Upon successful course completions and/or certification exams, you receive a digital certificate of completion to download & print.

Members-Only Discounts

EH+ exclusive discounts on special virtual and in-person events and courses.

AI Learning Assistant

(Coming soon) Specially tuned AI-learning assistants & tutors to help you achieve more.

Practical

Our training courses are designed to be practical, not just theoretical or academic.

Designed for Busy Professionals

Courses are designed for the busy working professional.

Sneak Peak Inside the Online Learning Portal

Have a look inside the online learning portal to get an idea of what it’s like.

Why Ethan Hathaway

There are LOTS of training providers in the market, so why choose Ethan Hathaway?

Ethan Hathaway has established itself as a reputable training partner for over 16+ years to top companies all over the world.

Our philosophy is to make YOU as valuable as can be both in your career and your employer.

Start Gaining High-Value Skills

Get Trained by Global Experts for a Fraction of What It Would Normally Cost.

*All prices listed in USD

eh free

Free

  • Unlimited access to FREE online course library
  • Free sample lessons of Premium Online Courses
  • No registration or login required
  • No credit card required
  • No Premium Online Course access
  • No Certificate of Course Completions
  • No Certification exams
  • No discounts
  • No access to AI Learning Assistant & Tutor
EH Free Account Signup
EH+ Annual – 2 months free –
BEST VALUE
497

per year (billed annually)

Best Value

  • 12 months access to ENTIRE Premium Online Course Library
  • 2 months bonus access
  • Includes ALL certification exams
  • Includes Digital Certificates of Course Completion
  • Member discounts on special training events (virtual and in-person)
  • AI Learning Assistant & Tutor (coming very soon)

EH+ 6 MONTHS ACCESS

297

per 6-months (billed semi-annually)

  • 6 months access to ENTIRE Premium Online Course Library
  • Includes ALL certification exams
  • Includes Digital Certificates of Course Completion
  • Member discounts on special training events (virtual and in-person)
  • AI Learning Assistant & Tutor (coming very soon)

FAQ

The quickest way to level up, become smarter & add value to your career in business

Join Over 17,764+ Smart & Savvy International Business Professionals

Signup for the FREE weekly newsletter: The Essential Edge.

  • Productivity & how to save your time
  • Leadership & Management
  • Business strategy
  • Selling

A weekly non-stuffy 2 minute read.

Get the FREE Report: How to Make Better Business Decisions when you sign up for the Essential Edge newsletter.

Essential Edge Step 1 optin

The Essential Edge is brought to you by Ethan Hathaway, the world’s premier Learning as a Service (In-Person & Online Training) Provider to International Business Professionals.

The quickest way to level up, become smarter & add value to your career in finance

Signup for the FREE weekly newsletter: The Finance & Money Edge.

Get smarter about:

  • Business Finance
  • Fintech
  • Financial Risk Management
  • Data Analytics
  • Banking

A weekly non-stuffy 2 minute read.

Finance & Money Edge Step 1 optin
Scroll to Top