VBA for Excel

Return to scheduleregister-button24

Course Title VBA for Excel
Course Number 900-047-EQ
Platform Windows
Duration 27 hours
Gouvernement du Québec fee (taxes incl.)
$54
General Public fee (taxes incl.)
$508.18
Schedule Tuesday & Thursday – 6:30 p.m. – 9:30 p.m.
 Date November 5, 7, 12, 14, 19, 21, 26, 28; December 3
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 BH-309

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 (Concepts)
  • 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
  • Create simple dialog boxes
  • Create complex forms
  • Debugging code and handling errors
TOP