FR
Illustration: VBA Training course

VBA Training – Automation and Macros | Continuing Education |

Excel

This training is now available only in private session, 5 hours of course for 3 days in your company.

Contact us for more details

3 days 9:00 a.m. to 4:30 p.m. Online, Montreal, Quebec City

Updated on

The VBA Training course at a glance

Length
3 days
Schedule
9:00 a.m. to 4:30 p.m.
Format
Live virtual class or in person in Montreal and Quebec City
Audience
Tous
Price
$1,301 per participant, or $1,105 for public bodies and non-profits (plus taxes)
Language
English

Doussou Formation and VBA Training: key facts

Upcoming VBA Training sessions

Online

  • Select
  • Select
  • Select
  • Select
  • Select
  • Select

VBA Training course outline

Excel Fundamentals

  • Interface description (Ribbon, Quick Access Toolbar, etc.)
  • Structure of a file (workbooks, sheets and cells)
  • Modify your data: Increment series and Fix flaps
  • Overviews of the main shortcuts and tips for saving time
  • Customizing the Ribbon and Quick Access Toolbar
  • Creating and managing tabs

Using reference names

  • Create reference names
  • Go to a named item
  • Use the Name Manager
  • Use a reference name in a formula

Tables and Layout

  • Automatic formatting of tables
  • Create a custom style and apply to a table
  • Conditional formatting
  • Database functions: Filter and Sort
  • Cell format and formatting
  • Print the table

Exploiting Formulas in Excel

  • Relative and absolute references
  • Find and enter a function
  • Use basic formulas: Sum, Average, Max, Date
  • Use logical functions (SI), text and date
  • Use search functions (VLOOKUP, HLOOKUP)

Creating Graphical Representations

  • Select the data to be included in the graph
  • graph type: histogram, curve, sector in 2D or 3D
  • Choose a chart type as needed
  • Apply a style

PivotTable / PivotChart

  • Understand the usefulness of a PivotTable (examples)
  • Create a PivotTable
  • Formatting a PivotTable
  • Use of segments
  • Editing source data and updating
  • To highlight the desired statistics in relation to its table
  • Customize a PivotTable
  • Creating a PivotChart
  • Customize a PivotChart

Getting Started with Macros

  • Principle of operation of a macro
  • Save, write, execute macros
  • Run a macro via shortcuts (in ribbon, button, etc.)
  • Manage macros

Your VBA Training trainers

The course is given by one of the trainers below, depending on the session. They all follow the same outline, with the same exercises and course materials.

Portrait of Mamadou DEMBELE

Certitié PL-300, AWS Architect, Scrum

Mamadou DEMBELE

Mamadou Dembele est le fondateur, président et l’un des principaux formateurs de Doussou Formation. Titulaire d’un Master en ingénierie d’affaires de l’Université de Strasbourg et d’un Master 2 en systèmes d’information et communication informatique de l’Université de Haute-Alsace, il offre…

View full profile
Portrait of Danny

Danny

A graduate in Software Engineering from ÉTS, Danny has several years of experience in software development, web development, and technical training. As a full-stack developer, he works with a variety of technologies related to programming, databases, APIs, and web application…

View full profile

Prices and practical information

Preferred rate

$1,105 / participant

Public bodies and non-profits · plus taxes

Standard price

$1,301 / participant

Businesses and individuals · plus taxes

Practical information

  • Length: 3 days
  • Schedule: 9:00 a.m. to 4:30 p.m.
  • Format: Live virtual class or in person in Montreal and Quebec City
  • Payment: online (PayPal or card) when registering, or by invoice for organizations
View dates and register Quote for my employer

Corporate VBA Training training

Train your whole team as a private group, on your own documents, at your premises or in a virtual class, on the dates that suit you.

Request an offer

Participant reviews

97% satisfaction (end-of-course evaluations, 120 evaluations) · Read all testimonials

Why take this VBA Training course

Objectives: what you will be able to do

- Know the basics Excel
-Use reference names
-To manage tables and layout
-Exploit formulas in Excel
-Create a PivotTable
-Create a PivotChart
-Discover macros

Prerequisites

Good knowledge of a PC or a Max

What is included

  • Course materials and exercise files for each participant
  • Certificate of attendance
  • Optional personalized coaching after the course
  • In public in-person sessions:
    • Tea and coffee
    • Lunch at a nearby restaurant
    • Parking (in some cities)
    • Wi-Fi access

View all courses: Course to learn Microsoft Excel

Interested in the VBA Training course?

Quote for my employer Register now