Starting date	Ending date	days	Time
14 Feb 2023	16 Feb 2023	T-Th	11:00am - 02:00pm
08 May 2023	10 May 2023	M-W	11:00am - 02:00pm
07 Nov 2023	09 Nov 2023	T-Th	08:00am - 11:00am

Show Less

Information Technologies

hours

language

English

Target Audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Excel or have equivalent practical experience.

01 Unit 1: Visual Basic Editor
+

Topic A: Visual Basic for Applications

Topic B: Object programming

Topic C: The Object Browser

02 Unit 2: Programming basics
+

Topic A: Data basics

Topic B: Scope of variables

Topic C: Scope of procedures

03 Unit 3: Control structures
+

Topic A: Decision structures

Topic B: Loop structures

04 Unit 4: Custom dialog boxes
+

Topic A: User forms

Topic B: Events

05 Unit 5: Debugging and error handling
+

Topic A: Errors

Topic B: Debugging

Topic C: Error handling

minimize course outline

Starting date	Ending date	days	Time
14 Feb 2023	16 Feb 2023	T-Th	11:00am - 02:00pm
08 May 2023	10 May 2023	M-W	11:00am - 02:00pm
07 Nov 2023	09 Nov 2023	T-Th	08:00am - 11:00am

Show Less

Microsoft Excel VBA Programming

Topics Covered