MS Excel VBA Advanced Course - Automate Tasks & Build Complex Macros

⏰ 3 days (24 training hours) of practical training

Live online course with interactive exercises and real-life business data.

Mini lectures + practice = knowledge you will use immediately.

Official training certificate issued upon course completion.

Check available dates and register via this form.

This advanced Excel Visual Basic for Applications course is designed for professionals who already have basic VBA knowledge and want to:

Automate complex workflows in Excel
Build sophisticated macros
Work with large datasets and dynamic databases
Optimize reporting and data analysis processes

Through live online sessions and practical exercises, participants will gain hands-on experience in real-world business scenarios.

Analysts and Excel power users with prior VBA experience
BI and finance professionals seeking advanced automation
Teams handling large datasets and complex reporting
Anyone looking to optimize workflows with advanced VBA techniques

After completing this course, participants will be able to do the following in an automated way:

get and upload data from/to any databases (such as MS Access, MySQL, or Oracle) using CSV files,
work with user forms (dialogue boxes),
create and maintain databases with a changing number of records,
manage amounts of data.

Enrol now!

The VBA in MS Excel - advanced level course syllabus include:

Start of the training course - organizational matters
Databases created in spreadsheets
2.1. Database usage
2.2. Basic information on databases
2.3. Database usage automation
2.4. Restrictions on the use of direct connection to an external database
Data transfer between databases – using CSV files (text files with sequential access)
3.1. CSV file format
3.2. General algorithm for processing CSV files
3.3. Other possibilities of using CSV file support mechanism
3.4. “Input” mode – uploading data from a file
3.5. “Output” mode – writing data to a file
3.6. “Append” mode – adding data to the end of file
3.7. Workshops
Names of cells and cell ranges
4.1. Name usage and advantages of using names
4.2. Rules for creating and using names
4.3. Operations on names
4.4. VBA language traps in using cell/cell range names
4.5. Workshops
Array variables (arrays)
5.1. Advantages of using array variables
5.2. Array variable types
5.3. Rules for building and using array variables
5.4. Declaring and processing arrays
5.5. Two dimensional arrays
5.6. Dynamic arrays
Custom data types (User-defined types) – for records/data structures
6.1. Advantages of using structured data types
6.2. Creating structured data types
6.3. Using structured data types
Communication with user – “MsgBox” function
7.1. Displaying messages to user
7.2. Program control
7.3. Determining the reach of variables (for entire module and for entire project)
Dialogue boxes (VBA user forms)
8.1. Basic rules for creating clear and functional dialog boxes
8.2. Creating dialog boxes
8.3. Adding text fields
8.4. Adding check boxes and option fields (option button)
8.5. Adding a list of values
8.6. Workshops
8.7. Exporting and importing user forms
Preparing a database template and relevant programming
9.1. Database workbook-template content
9.2. Workshops
9.3. Presentation of sample database template
End of the training course (test + discussion of the results, training evaluation)

Training methods:

Lecture + workshops (amount proportional to lecture) + workshops check (individual) + workshops discussion.

The MS Excel VBA advanced level course participants are required to have:

very good practical knowledge of MS Excel,
taken the training course “VBA in MS Excel - Beginners Level. Basics of computer programming” and “VBA in MS Excel - Intermediate Level. Worksheets, workbooks, files (or knowledge and background of the training material).

Three days of live training, course materials and an official completion certificate.
Training is carried out in the form of alternating lectures and practical exercises, performed individually or together.

Yes - sessions include hands-on labs and real-world datasets.

To sign up, simply fill out the short registration form.

Go to form

Sign up for training!

Join us to build your expertise and take the next step in your career!

Enrol now!

VBA in MS Excel - advanced level

3 days • Live online • Hands-on labs • Official certificate

Quick Facts

About the VBA in MS Excel - advanced level course

Who should attend?

Learning outcomes

FAQ

Sign up for training!

📩 Any questions? Get in touch with us!