ADVANCED SPREADSHEET

COURSE SYLLABUS
Course Fee

BRIEF DESCRIPTION OF COURSE

This course is designed to offer participants a flexible means of customizing 

the Excel environment with the aim of streamlining work practices. Participants 

will learn to work more efficiently by automating routine tasks and designing custom 

environments to their own specifications.  The course includes advanced subroutine 

procedures, commands, setting up of dialog boxes, menus, user input interactive message

and input boxes etc., and is aimed at expanding the student's knowledge of 

Excel features and functions.



METHOD OF EVALUATION:	Class Test/Assignments	30%         
	
			Project                 20%

			Final Exam	        30%


PREREQUISITE:	A working knowledge of the spreadsheet skills 


GENERAL OBJECTIVES

This course is designed to:

1.	Expand the participants' knowledge of the capabilities and functions of Excel macros and their use in the automation and streamlining of routine tasks.

2.	Enable participants to design and build applications to desired specifications as dictated by the work environment.

3.	Provide participants with the skills necessary to design custom environments and solve novel problems.

SPECIFIC OBJECTIVES

PART I

Understanding and Explaining the usefulness of sub routines.
Record and run a sub routine 
Understand and edit a recorded macro 
Execute a macro
Making macros do complex tasks 
Using macros to automate  tasks
Use the Visual Basic Editor Interface
Define a procedure
Structure of a procedure
Create a procedure
Public procedures
Private procedures
Define Visual Basic for Application Terms
		a.	Objects
		b.	Property
		c.	Method

Setting variables 
		a.	Define a Variable
		b.	Types of Memory Variables
		c.	Assign/set values to variables
Using input boxes 
Record movements relative to the active cell 
Create a macro that runs other macros 
Store values and objects in variables 
Change object property values 
Navigate to new objects 
Use different resources to learn about objects 
Exploring Range objects 
Simplify macros that record selections 
Manipulate range objects from VB statements 
Put formulas in cells 
Create dynamic references 
Controlling VB 
Using conditional statements and message boxes 
Creating loops 
For...Each loops 
For loop 
Do loop 
Debugging a macro 
Saving, inserting, and removing modules in a project 
Launching macros with events 
PART II

Creating custom toolbars 
Creating custom menus 
Creating custom command buttons 
Creating worksheet and workbook event handlers 
Create a custom form /Dialog box
Initializing a form 
Checking for invalid input 
Running macros from a form