Excel VBA for Finance Professionals - Part 1

BPP Professional Education
Course summary
6 hours
634 GBP excl. VAT
Birmingham, London, Online courses
Next available date: Online delivery option may be available - Please contact provider. - Online courses
Professional Training

Course description

Excel VBA for Finance Professionals - Part 1

By the end of the course the delegate will be competent in an array of VBA essentials:

  • The fundamentals of VBA, including working with procedures and functions, understanding objects, using expressions, variables and intrinsic functions.
  • Mastering how to control program execution.
  • In order to ensure minimal downtime while building and rolling out the program, the course also includes modules on debugging code and handling errors.

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.

COVID-19 Update

This provider offers an online version of their classroom courses

Do you have questions about COVID-19 in relation to this course?

At findcourses.co.uk we are committed to helping everyone who wants to learn, to learn. So are our trusted partner providers.

Get in touch on this page to find out whether there are any changes to this course in light of COVID-19.

Suitability - Who should attend?

Those who wish to increase spreadsheet potential by automating their tasks and processes. Spreadsheet authors, Excel developers and finance professionals looking to learn and experiment with VBA programming 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.

Outcome / Qualification etc.

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.

Get Inspired! Watch the Video

About provider

BPP Professional Education

BPP Professional Education -  Accountancy, Tax, Financial Services, Law & Insolvency Courses

BPP Professional Education is one of the specialist examination-based and professional development training arm of the BPP Group, Europe's biggest professional education and publishing provider with 2,000 staff members across 40 countries and over 30,000 students per year. BPP Professional Education...

Read more and show all courses with this provider

Request info

Fill out your details to find out more about Excel VBA for Finance Professionals - Part 1.

  Contact the provider

  Get more information

  Register your interest

Contact info

BPP Professional Education

3 London Wall Buildings
EC2M 5PD London

 Show phone number

Request information

Find out more about this Excel VBA for Finance Professionals - Part 1 course - simply fill out your details:

U.K. L&D Report: 2018 - Benchmark Your Workplace Learning Strategy

Are you curious about the L&D strategies of some of the U.K.'s top companies?

Find out what they're up to in findcourses.co.uk's second annual U.K. L&D Report!


Learn more

Find a course for you!

  Read the course
 summary on this page

 Fill in your details and Request information

 Receive all the info you need

Find more courses here