Financial Modelling in Excel Training Course (2-5 days)

This financial modelling course covers Financial Modelling Fundamentals plus Advanced Excel for Financial Modelling.

Contact Us Today

Master Financial Modelling and Advanced Excel Techniques for Real-World Applications

Our Financial Modelling in Excel Training Course is designed to equip you with the essential skills and knowledge needed to build robust and flexible financial models and solutions to real-world financial challenges. Gain a comprehensive understanding of financial modelling and valuation concepts, learn efficient Excel tools, and develop the expertise to design reliable financial models.

What you get from this course

  • An excellent working knowledge of financial modelling functions in Excel that allow you to efficiently create robust and flexible models.
  • A sound understanding of financial modelling and valuation concepts.
  • Practical experience in designing solutions to real-world financial modelling challenges by building financial models in Excel.
  • A solid foundation for Excel-based financial modelling.
  • Excel tools and techniques that are essential for modelling to make your models robust,
    user-friendly, and efficient.

Agenda Highlights

Excel is the tool of choice for most financial modellers so before we start building financial models, it’s critical that we have a good understanding of the key functions and tools in Excel that can help us build models that are robust, easy-to-use, and flexible.
Here are just some of the areas we cover in our in-depth, hands-on workshop:
  • Working with large data sets
  • Summarising and aggregating data
  • Extracting data that matches criteria using flexible formulas
  • Error handling
  • Ways of improving structure
  • Techniques for keeping formulas consistent yet flexible
  • Combining and splitting cells according to the content they contain
  • Advanced techniques for creating automatically expanding charts and ranges
  • Introduction to macros & when to use these

We then apply and practise these functions during the remainder of the course.

Our financial modelling course provides a sound understanding of both the principles of financial modelling and the practical application of these to real-world situations by using Excel to build financial models.

The course builds upon the financial modelling principles and practices learned, to apply these to company or project valuations. In this, participants improve their mastery of valuation principles and concepts, and learn how to apply these in real-life situations.

Finally, participants will receive training in how to both detect and prevent errors from occurring.

Everyone’s models are different. As such, participants are encouraged to bring along their own financial models to obtain assistance, ideas, guidance and suggestions from the trainer in private.

This is a key step in applying the concepts learned on the course to improve real-life models so please take the opportunity to draw on the trainer’s experience and expertise!

Pre-requisites

Although not mandatory, attendees will get a lot more out this course if they complete some online training in Excel functions before attending. We have partnered with Excel Off The Grid and their Excel Academy to provide high-quality, low-cost online training as good preparation for this course.

Full course outline

  • Financial modelling concepts: Aims, design, structure and development
  • Corporate finance and valuation concepts
  • Introductory Concepts
    • Cash vs Profit
    • Time Value of Money
    • Cost of Capital
    • Risk, return & value
    • Scenario Analysis

  • Common difficulties, problems and limitations with financial analysis
  • Defining the decision
  • Availability of information
  • Defining model scope
  • Knowing the limitations of financial analysis
  • Information overload
  • Financial Forecasting
    • What is it?
    • Steps involved
    • Best practices & financial modelling standards

  • Common financial / investment decisions
  • Understanding the Time Value of Money concept
  • Understanding Discounted Cash Flows
  • Evaluation of different methodologies (including NPV, IRR, Payback Period)
  • Introduction to valuation concepts including NPV
  • Identifying & dealing with IRR difficulties

  • Reviewing valuation concepts
  • Valuation methodologies (including evaluation of different methodologies)
  • Dealing with common valuation issues
  • Compare & contrast alternative valuation methods to know when to apply each

  • Overview of DCF methodology
  • The role of Cash Flow Forecasts
  • Cost of Capital

  • Performing a Ratio Analysis
  • Understanding Profitability Ratios
  • Interpreting Liquidity and Solvency Ratios

  • Overview & Objectives
    • Defining the scope of your model
    • Objectives: What are the aims of the model?
    • Understanding model limitations
  • Development and structuring
    • Planning the financial model
    • Ensuring the model structure matches the objectives
  • Incorporating best practice techniques into your models
  • Compare a selection of best practice guidelines/standards

  • Setting Up the Work Book & structure
    • Time scale
    • Separate business areas
    • Timing and frequency formats
    • Data Sources
  • Managing the Input Section
  • Building the Calculation Section
    • Building the C/Flow Forecast
    • Line by line build-up of cash flows
    • Cap Ex and Op Ex
  • Presenting Model Outputs
    • Key Financials
    • Summary of model data
    • Dashboards & Graphs
    • Valuations & terminal values

  • Balance sheet, Income statement, cash flow
  • Dealing with interest circularity
  • Using ratios to produce financial forecasts
  • Debugging a 3-way model

  • Typical Bank Covenants & Ratios
  • The Importance of Capital Management
    • Why it is important (cost of debt vs equity)
    • Defining your optimal capital structure
  • The Effect of Capital Structure
    • Understanding its effects on risk

  • Sensitivity
    • Identifying key variables for sensitivity
    • Building in sensitivities
    • Displaying the results of sensitivity analysis
  • Scenarios
    • How to run multiple sets of inputs through a single calculation engine
    • Building, managing and extending a scenario manager that is far better than Excel’s
  • Introduction to Monte Carlo simulation: how to apply these techniques in practical ways to real-life financial models

  • Checking outputs for consistency
  • Techniques for building checks & balances
  • Model audit & review
  • Automated spreadsheet auditing software tools: role, purpose & limitations, demonstration
  • Documentation
  • Use of financial modelling software: when is it useful or not useful?

