Microsoft Excel VBA Advanced Course – Classroom
Take your VBA programming further by mastering control structures, developing user forms, debugging code, handling errors, and automating advanced tasks.
Course Overview
This 2 day Microsoft Excel VBA programming advanced course introduces advanced Excel users to the process of writing and editing Macros in Excel, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
This Microsoft Excel VBA Advanced course is suitable for anybody wanting to learn any version between 2016, latest 2024 and 365. Our courses cover all the aspects and differences between the versions.
Who is it for?
This Microsoft Excel VBA course will appeal to students looking to gain the skills necessary to apply VBA to develop macros, format worksheets, create user-interactive macros, work with multiple worksheets, and perform calculations. It may also appeal to students who already have knowledge of the basics of Excel, including how to create, edit, format, and print worksheets that include charts and sorted and filtered data.
Prerequisite
Proficient knowledge of Microsoft Excel and knowledge of PivotTables, helpful but not required.
To meet this prerequisite, you can take any one or more of the following courses:
What’s Included
- Professional Microsoft Certified Trainer
- CPD Accredited Classroom training in Small Groups for Max Focus
- Only Microsoft Approved Courseware and Exercise Files are used
- Free Assessment of Skills prior to booking
- Certificate of Completion & Complementary 12 Months Post Course Support
- 100% Money Back Guarantee & Price Match Guarantee
- Bespoke Courses & Group Discounts from £99 per person
Objectives
Upon successful completion of this Microsoft Excel VBA Advanced course, students will be able to:
- Apply VBA to develop macros
- Format worksheets
- Create user-interactive macros
- Work with multiple worksheets
- Perform calculations
Course Content
Microsoft Excel VBA Advanced Course Content:
Lesson 1: Using Expressions, Variables, and Intrinsic Functions
- Understanding Expressions and Statements
- Declaring Variables
- Understanding Data Types
- Working with Variable Scope
- Using Intrinsic Functions
- Understanding Constants
- Using Intrinsic Constants
- Using Message Boxes
- Using Input Boxes
- Declaring and Using Object Variables
Lesson 2: Controlling Program Execution
- Understanding Control-of-Flow Structures
- Working with Boolean Expressions
- Using the If…End If Decision Structures
- Using the Select Case…End Select Structure
- Using the Do…Loop Structure
- Using the For…To…Next Structure
- Using the For Each…Next Structure
- Topic H: Guidelines for use of Control-of-Flow Structures
Lesson 3: Working with Forms and Controls
- Understanding UserForms
- Using the Toolbox
- Working with UserForm Properties, Events, and Methods
- Understanding Controls
- Setting Control Properties in the Properties Window
- Working with the Label Control
- Working with the Text Box Control
- Working with the Command Button Control
- Working with the Combo Box Control
- Working with the Frame Control
- Working with Option Button Controls
- Working with Control Appearance
- Setting the Tab Order
- Populating a Control
- Adding Code to Controls
- Launching a Form in Code
Lesson 4: Working with the PivotTable Object
- Understanding PivotTables
- Creating a PivotTable Using Worksheet Data
- Working with the PivotTable Objects
- Working with the PivotFields Collection
- Assigning a Macro to the Quick Access Toolbar
Lesson 5: Debugging Code
- Understanding Errors
- Using Debugging Tools
- Setting Breakpoints
- Stepping through Code
- Using Break Mode during Run mode
- Determining the Value of Expressions
Lesson 6: Handling Errors
- Understanding Error Handling
- Understanding VBA’s Error Trapping Options
- Trapping Errors with the On Error Statement
- Understanding the Err Object
- Writing an Error-Handling Routine
- Working with Inline Error Handling
Delivery Method
Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities.
Certification
This Microsoft Excel VBA Advanced course is one of a series of courses that addresses Microsoft Certified Application Specialist (Microsoft Business Certification) skill sets.
The Microsoft Certified Application Specialist program is for individuals who use Microsoft’s business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Microsoft Certified Application Specialist certification.
Microsoft Excel VBA Advanced Course – Classroom
- Easy Booking & Payment Options. Full Details
- No Upfront Payment Needed!
- Guaranteed Secure Shopping
- 100% Money-Back Guarantee
Course Dates & Locations
Testimonials
Gerard Cahill Commercial Accountant from Capital One
Khalid Tai Ecotricity (Stroud)
Steve Large Director from Large Creative
Lisa Dunstan Payroll Manager from Decathlon UK
Michael Sexton
John Clarke
Sarah Harvey Assistant Accountant from QD Commercial Group Holdings
Harry Frost Marketing Assistant from Babcock International Group
Emily North
Sam Fletcher
Making a payment to Infero
How to Book & Pay for the Course
Book a course by giving us a call or using our simple and secure online booking system.
To book online you only need to provide a few details and you do not need to make an immediate payment at a time of a booking.
Payment Methods
Once you book a course, we will issue you an invoice. with the details of how to pay.
You can pay by bank transfer, cheque or card.
For Businesses (if required)
Supplier Registration – If you are a business, you will most likely need to add us to your approved supplier list. We are happy to send you all the details needed.
Purchase Orders (PO) – If your business uses a PO system to manage supplier invoices we are happy to comply. The best way is to get in touch with us.
Alternatively,
- If you already have a PO number, please add a PO number into Order Notes during booking on the booking form, and we will include PO number on your invoice.
- If you need an invoice to generate a PO number in your accounting system, please book a course as normal and add a note in the Order Notes that you will need a pro-forma invoice. We will issue a pro-forma invoice, which your accountants can use to generate a PO. Once we receive the PO, we will re-issue your invoice with your PO number.
Training Venues
Nottingham Training Centre
Nottingham, NG1 6LG
Birmingham Training Centre
Birmingham, B5 4DY
Bristol Training Centre
Bristol, BS1 5EH
Leeds Training Centre
Leeds, LS1 1PJ
Leicester Training Centre
Leicester, LE1 1RE
Liverpool Training Centre
Exchange Flags
Liverpool, L2 3PF
London Training Centre
8 Duncannon Street
London, WC2N 4JF
Manchester Training Centre
Manchester, M1 3DT
Milton Keynes Training Centre
Oldbrook
Milton Keynes, MK6 2TG
Sheffield Training Centre
Sheffield, S1 2EA
Top Nottingham FAQs
Can the Training be customised to our organisation’s requirements?
What are the Course Timings?
- Start: 09:00am
- Morning break: 11:00am
- Lunch: 01:00pm
- Afternoon break: 03:00pm
- Finish: 05:00pm
This schedule applies to all 1-day, 2-day, and 3-day courses, whether delivered virtually, in the classroom, or on-site. For on-site training or larger group bookings, start and finish times can be adjusted to suit your organisation’s needs. To discuss a customised schedule, call us on 0115 958 6699 or complete our Request a Quote form and a member of our team will be in touch.
Can Training be delivered at our workplace?
Yes — we can deliver training directly at your workplace. Whether you require one-to-one sessions, group training, or fully bespoke on-site courses, we tailor the content and delivery to meet your organisation’s specific needs.
To arrange workplace training, call us on 0115 958 6699 or complete our Request a Quote form, and a member of our team will be in touch to discuss your requirements.
How is the Course structured?
Do I need any equipment for training?
For classroom training you typically don’t need to bring any equipment, unless we specifically advise otherwise. All necessary resources will be provided at our training centre.
For virtual training you will need a computer or laptop with the full version of the software relevant to your course. We also strongly recommend using a second screen, such as a tablet or smartphone, so you can complete exercises on your main device while viewing the virtual whiteboard or trainer’s screen on the second.
How do I know which level is right for me?
If you are unsure which course level best matches your current skills, we're here to help. Simply give us a call on 0115 958 6699, and one of our expert trainers or course advisors will guide you in choosing the most suitable training level for your needs.
How experienced are your tutors?
We pride ourselves on delivering high-quality training—something made possible by our exceptional team of tutors. All our trainers have extensive practical experience, specialist knowledge, and a strong background in teaching and training. Their expertise ensures that every course is engaging, relevant, and effective.
We’re happy to provide tutor profiles and references upon request—just get in touch.
Is there ongoing support after completing the course?
Absolutely! After completing your training, you’ll receive a range of post-course support materials, allowing you to revisit the content at your own pace. In addition, we offer 12 months of support, so you can ask questions, seek clarification, or get guidance as you apply your new skills in real-world situations.
We're committed to helping you continue your learning journey long after the course ends.
Will I receive a certificate upon completion?
Accreditations & Memberships
