ICAS

Quicklinks

  1. About Us

    Find out about who we are and what we do here at ICAS.

  2. Find a CA

    Search our directory of individual CAs and Member organisations by name, location and professional criteria.

  3. CA Magazine

    View the latest issues of the dedicated magazine for ICAS Chartered Accountants.

  4. Contact Us

    Get in touch with ICAS by phone, email or post, with dedicated contacts for Members, Students and firms.

Login
  • Annual renewal
  • About us
  • Contact us
  • Find a CA
  • Advantage
  1. About us
    1. Governance
    2. ICAS Strategy 2030
  2. Members
    1. Become a member
    2. Newly qualified
    3. Manage my membership
    4. Benefits of membership
    5. Career support
    6. Mentoring
    7. CA Wellbeing
    8. More for Members
    9. Area networks
    10. International communities
    11. Get involved
    12. Top Young CAs
    13. Career breaks
    14. ICAS podcast
    15. Newly admitted members 2023
  3. CA Students
    1. Student information
    2. Student resources
    3. Learning requirements
    4. Learning updates
    5. Learning blog
    6. Totum Pro | Student discount card
    7. CA Student wellbeing
  4. Become a CA
    1. How to become a CA
    2. Routes to becoming a CA
    3. Find a training agreement
    4. Why become a CA
    5. The CA qualification
    6. Accredited qualifications and exemptions
  5. Employers
    1. Train a Chartered Accountant
    2. Resources for Authorised Training Offices
    3. Professional entry
    4. Apprenticeships
    5. Learning redefined
  6. Find a CA
  7. ICAS events
    1. CA Summit
    2. Digital Practice Conference 2023
  8. CA magazine
  9. Professional resources
    1. Anti-money laundering
    2. Audit and assurance
    3. Brexit
    4. Business and governance
    5. Charities
    6. Coronavirus
    7. Corporate and financial reporting
    8. Cyber security
    9. Ethics
    10. Insolvency
    11. ICAS Research
    12. Pensions
    13. Practice
    14. Public sector
    15. Sustainability
    16. Tax
    17. Vulnerable persons toolkit
    18. EDI toolkit
  10. CPD - professional development
    1. CPD - Everything you need to know
    2. CPD courses and qualifications
    3. CPD news and updates
    4. CPD support and advice
    5. Career support
  11. Regulation
    1. Complaints and sanctions
    2. Regulatory authorisations
    3. Guidance and help sheets
    4. Regulatory monitoring
    5. ICAS regulatory functions report 2022
    6. Regulation Strategy
    7. ICAS Regulation News
    8. Guidance for audit firms: ISQM(UK)1
    9. Engaging positively with a complaint
    10. What should I do if my client leaves?
    11. Changes to ICAS’ Public Practice Regulations
    12. New AML monitoring regime
  12. CA jobs
    1. CA jobs partner: Rutherford Cross
    2. Resources for your job search
    3. Advertise with CA jobs
    4. Hays | A Trusted ICAS CA Jobs Partner
    5. Azets | What's your ambition?
  13. Work at ICAS
    1. Business centres
    2. Meet our team
    3. Benefits
    4. Vacancies
    5. Imagine your career at ICAS
  14. Contact us
    1. Technical and regulation queries
    2. ICAS logo request

Financial modelling - advanced (and introduction to VBA)

Member price for Online Live: £722.50 + VAT
Non-member price for Online Live: £850 + VAT

Member price for London: £1,360 + VAT
Non-member price for London: £1,600 + VAT

Timing: 9.30am-4.30pm (both days)


London, 14 & 15 December 2023
London, 6 & 7 March 2024 
London, 4 & 5 June 2024

Email BPP to book


Online Live, 14 & 15 October 2024

Book with BPP


Overview

This two-day course is designed for those looking to expand their financial modelling skills. Numerous hands-on practical Excel exercises are used to demonstrate different functionality in a modelling context. The focus is on time-savers and other techniques which will improve the quality of your financial models.

This course aims to consolidate and enhance participants’ knowledge and skills in Excel (and VBA basics), as they apply to financial modelling. It consists primarily of hands-on exercises, with a brief recap of underlying financial theory where appropriate. The aim is to develop delegates’ ability to build models in various situations that are dynamic, error-free, flexible and robust.

