Training advisors available Mon–Fri, 9am to 5pm train@keystraining.com Public course dates
Speak to an advisor0345 450 0051 Build a quote
Microsoft 365 & Copilot · Advanced

Excel VBA

Microsoft Excel VBA Training Course

This one day course is designed for delegates wishing to automate common worksheet operations, to convert worksheets into forms and to understand Excel VBA code.

Length1 day
LevelAdvanced
FormatsPublic
Group sizeUp to 8 per group
Get a quote for your team
Level 1IntroductionLevel 2IntermediateLevel 3AdvancedLevel 3VBA
Overview

About the Excel VBA course

*Book 2 or more delegates and receive significant discounts. Click here for information

Scheduled public courses are held at Preston, Liverpool, Manchester & London.

Closed tailored courses are available on your site if requested.

  • Record macros to automate tasks
  • Write control structures
  • Create custom functions
  • Build user forms
  • Build procedures using variables
Course outline

What the day covers

1 modules · tailored to your team on in-house courses
What the course covers10 topics
  • Introduction to Excel VBA
  • Recording and running procedures
  • Viewing and editing procedures
  • Working with Visual Basic Code
  • Understanding Objects, Properties and Collections
  • Simple user input
  • Control and looping
  • Debugging
  • Error handling
  • Customising the User Interface
Outcomes

By the end of the course, delegates will be able to

  • Record macros to automate tasks
  • Write control structures
  • Create custom functions
  • Build user forms
  • Build procedures using variables
Is it right for you?

Who the course is for

Before you attend

Delegates should have already attended an Excel Advanced course or be able to demonstrate equivalent knowledge.

Every course includes

More than just a training day

Dedicated account managerOne named contact who knows your organisation and your history with us.
Pre-course evaluationFree skills check forms so every delegate lands on the right level.
Course tailoringWe plan and customise closed courses around your roles, systems and files.
CertificatesA Keys Training certificate for every attendee, for training records and ESR.
Management feedbackPost-course feedback reviews so you can see what landed.
Free aftercareTelephone and email support for every delegate after the course.
Keep going

Courses that pair well with this one

All microsoft 365 courses

Get your team trained properly.

Tell us the course, rough numbers and where you are. A training advisor will reply within one working day with options and a fixed fee.

Build your quote or call a training advisor0345 450 0051
FromTailored quoteGet a quote
View quote