BPP University

Excel VBA for Creative Problem Solving - ICAS

BPP University

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

  • Hands-on exercises in Microsoft Excel applying VBA to real-world challenges
  • Learn to create macros, user-defined functions and interactive subroutines
  • Automate Goal Seek and Solver for targeting and optimisation problems
  • Creative techniques for importing and managing complex datasets
  • Suitable for coding beginners or those applying it in business

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
  • Data Analyst
  • Business Analyst
  • Management Accountant
  • Reporting Analyst
  • Excel VBA Developer

Cost of study

UK/Home: £454.80 | International: £454.80

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
Download Free Guide