Excel VBA for Creative Problem Solving
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.
3,000 employers partner with us to shape our courses
Pass rates up to 47% 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
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- 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.