Excel VBA for Finance Professionals - Part 2

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

Course description

Excel VBA for Finance Professionals - Part 2

This one day course is designed as a follow on from Excel VBA for Finance Professionals - Part 1, and by the end of the course the delegate will be able to demonstrate their knowledge in the following areas of Excel VBA:

  • Understand how to write more complex conditional blocks of code, including areas where VBA responds to users being asked questions, and to process data.
  • Get code to auto-execute, and be able to apply more creativity with their programs.
  • Improve their VBA routines with smoother techniques and smarter referencing. .

This one day course provides functional code to take away for further use, more in-depth programming techniques, and practical exercises in VBA compilation. This also covers interfacing with User Forms; declaring variables; and creating more bespoke functions and routines.

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 looking to further their skills in Excel VBA from Part 1 of our Excel VBA for Finance Professionals series, and turn up the degree of complexity in automation a notch or two. Spreadsheet authors, Excel developers and finance professionals looking to experiment with VBA programming in more depth and to move up from core foundation skills. Having attended Part 1 or similar foundational knowledge will help participants gain the maximum benefit from this session.

Outcome / Qualification etc.

Brief recap of fundamentals

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

Programming in VBA

  • Complex IF blocks
  • “Option Explicit” and declaring variables
  • Identifying problems and limitations
  • Programming etiquette
  • Debugging and stepping techniques

Repeating code with increased power

  • The need for and benefits of loops
  • Implementing the LOOP structure
  • Understanding the FOR... NEXT structure

Event handler tricks and techniques

  • Toggle updates and alerts
  • Prevent screen flicker
  • Decision making on user questions and internal errors
  • Security and lock-down techniques

Further powerful programming techniques

  • Auto execute code on startup
  • Prevent code collapse with “Resume Next”
  • Program a bespoke Pivot Chart drilldown

Introduction to User Forms – design and implementation

  • Design simple forms for data entry
  • Form properties, controllers and commands
  • Create a bespoke security form for changing passwords

Getting creative with bespoke routines and functions

  • Further in-depth User Defined Functions (UDFs)
  • Search function with instance argument
  • Create a “Splash Screen” for a bespoke program
  • Hands-on time with a case study

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 2.

  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 2 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