CH229

Using macros in Excel

See the training dates
  • Duration 1 day
  • Regular fee 350
  • Preferential fee 300?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory
    course

Accreditation and partners association

  • Project Management Institute 6 PDU

Objectives

Learn the ins and outs of macros and learn Visual Basic for Application (VBA).

Targeted audience

Anyone with good knowledge of Excel who wishes to automate repetitive tasks using macros, and discover Visual Basic for Application.

Prerequisite

Moderate to advanced knowledge of Excel.

Training Details

Content

  • Key concepts used to create customized solutions using Microsoft Excel macros
  • Basic techniques for recording, writing, executing and managing macros, and how integrations, use and modifications are made in Excel
  • Preparing an Excel workbook containing macros and toolbars for deployment to other users and computers
  • Activating source code protection

General Note

Use of macros covered in this course apply to the 2003, 2007, 2010, 2016 and 2019 versions of Excel.

Select the training date*

*Unless stated otherwise, all sessions are in French.
  • Quebec City

    September 16 2019 - CONFIRMED

  • Montreal

    December 10 2019

  • Quebec City

    April 7 2020

  • Montreal

    June 17 2020

Other course(s) in this category