VBA in Microsoft Excel – Intermediate level online course

The training is designed for people who primarily want to expand their knowledge and skills gained in basic training and they need to automate the work associated with data processing in multiple sheets and / or workbooks.

Registration form

This training course is to empower participants’ expertise while doing their job, thus:

Automate repetitive tasks – such as manipulation of worksheets and files (creation/generation and deletion) and worksheet formatting.
Increase proficiency in creating and implementing efficient algorithms.
Develop a set of ready-to-use procedures – useful tools to apply in daily work.

After this training course, the participant will automate:

preparation and formatting of worksheets with repetitive calculation structures (operations on formulas and worksheets, creating of custom functions, among other things),
downloading and storing information in several workbooks or worksheets,
segregation and preparation of data/calculation sets for various stakeholders (operations on worksheets and workbooks, among other things).

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 organization.

Preparation

Required knowledge:

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

3 days, 24 training hours

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.

20-22 January 2025 (1500 €)

VBA in MS Excel - Intermediate Level

Training in VBA in Intermediate Level

Learn about important elements of the Visual Basic programming language!

Similar trainings

Consultant: