Excel VBA for Finance Professionals (ICAS)

BPP Professional Education
Course summary
6 hours
395 GBP excl. VAT
Edinburgh, 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 (ICAS)

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.

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

Training Course Content

ntroducing Visual Basic for ApplicationsRecording and running macros.Absolute vs relative referencing.Working with the Visual Basic Editor and Developer tab.Creating your own codeUnderstanding and creating modules.Common rules of programming.Where to store macros.Modifying / improving simple modules.Problem solving / finding concise solutions.Getting VBA to make decisionsUsing logical comparisons.The IF...ENDIF structure.The SELECT CASE...END SELECT structure.Error handling and trapping.Introduction to repeating codeThe need for and benefits of loops.Implementing a DO WHILE LOOP.Examples of the FOR... NEXT structure.Interaction between VBA and the end-userActivating message boxes and user prompts.Processing end-user input via input boxes.Creating functionsWriting 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 (ICAS).

  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 (ICAS) course - simply fill out your details:

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