Who should attend

This course is for those who already have Excel financial modelling experience and are looking to consolidate their skills as well as learn some more advanced techniques. It is appropriate for those working in corporate finance, consulting, financial planning, financial markets, and for general users of Excel for financial applications.

The course has been developed as a natural follow-on from Financial Modelling - Comprehensive. The VBA section does not require prior experience.

What you will learn

  • Introduction
    • Recap of modelling basics
    • Review and improvement of existing model (exercise)
  • Excel FINANCIAL functionality including IRR, XIRR, PMT, PPMT, RATE and others…
  • LOOKUPS: Advanced uses for Match, Index, Offset, V/H/X Lookup
  • Text features including LEN, MID, FIND, TEXT, VALUE and others….
  • Date and time features including: TODAY, DATE, EDATE, EOMONTH, NOW and others…
  • Array functions: examples, and pros and cons
  • SUMIF: advanced uses
  • Circularity: Finding it, using it, removing it
  • Sensitivity analysis:
    • Watch window, goal seek and solver
    • Switches and scenarios: Data validation and ActiveX controls
    • Data tables: 1 and 2 dimensional
  • Model review, audit, security and protection
  • Introduction to VBA
    • VBA and macros: overview
    • Subroutines vs Functions
    • Recording a simple macro
    • Macro review, edit and debug
    • Triggering a macro
    • User-defined functions
    • Macro to roll-forward a financial forecasting model

Information for Online Live dates

Please read the following guidance carefully, which applies only if you are attending this course online:

  • In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
  • It does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
    • Extend from a computer to a 2nd screen, or
    • Use 2 computers, or
    • Use a tablet for the online classroom and a computer for the Excel
  • Please note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.

Questions?

BPP | Tel: 0330 060 3303 | Email: ldicas@bpp.com

Financial modelling - comprehensive

"This two-day course is designed for finance professionals at an intermediate level or above who need to build, interpret, review…

Valuation techniques (with valuation modelling)

"A two day course which covers the fundamentals of intrinsic (DCF) and relative (multiples) valuation of firms for those with…

Footer links

  • Contact us
  • Terms and conditions
  • Modern slavery statement
  • Privacy notice
  • CA magazine

Connect with ICAS

  • TikTok (opens new window) TikTok Icon
  • Twitter (opens new window) Twitter Icon
  • LinkedIn (opens new window) LinkedIn Icon
  • Instagram (opens new window) Instagram Icon
  • Youtube (opens new window)

ICAS is a member of the following bodies

  • Consultative Committee of Accountancy Bodies (opens new window) Consultative Committee of Accountancy Bodies logo
  • Chartered Accountants Worldwide (opens new window) Chartered Accountants Worldwide logo
  • Global Accounting Alliance (opens new window) Global Accounting Alliance
  • International Federation of Accountants (opens new window) IFAC
  • Access Accountancy (opens new window) Access Acountancy
  • Women in Finance Charter (opens new window) Women in Finance Charter

Charities

  • ICAS Foundation (opens new window) ICAS Foundation
  • SCABA (opens new window) scaba

Accreditations

  • ISO 9001 - RGB (opens new window)
© ICAS 2022

The mark and designation “CA” is a registered trade mark of The Institute of Chartered Accountants of Scotland (ICAS), and is available for use in the UK and EU only to members of ICAS. If you are not a member of ICAS, you should not use the “CA” mark and designation in the UK or EU in relation to accountancy, tax or insolvency services. The mark and designation “Chartered Accountant” is a registered trade mark of ICAS, the Institute of Chartered Accountants of England and Wales and Chartered Accountants Ireland. If you are not a member of one of these organisations, you should not use the “Chartered Accountant” mark and designation in the UK or EU in relation to these services. Further restrictions on the use of these marks also apply where you are a member.

Our cookie policy

ICAS.com uses cookies which are essential for our website to work. We would also like to use analytical cookies to help us improve our website and your user experience. Any data collected is anonymised. Please have a look at the further information in our cookie policy and confirm if you are happy for us to use analytical cookies: