Training: Excel – The macro recorder and introduction to VBA

Ref. MOE-31

Download PDF

Duration:

0.5

jour

Exam:

Not certifying

Level:

Expert

Funding:

Eligible

Home > Trainings > Office Automation > Spreadsheet > Excel – The macro recorder and introduction to VBA

Description

This course will give participants a first introduction to VBA, and will allow them to automate their work using simple macros.

Participant Profiles

Advanced users who need to automate their work procedures

Objectives

Create simple macros
Edit their VBA code
Manage the use of their macros

Prerequisites

Expert knowledge of Excel

Course Content

Module 1: The Macro Recorder

Displaying the Developer tab
Creating a macro through the macro recorder
Running recorded macros
Saving macros in the personal macro folder

Module 2: The Visual Basic Editor

Using the Visual Basic Editor in Excel
Using relative references
Deleting macros

Module 3: Using your macros

Creating a new ribbon
Adding a Macro to a Ribbon
Adding a macro to the Quick Access Toolbar
Assigning a macro to an object, a button or a control

Documentation

Digital course material included

Lab / Exercises

Practice exercises will be given at the end of each module

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

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