Training: Excel – VBA Fundamentals

Ref. MOE-41

Download PDF

Duration:

2

days

Exam:

Not certifying

Level:

Intermediate

Funding:

Temptraining

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

Description

This course is ideal as an introduction to VBA programming for Excel. It will allow participants to automate their tasks, from simple recorded macros, to creating procedures and managing variables.

Participant profiles

Office experts who need to automate tasks and enrich the catalog of functions in Excel

Objectives

Create a macro and edit it
Work in the Visual Basic editor
Work with variables
Create custom functions

Prerequisites

Expert knowledge of Excel

Course content

Module 1: First steps with Excel VBA programming

Introduction to VBA
When to use VBA
Recording a macro
Saving a macro
Analyzing a macro

Module 2: Working in the Visual Basic Editor

Presentation of the Visual Basic Editor
Essential elements of the VBA language
Creating and using functions and sub-processes

Module 3: Working with variables

Declaration and scope of variables
Types of variables
Working with constants
Assigning values to variables
Retrieving values from variables

Module 4: Using VBA functions and Excel

Using VBA functions
Using Excel functions (WorksheetFunction)
Creating custom functions

Documentation

Digital courseware included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary courses

Excel – VBA Advanced | MOE-42

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