Responsive image

Microsoft Excel VBA | Training Course

Harness the power of VBA to manage large and variable amounts of data.
Learn best practice for writing and editing VBA code and improve your data's usability.

MICROSOFT EXPERTS   |   PROFESSIONAL TRAINING   |   SMALL COURSE SIZES   |   LONDON LOCATION

Microsoft Excel VBA | Training Course

Course Takeaways
Course Info

Course Offering

Course Takeaways
Takeaways

What will I learn?

  • Understand the VBA environment
  • Debug code using VB editor
  • Objects and Collections
  • Message boxes, input boxes, forms
  • Code execution and fix errors
  • Free digital course assets
  • Free helpdesk support for 28 days
Course Takeaways
Learner Reviews

How good is the course?

  • New Course
  • No reviews yet
  • Delicious lunch provided
  • Certificate of Achievement
  • 0 reviews



Getting Started
• Displaying the Developer Tab
• Recording and running a Macro
• Macro-Enabled Workbooks
• Using the Visual Basic Editor
• The Development Environment
• Understanding Macro Security

Working with Procedures and Functions
• Understanding Modules
• Understanding Procedures
• Calling Procedures
• Creating a Function Procedure
• Working with the Code Editor

Understanding Objects
• Objects and Collections
• Working with Properties
• Using the With Statement
• Creating an Event Procedure

Using Expressions, Variables, and Intrinsic Functions
• Understanding Expressions and Statements
• Declaring Variables
• Understanding Data Types
• Using Intrinsic Functions
• Understanding Constants
• Declaring and using Object Variables



Controlling Program Execution
• Control-of-Flow Structures
• Working with Boolean Expressions
• Different types of Control-of-Flow structures
• Guidelines for use of Control-of-Flow Structures

Working with Forms and Controls
• Working with UserForm Properties, Events and Methods
• Working with different Controls
• SettingControl Appearance
• Populating a Control
• Adding Code to Controls
• Launching a Form in Code

Handling Errors
• Understanding Error Handling
• Writing an Error-Handling Routine
• Working with Inline Error Handling

Questions and answers

  Course Dates Venue   Price  
London Bridge £449 + VAT
Online £449 + VAT
London Bridge £449 + VAT
Online £349 + VAT save £100
London Bridge £449 + VAT
Online £349 + VAT save £100
London Bridge £449 + VAT
Online £449 + VAT
London Bridge £449 + VAT
Online £449 + VAT
London Bridge £449 + VAT
Online £449 + VAT
London Bridge £449 + VAT
Online £449 + VAT
London Bridge £449 + VAT
Online £449 + VAT
London Bridge £449 + VAT
Online £449 + VAT

You Might Like These Too

Power BI Business Analytics

from £349 + VAT

2 day course
Learn to analyse and publish data from a variety of sources using this powerful software.

Create boards, visualisation and dashboards that can then be published.

  • Connect to data sources
    Use power query to transform data
    Create dashboards with tables/charts
    Perform custom calculations
    Create, format and shape reports

Microsoft Excel Adv

from £149 + VAT

1 day course
Automate and streamline your workflow to boost your productivity.

Gain time-saving hints and tips from professional Microsoft Excel experts.

  • Use VLOOKUP functions
    Formula auditing tools
    Adv Pivot tables
    What If analysis
    Reducing your audit risk

Microsoft Powerpoint Intro

from £129 + VAT

1 day course
Quickly and easily create professional, engaging presentations using Powerpoint.

Learn tips and tricks from experts to make your presentations shine.

  • Understand the interface
    Create the perfect slide
    Work with text
    Visual enhancements
    Transitions, animations and notes

What Do People Think About Our Courses?

Tom Interview
Premiere Intro

 Learner Stories

Tom's Course

Tom works in Internal Communications for an NHS service provider. Listen to his experience about attending our online Adobe Premiere Intro course.

Meija Interview
Social Media Marketing Intro

 Learner Stories

Meija's Course

Meija works for the MOD, in marketing and communications and here tells us about attending her online Social Media Marketing course with Alice.

Katie Interview
Social Media Marketing Intro

 Learner Stories

Katie's Course

Katie works for the Ministry of Defence as a Digital Content Editor and here tells us about attending her online Social Media Marketing course with Kirsty.



"Answering Questions to all Excel Questions not just questions relevant to the course. Also answering questions on other systems which have Excel working behind the scenes such as Power BI"
Ed Broking Limited
9th April - Microsoft Excel : Advanced

Latest Reviews



"Pacing, tailoring the course to the participants and flexibly adding and amending the content according to people's interests and needs."
Class Publishing
  • 9th April


"The way the examples were laid out and in particular the way the Kevin explained everything was so easy to follow. Cant recommend him highly enough."
Ed Broking
  • 9th April


"Comprehensive, friendly and informative. The subject matter could've been quite overwhelming but Simon was engaging, knowledgeable and easy to understand. He answered questions concisely and made it an enjoyable learning experience"
RSM International
  • 9th April
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients
Top Clients