Excel VBA for creative problem solving
Member price: £361 + VAT
Non-member price: £425 + VAT
Timing: 9.30am-4.30pm
Online Live, 14 November 2024
Online Live, 8 May 2025
Online Live, 6 November 2025
Overview
Save lots of valuable time by automating crucial business tasks on spreadsheets.
This course covers all of the essential skills to confidently code in VBA with exercises that introduce broad problems inspired by situations that you might encounter in the real world. This is also a great springboard for anyone who wishes to learn some coding that creates real impact with your work.
This course uses Microsoft Excel for the live exercises
- Create macros to automate a variety of procedures in Excel
- Implement conditions and constraints to control how the routine works
- Automate Excel's Goal Seek and Solver tools and use numerical techniques to create targeting and optimisation problems
- Create subroutines to interface with the user
- Define your own user-defined functions as bespoke new routines
- Easily solve issues with messy and unwieldy datasets
- Find creative ways of importing numerical data into a central report
Who should attend
No prior knowledge in programming or exposure to VBA is necessary. This course is for anyone looking to speed up processing in Excel and learn valuable skills in spreadsheet automation to help save them time in the long-term.
This course will also be of interest to:
- Finance professionals
- Accountants
- Junior Accountants
- Auditors
- Analysts / Power Users
- Data Analysts
- Application specialists
What you will learn
- Learn the basic programming structures in VBA
- Automate many essential tasks to help save valuable time
- Discover how to seamlessly import numerical data from multiple sources
- Write your own functions in VBA to create bespoke tools and actions
- Identify the best ways to solve common problems in Excel, helping you towards more effective working
- Confidently start automating your spreadsheets which solve real world problems
Information for Online Live dates
Please read the following guidance carefully, which only applies if you are attending this course online:
- In addition to the Online Classroom, you will need to have your own version of Excel open to complete the exercises
- It does prove to be challenging to follow-on with the exercises using only 1 screen as you will need to be regularly switching between open windows. We recommend to either:
- Extend from a computer to a 2nd screen - please refer to this link for guidance on how to correctly setup a second monitor https://support.microsoft.com/en-us/help/4340331/windows-10-set-up-dual-monitors or
- Use 2 computers, or
- Use a tablet for the online classroom and a computer for the Excel
- Please note that our courses are based on Excel for Windows and it is recommended that you are using at least Excel 2010 or a later version. MAC users are welcome but please note that there may be some tools and functionality that will differ from what is being presented. The presenter will accommodate for MAC versions on the course.
Questions?
BPP | Tel: 0330 060 3303 | Email: ldicas@bpp.com