Excel VBA for Creative Problem Solving
Learn to automate Excel tasks and solve real-world business problems with VBA. This hands-on, one-day course covers essential coding skills, custom functions, and data optimisation techniques to boost efficiency and impact.

3,000 employers partner with us to shape our courses
Pass rates up to 20% higher than the global average*
We train professionals from all four of the Big Four accountancy firms
Overview
- Price
- Online Live from £882.00All courses Inc VAT and excludes exams
Choose your courses
Excel VBA for Creative Problem Solving
Accelerate your productivity by learning how to automate essential business tasks in Excel using VBA. This practical course equips you with the core programming skills needed to confidently write and apply VBA code to real-world challenges. Through hands-on exercises in Microsoft Excel, you'll learn to create macros, build user-defined functions, and develop interactive subroutines that streamline workflows and enhance data handling. Explore how to automate tools like Goal Seek and Solver to solve targeting and optimisation problems, and discover creative techniques for importing and managing complex datasets. Whether you're new to coding or looking to apply it in a business context, this course offers a powerful springboard into programming with immediate, practical impact.- No extra learning materials
How is training delivered?
Learn through our live online classroom
Courses are delivered through Online Classroom Live, our premium online study mode comprising a virtual classroom with interactive features to replicate a real-life classroom..
Online Classroom Live offers a host of benefits to support your learning in the following ways:
Interactive features replicate a real-life classroom to keep you fully engaged
Course notes are shared by your tutor highlighting points and sharing knowledge
You will regularly share your opinions and ask questions via instant live chat messaging and contribute to class polls
Work with fellow learners in smaller group breakout rooms
Access library of online content and pre-recorded lectures 24/7 if you miss a class or want to recap on anything
View more about our Online Classroom Live.
Why choose BPP for training?
Ways to pay
Invoice your employer
Complete and return the booking form. We’ll contact your employer to arrange payment.Buy online
Choose a course from the above list and simply check out with your debit or credit cardBecome a BPP client
If you're an employer looking to upskill your staff get in touch about becoming a BPP client.FAQs
Most frequently asked questions.
If your employer is paying and wishes to be invoiced rather than pay online via credit card, you will need to complete this booking form and return it to us at service@bpp.com. If you are paying for yourself online or via the phone, you can request a copy of your settled invoice.