Intermediate Excel VBA Course for Data Analysis

⏰ 3 days (24 training hours) of practical Excel 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.

Are you ready to move beyond the basics? This course is designed for professionals who want to automate complex data processing across multiple sheets and workbooks. Learn how to write efficient, reusable code to solve real-world business problems, saving you hours of manual work every week.

Ready to become an automation expert? Spaces are limited...

Secure your spot now!

This course is designed for one purpose: to give you the power to automate your most time-consuming Excel tasks.

After completing this training, you will be able to:

1. Build & format reports instantly

Automatically generate and format worksheets with complex, repetitive calculation structures. Turn a task that takes hours into a process that runs with a single click, using your own custom functions and styles.

2. Consolidate data effortlessly

Put an end to the repetitive task of manual copy-pasting. Write effective scripts that will automatically collect, centralize, and archive data from multiple workbooks and worksheets into one reliable source of truth.

3. Create custom views for any stakeholder

Automatically segregate and prepare unique data sets for different teams or managers. Your code can instantly adapt the output to show the right information to the right people, every single time, without extra manual work.
Free up your time to focus on high-value analysis and strategy, not repetitive tasks.

Enrol now

Profile of participants

This training course is intended for individuals who, among other things:

work with multiple worksheets and workbooks at the same time,
create multiple worksheets and/or workbooks with repetitive data/calculation structures,
prepare similar or identical data sets and/or reports in spreadsheets for many different stakeholders.

It is intended, among others, for analysts, accountants, warehouse staff, and employees in production support and organisation.

Preparation

Required knowledge:

very good practical knowledge of MS Excel (participants should use intensively MS Excel in daily work),
taken the training course “VBA in MS Excel – Beginners Level. Basics of computer programming (or knowledge and background of the training material).

Our basic Excel VBA course focuses on recording and editing macros.
During the intermediate course, you will dive deep into writing custom code from scratch.

The full syllabus can be found in FAQ section: "What topics are covered in the VBA in MS Excel course?"

Start of the training course – organizational matters
User-defined functions
2.1. Using functions
2.2. Using functions in MS Excel formulas
2.3. Using functions in VBA code
2.4. Creating custom functions
2.5. Creating add-ins – function library
Formulas – calculation structure in worksheet
3.1. Inserting of formulas into a spreadsheet
Styles
4.1. Applying styles and cell style types
4.2. Operations on cell styles
Operations on worksheets
5.1. References to worksheets
5.2. Creating and deleting worksheets
Operations on workbooks
6.1. Operations on an active workbook
6.2. Operations on selected workbook
Worksheet and workbook events
7.1. Storage location of worksheet and workbook event procedures
7.2. Syntax of event procedure control manual
7.3. Worksheet events
7.4. Workbook events
Error detection and handling
8.1. Run-time error catching and handling
8.2. Run-time error catching possibilities in code
8.3. Elements of run-time error handling
Useful mechanisms and structures – selection
9.1. Timing (“Timer” function)
9.2. Procedure optimization using “ScreenUpdating” function
9.3. Code protection against preview and modification
9.4. Using With ... End With statement to increase the clarity and speed of procedures
9.5. Using indicators for single objects
9.6. Running dialog boxes of an application
9.7. Running another application
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.

VBA (Visual Basic for Applications) empowers you to automate repetitive Excel tasks, streamline workflows, and boost productivity. Instead of manual clicks, you create macros that handle complex operations quickly and accurately, freeing up your time for more strategic work.

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

Go to form!

Absolutely! VBA remains a powerful tool in Excel for automating tasks, customising reports, and integrating with other Office applications. It's widely used in businesses worldwide to save time and reduce errors.

Intermediate Excel VBA Course

Training in VBA in Intermediate Level

Learn about important elements of the Visual Basic programming language!

Quick Facts

Secure your spot now!

Transform your daily workflow

1. Build & format reports instantly

2. Consolidate data effortlessly

3. Create custom views for any stakeholder

Enrol now

FAQ

Similar trainings

📩 Any questions? Get in touch with us!