Preloader spinner

Microsoft Excel VBA Intermediate

Image of laptop displaying an image containing the words Microsoft Excel

COURSE AIMS

Building upon the foundational knowledge gained in the introductory course, the Microsoft Excel VBA Intermediate course aims to enhance your VBA skills. You will learn more advanced techniques to automate Excel tasks and solve complex business problems efficiently.

LEARNING OBJECTIVES

In this course, you will:

  • Explore advanced VBA components and their applications in solving complex business challenges.
  • Extend your VBA macro recording skills to handle more intricate tasks.
  • Develop custom VBA functions and subroutines to streamline Excel operations.
  • Utilize advanced programming elements, including user-defined objects, conditional statements, and loops.
  • Enhance error handling and optimize VBA code for improved performance.

TARGET AUDIENCE

This course is designed for Excel users who have completed the introductory Excel VBA course or possess equivalent VBA knowledge. It is ideal for individuals who want to delve deeper into VBA automation, manipulate complex data, and create custom functions for advanced Excel tasks.

COURSE OUTLINE

1 - LESSON 1: ADVANCED VBA COMPONENTS

  • Topic A: Advanced VBA Components and Their Applications
  • Topic B: Leveraging User Forms for Enhanced User Interaction
  • Topic C: Working with External Data Sources

2 - LESSON 2: ADVANCED MACRO RECORDING

  • Topic A: Recording Macros for Complex Excel Operations
  • Topic B: Utilizing Relative and Absolute Addressing in Macros
  • Topic C: Managing and Organizing Macros and Modules

3 - LESSON 3: ADVANCED VBA CODING

  • Topic A: Creating Advanced VBA Subroutines and Functions
  • Topic B: Exploring User-Defined Objects
  • Topic C: Harnessing the Power of Collections in VBA

4 - LESSON 4: ADVANCED PROBLEM-SOLVING

  • Topic A: Complex Decision-Making in VBA Code
  • Topic B: Advanced Variable Manipulation
  • Topic C: Implementing Nested Loops for Complex Tasks

5 - LESSON 5: ADVANCED VBA OPTIMISATION

  • Topic A: Proficient Debugging of VBA Errors
  • Topic B: Advanced Error Handling Strategies
  • Topic C: Optimising VBA Code for Peak Performance

Related Courses

Public Schedule

RRP:  
N/A
Our price:  
N/A

Virtual Private Training

Contact us for pricing

Onsite Training

Contact us for pricing

Note

All prices exclude VAT at 20%.

VAT registration number: 450 4347 14

No items found.

You may like...

Microsoft Project Advanced

Excel in project management with our 1-day Advanced Microsoft Project course. Master complex scheduling, reporting, and customisation to lead successful projects.

An icon of a person

N/A

An icon of a clock

1 day

Microsoft Project Intermediate

Take your Microsoft Project skills to the next level with our 1-day Intermediate course. Dive deeper into advanced tools and techniques to manage projects efficiently.

An icon of a person

N/A

An icon of a clock

1 day

Microsoft Project Introduction

Master the basics of Microsoft Project in our 1-day introductory course. Learn to plan, manage, and optimise your projects effectively.

An icon of a person

N/A

An icon of a clock

1 day

Enquire about this course

Microsoft Excel VBA Intermediate
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.

Join our mailing list

Receive details on our new courses and special offers

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.