Excel VBA for finance professionals - part 2
Member price: £539 + VAT
Non-member price: £634 + VAT
Birmingham, 12 November 2019
London, 19 December 2019
What you will learn
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.
Who should attend
Those looking to further their skills in Excel VBA from Excel VBA for finance professionals - part 1, 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.