Excel VBA for finance professionals course

2 October 2019
Edinburgh, London, Birmingham

Member price in Scotland: £335.75 + VAT
Non-member price in Scotland: £395 + VAT

Please note, the ICAS member discount will be applied after checkout.

Member price in England: £530 + VAT
Non-member price in England: £624 + VAT

Please note, due to differences regarding external costs, courses outside of Scotland are priced separately. ICAS members are eligible for a discounted price on all courses running in England & Wales.

Edinburgh, 2 October 2019

Book with BPP

London, 21 October 2019
Birmingham, 11 November 2019
London, 18 December 2019

Email to book

What you will learn

This one day course provides functional code to take away for reference, an insight into programming and practical exercises in VBA compilation.

This also covers the processing of user input; declaring and using variables; and an introduction into the complexity of repeating code using loops.

Who should attend

The course is aimed at those who wish to increase spreadsheet potential by automating their tasks and processes.

It will benefit spreadsheet authors, Excel developers and finance professionals looking to learn and experiment with the VBA programme in order to speed up everyday tasks.

A good working knowledge of Excel is a distinct advantage, whilst experience with automation and knowledge of macros is not necessary.

Full speaker list


Our technology courses include excel training and financial modelling which covers practical scenarios which delegates are likely to encounter in the work place. The excel trainers are talented course designers and presenters with experience spanning over three decades. 

The Financial Modelling team specialise in training in corporate finance and modelling. In addition, they have completed a number of consulting assignments in the financial modelling field.

They have a wealth of experience training professionals, in both practice and industry, in all areas of financial modelling, accounting and financial analysis. Our technology teams have trained all over the world, including Amsterdam, Paris, Frankfurt, New York, Singapore, Sydney, Kampala and Abu Dhabi.

View full event details


Introducing Visual Basic for Applications

  • Recording and running macros.
  • Absolute vs relative referencing.
  • Working with the Visual Basic Editor and Developer tab.

Creating your own code

  • Understanding and creating modules.
  • Common rules of programming.
  • Where to store macros.
  • Modifying / improving simple modules.
  • Problem solving / finding concise solutions.

Getting VBA to make decisions

  • Using logical comparisons.
  • The IF...ENDIF structure.
  • The SELECT CASE...END SELECT structure.
  • Error handling and trapping.

Introduction to repeating code

  • The need for and benefits of loops.
  • Implementing a DO WHILE LOOP.
  • Examples of the FOR... NEXT structure.

Interaction between VBA and the end-user

  • Activating message boxes and user prompts.
  • Processing end-user input via input boxes.

Creating functions

  • Writing your own User Defined Functions (UDFs).
  • Working with multiple arguments.
  • Using your bespoke function in Excel.

All exercises and project files used on the course will be available to take home. Laptops with Excel 2013 will be provided on the course. The knowledge and skills gained can be used across all modern versions of Excel.


Edinburgh, London, Birmingham


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


  • Business and Financial management
  • England and Wales
  • Scotland
  • Training courses
  • Edinburgh
  • London and Home Counties
  • Birmingham and the Midlands
  • Technology

Previous Page