Training: Excel – VBA Advanced

Ref. MOE-42

Download PDF

Duration:

2

days

Exam:

Not certifying

Level:

Advanced

Funding:

Temptraining

ITTA | Trainings | Office Automation | Spreadsheet | Excel – VBA Advanced

Description

This course teaches the more advanced features of VBA with a focus on automating tasks and processes in Excel.

Participant profiles

Office experts who already know VBA and wish to improve their practices

Objectives

Work with objects
Automate tasks in Excel
Create dialog boxes
Debug their VBA code

Prerequisites

To have the equivalent knowledge or to have followed the training: Excel – VBA Fundamentals

Course content

Module 1: Presentation of the Excel object model

Referencing objects
Properties and methods of objects
Different ways to reference a range
Useful properties and methods of the Range object

Module 2: Automating with Excel

Simple commands
ActiveX commands
Managing Excel and dialog boxes
Save user settings in the Registry
Merging data from several tables
String functions

Module 3: Creating UserForms

Form controls
Adding event handling procedures

Module 4: Debugging Techniques

Intercepting errors
Using the Visual Basic testing tools

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Temptraining funding

ITTA is a partner of Temptraining, the continuing education fund for temporary workers. This training fund can subsidize continuing education for anyone who works for an employer subject to the Collective Work Agreement (CCT) Rental of services.

Additional information

As we care about the quality of our training, ITTA offers you an online skills assessment test before and after your course so that you can evaluate your progress
Explore all our Microsoft Office courses by clicking here