CH229

Introduction to MS Excel Macro

  • Duration 1 day
  • Regular fee 350
  • Preferential fee 300?
  • Locations
    • Quebec City
    • Montreal
  • Laboratory
    course
  • New version

Accreditation and partners association

  • Project Management Institute 6 PDU
SUMMARY
DETAILS

Objectives

Learn the ins and outs of Visual Basic for Application (VBA) and how to master macros.

Targeted audience

Anyone with good knowledge of Excel who wishes to automate repetitive tasks and get a good introduction to the Visual Basic for Application language.

Prerequisite

Moderate to advanced knowledge of Excel.

Content

  • Key concepts used to create customized solutions using Microsoft Excel VBA macros
  • Basic techniques for recording, writing, executing and managing VBA 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

DATES*

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

    January 30 2019

  • Montreal

    February 27 2019

  • Montreal

    June 17 2019

Trainer(s) assigned(s)

Other course(s) in this category