VBA for Excel

Return to scheduleregister-button24

Course Title VBA for Excel
Course Number 900-080-EQ-2
Platform Windows
Duration 20 hours
Emploi-Québec fee (taxes incl.)
$40
General Public fee (taxes incl.)
$361.25
Schedule Tuesday & Thursday
6:30 pm – 9:30 pm
Last class on December 12 –  6:30 p.m. – 8:30 p.m.
November 21, 23, 28, 30, December 5, 7, 12
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 Brittain Hall / BH-309

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

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
TOP