VBA for Excel

Return to scheduleregister-button24

Course Title VBA for Excel
Course Number 900-047-EQ
Platform Windows
Duration 24 hours
Gouvernement du Québec fee (taxes incl.)
General Public fee (taxes incl.)
Schedule TBA
 Date Fall 2019
Prerequisites No programming experience is required however participants must have prior experience or knowledge ( Intermediate to Advanced Excel) in Microsoft Excel or spreadsheets
Target Audience Excels users wanting to automate tasks using VBA ( Visual Basic for Applications)
Instructor Javier Marchan
Location TBA

NB: This is a non-credit course. Certificate provided for all participants who have completed 80% of course hours.

Excel VBA Programming for Dummies  by John Walkrenbach


Course Description:

This course will focus on the fundamental concepts of VBA (Visual Basic for Application ).  The course will include a mixture of lectures and hands-on experience.

The following topics will be covered:

  • Programming Basics
  • History of VBA
  • Record Macros and Modifying Macros
  • Assign Macros to Toolbar, Buttons, Shortcut key
  • Visual Basic Editor and its options
  • Learn Procedures: Functions and Sub-routines
  • Use of Ranges
  • Use control Flow (Do…Loop, While; For… Next; Arrays and Loops and more)
  • Learn R1C1 formulas