Excel VBA for Creative Problem Solving

Course overview

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.

Key highlights

Learn to automate essential business tasks in Excel using VBA
Hands-on exercises creating macros and user-defined functions
Build interactive subroutines to streamline workflows and data handling
Automate Goal Seek and Solver for targeting and optimisation problems
Creative techniques for importing and managing complex datasets
Suitable for beginners new to coding

Scholarships

Advocate of the Year Scholarship
£5,000; £3,000; £2,000
Bridging Scholarship
Up to £5,000
Bridging the Bar Scholarship
Value: £5,000
Up to £5,000
BTC Advocacy Scholarship
Award Value: £3,000
Up to £3,000
BTC Excellence Award
Value: £1,000
Up to £1,000
BTC Future Lawyer Scholarship
£3,000 Half fee full fee
Career Changer Scholarship
£3,000 Half fee full fee
Converting to Law Scholarship
£3,000 Half fee full fee
International Postgraduate Bursary
Value: £1,000
Up to £1,000
SQE Future Lawyer Scholarship
£3,000 Half fee full fee

Careers this course leads to

Financial Analyst
Business Analyst
Management Accountant
Data Analyst
Financial Modeller
Reporting Analyst

Cost of study

UK/Home: £882 | International: £882

Admission

Applications are made through AHZ at no cost. Share your transcripts, English test scores and personal statement, and your AHZ Counsellor will review your profile, submit your application to BPP University, and guide you through interview, offer, CAS and visa — right up to enrolment.

Ready to start?

Book a free consultation and we'll map your fastest route to your place.

Apply Now