Corporate training in the Gulf, London, Europe & Asia since 2015
+44 7462 102778[email protected]WhatsAppالعربية
Enquire now
CoursesSubjectsVenuesIn-House TrainingWhy ARUKContactالعربيةEnquire now
AF-004

Advanced Financial Modelling with Excel

Intensive 5-day course · English, Arabic & European languages

Financial modelling in Excel is the focus of this five-day programme for finance professionals and people responsible for estimating sales, costs, risks and economic variables. Delegates build optimisation models, use statistical forecasts and examine derivatives. Oil and gas cases connect the modelling work with investment risk and decisions about growth.

Classroom

Public courses in our cities

  • 19–23 Oct 2026Abu Dhabi£4,200 + VAT
  • 2–6 Nov 2026Jeddah£4,200 + VAT
  • 16–20 Nov 2026Vienna£3,400 + VAT
  • 7–11 Dec 2026Barcelona£3,080 + VAT
  • 21–25 Dec 2026Muscat£3,080 + VAT
  • 11–15 Jan 2027Amsterdam£3,400 + VAT
Show 23 more dates
  • 25–29 Jan 2027Muscat£3,080 + VAT
  • 8–12 Feb 2027London£3,360 + VAT
  • 22–26 Feb 2027Casablanca£2,280 + VAT
  • 1–5 Mar 2027Istanbul£2,280 + VAT
  • 15–19 Mar 2027Manama£3,080 + VAT
  • 5–9 Apr 2027Amman£3,400 + VAT
  • 19–23 Apr 2027Vienna£3,400 + VAT
  • 3–7 May 2027Barcelona£3,080 + VAT
  • 17–21 May 2027Madrid£3,400 + VAT
  • 14–18 Jun 2027Amsterdam£3,400 + VAT
  • 28 Jun – 2 Jul 2027Berlin£3,400 + VAT
  • 12–16 Jul 2027London£3,360 + VAT
  • 26–30 Jul 2027Milan£3,400 + VAT
  • 2–6 Aug 2027Istanbul£2,280 + VAT
  • 16–20 Aug 2027Malaga£3,080 + VAT
  • 6–10 Sep 2027Sarajevo£3,400 + VAT
  • 20–24 Sep 2027Vienna£3,400 + VAT
  • 4–8 Oct 2027Barcelona£3,080 + VAT
  • 18–22 Oct 2027Dubai£4,200 + VAT
  • 8–12 Nov 2027Amsterdam£3,400 + VAT
  • 22–26 Nov 2027Riyadh£4,200 + VAT
  • 13–17 Dec 2027London£3,360 + VAT
  • 27–31 Dec 2027Doha£4,200 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Can't make these dates? We can run this course for your team on dates that suit you. Ask for custom dates · In-house options

Online (live)

With a trainer, on dates to suit your team

This course can be taught live online by a trainer, in English, Arabic or any European language, for one person or a whole team.

£1,850 + VAT

Group discount: 2 delegates 20% · 3 delegates 35% · 5 or more delegates 50%

Special requests

Tailor this course

Pick what you want changed and we’ll come back with a proposal and price.

Special request

Advanced Financial Modelling with Excel

What would you like to change? (pick any)
or

Course overview

Oil prices and movements in exchange or interest rates affect financial estimates. Delegates use Excel to examine these variables alongside sales, costs and risk, building their finance knowledge through cases drawn from oil and gas and their own organisations. The five-day course develops models intended for use in business decisions.

Forecasts supply the model's inputs. Work on estimation uses statistical techniques, including regression and exponential smoothing, before delegates simulate changes to payables and receivables within a financial optimisation model. Sessions on derivatives examine their use in managing volatile oil prices and exposure to interest and exchange rates.

Growth receives a separate day's attention, including the risks of overtrading and the effects of acquisitions or mergers on earnings and share values. A final case brings together the techniques from days 1 to 4. Delegates build a model for their organisation, present it and test it before considering improvements and reporting the resulting decisions.

Course objectives

By the end of the course, delegates will be able to:

  1. Use Excel analysis to improve financial decisions
  2. Build advanced models for financial applications in Excel
  3. Analyse financial information using current modelling tools and good practice
  4. Use models when managing sales, costs and financial exposure
  5. Develop advanced models and report on their practical use