The last part of the course is a coaching session where we work individually with each person to help them apply what they’ve learned to the models they’re currently working with.

Although this session is optional, we encourage participants to take advantage of this if they can as it’s often when participants get the greatest value from the course because they’re gaining real-world experience by applying this to their own models.

It also reinforces the course by allowing them time to immediately practise what they’ve learned.

Who Should Attend

  • Business & Finance Analysts
  • Finance Managers
  • Investment Managers
  • Investment Analysts
  • CFO’s
  • Financial Modellers
  • Project Managers
  • Project Accountants
  • Investment & Corporate Bankers
  • Corporate Finance Managers
  • Finance Professionals
  • Accountants

Delivery Options

In-house

All courses are available for in-house training, providing flexible options to meet your needs wherever you are – Perth, interstate, or internationally. Our in-house courses are designed to maximise value with flexibility, tailored content, and cost savings for your team.

Learn More

Virtual Training

Our virtual training options (in-house training only) bring the same high-quality, live, instructor-led courses directly to your team, no matter where they are located. Our virtual training features the same level of interaction as our in-person sessions, while providing the convenience of learning from any location. This option is ideal for interstate and international clients.

Learn More

Public Courses

Our public courses are located primarily in Perth (with options for interstate and international participants), providing individuals or smaller teams with the opportunity to join our comprehensive training sessions alongside other industry professionals.

Learn More

Upcoming Course Dates

Power BI Essentials (2 days) Face-to-Face Training

February 11, 2025 @ 8:30 am - February 12, 2025 @ 4:30 pm

A$1,499.00 – A$1,699.00

Our Public courses are aimed at smaller groups of 3 – 8 people so that there is more opportunity for the instructor to assist on a 1-1 basis and discuss the attendee’s specific real-world scenarios.

NOTE: For Public Courses a minimum of 3 attendees must have signed up 4 weeks in advance of the course otherwise the course will be postponed, and full refunds offered. The 3rd day option also requires a minimum of 3 attendees to proceed

Why Learn From Access Analytic

Practical

Highly experienced facilitators who actively and regularly consult with clients.

Applicable

Apply what you learn to your job to further your career.

Hands-on

The course is designed to provide maximum hands-on experience.

Passionate

Our facilitators love this subject!

Clear

We specialise in translating complex subjects into concepts that are easy to understand.

On-going help

You can always email the facilitator with any questions.

Comprehensive course notes

Useful working document to support your learning.

Networking

Meet industry peers and hear how they approach this subject.

Our Course Facilitators

Jeff Robson

Masters (Applied Finance), Bachelor of Commerce (Accounting & Information Systems), Certified Information Systems Auditor (CISA), Fellow of the Australian Institute of Management (FAIM), Fellow of the Financial Services Institute of Australasia (F Fin), Member of the Australian Institute of Company Directors (MAICD), Microsoft Excel Expert, International Presenter

Read More

Wyn Hopkins

Microsoft MVP, Published Author of “Power BI for the Excel Analyst”, B.Sc. (Hons) Accounting & Financial Management

Wyn has been awarded MVP status by Microsoft every year since 2017 and is the author of the book “Power BI for the Excel Analyst”.

YouTube content creator:  over 5.5 million views and 95,000+ subscribers.

Read More

Yury Tokarev

PhD (Finance and Economics), Chartered Accountant with the Australian Institute of Chartered Accounting (CA), Bachelor of Business (Finance and Economics), Microsoft Certified Excel Expert (MCEE)

Read More

Our Clients

Client testimonials

We are thrilled to have helped hundreds of businesses in Perth and worldwide over the years.

Other courses you might be interested in

Maximising your excel productivity

Power Query Booster

DAX Booster for Power BI

Power BI Essentials

Power Query in a Day

Power Query & Power Pivot for Excel

Advanced Budgeting & Forecasting

Financial Modelling in Excel Training Course

Learn from highly qualified finance professionals with international experience

Reach out to the Access Analytic team Monday to Friday on (08) 6210 8500 or submit your contact information and we will be in touch.

Get Ahead of the Game – Book Your Training Now!

Consent