Who should attend

This course suits:

  • Professionals needing a greater understanding of finance
  • Professionals needing to develop advanced financial modelling skills
  • Decision-makers who use or are impacted by financial models
  • Those responsible for managing finance
  • Those responsible for estimating sales, costs, risks, and economic variables

Training methodology

  • Cases from oil and gas and delegates' organisations provide practical modelling problems.
  • An experienced financial practitioner guides discussions and exercises, including workplace issues brought by delegates where appropriate.
  • Delegates build models for organisational use with Excel and current financial analysis techniques.
  • Printed and electronic supporting material explains the financial techniques and their modelling applications.

Daily agenda

  1. Day 1

    Advanced Modelling Skills with Excel

    • Moving from basic to advanced modelling
    • Spotting financial applications for modelling within the oil and gas sector
    • Excel's advanced financial applications
    • Using advanced financial analysis tools in Excel
    • Aiding financial analysis with graphs and charts
    • Modelling best practices in Excel
  2. Day 2

    Estimation Models - Income, Costs, Risks & Economic Variables

    • Estimating costs via incremental, inflation, PERT, and supply and demand factors
    • Statistical forecasting methods in Excel including time series analysis, exponential smoothing, correlation, and regression
    • Measuring risk with probability analysis, correlation, and Beta
    • Statistical models for forecasting oil prices
    • Managing and measuring investment risk
    • Forecasting interest and exchange rates using historical data, Interest Rate Parity Theory and Purchasing Power Parity Theory
  3. Day 3

    Developing an Advanced Financial Optimisation Model

    • Building the financial model with costs and economic variables estimated on Day 2
    • Running simulations on changes to costs and accounts payable
    • Running simulations on changes to sales volume, oil price, and accounts receivables
    • Forwards, options, futures, and swaps as financial derivatives
    • Managing oil price volatility, interest rates, and exchange rates with derivatives
    • Managing change by implementing policies
  4. Day 4

    Models to Assess Growth Strategies

    • Methods for evaluating growth strategies
    • Simulating growth strategies with models
    • Understanding the dangers of overtrading
    • Working capital impacts
    • Assessing effects on financial gearing and borrowing
    • Modelling how mergers and acquisitions impact share price, market value, earnings, and EPS
  5. Day 5

    Modelling Best Practices

    • Case study combining skills from Day 1 through Day 4
    • Creating an advanced financial optimisation model for the delegates' own organisation
    • Presenting the created model
    • Testing the model's limits
    • Making improvements to the model
    • Reporting and making decisions

Certificate

Every delegate who completes the course receives an ARUK Training Certificate of Attendance.

Frequently asked questions

How do I register?

Choose a date and city in the schedule and press Register, or send us an enquiry. Our team confirms your place and sends an invoice.

Are fees shown with VAT?

Fees are shown per delegate and exclude VAT, which is added to the invoice where applicable.

Can this course be delivered for our team only?

Yes. Any ARUK course can be delivered in-house at your premises, in a meeting room we book for you, or 1-to-1.

Is this course available online?

Yes. We run it live online with a trainer, on dates that suit your team, for £1,850 + VAT per delegate.

Is there a group discount?

Yes. 20% for 2 delegates, 35% for 3 delegates and 50% for 5 or more delegates on the same course.

Can the course be delivered in Arabic or another language?

Yes. Our courses can be delivered in English, Arabic or any European language, by a trainer who teaches in that language. Mention your preferred language when you register or enquire.

What certificate will I receive?

An ARUK Training Certificate of Attendance.

Related courses

Register

Advanced Financial Modelling with Excel

Key booking terms (read before you register)
  • The full fee is paid in advance, before the course starts.
  • Cancel in writing 30 or more days before the start date (45 for in-house) for a refund. Later than that, the full fee is payable.
  • No refund for non-attendance or partial attendance.
  • Places are for the named delegate only; another person cannot attend instead.
  • Moving to another date or city is only possible if ARUK agrees in writing.
  • Travel, accommodation and visas are your responsibility. A refused visa does not change the cancellation terms.

booking terms and conditions

Get a quotation

Advanced Financial Modelling with Excel