Excel - Programming

Course Details

In this intensive 1 day course you will find the more useful advanced features. Though previous attendance at our advanced course is assumed those with a comparable understanding are welcome to enrol. Please call a course administrator for clarification.

On our courses both keyboard and mouse skills are taught. All courses are instructor led, and include comprehensive notes.

MACROS

• Macro recording and running
• Automatic executing macros
• Assign macros to buttons and graphic objects

VISUAL BASIC

• Introduction to Visual Basic for Applications
• Visual Basic Editor
• Specifying startup directory
• Create and use document templates
• Protecting Data

VISUAL BASIC PROGRAMMING

• Declarations, Main Procedures and Sub Procedures
• Statements, Operators, built-in Functions
• Using Decision statements and Looping statements
• Calling (using multiple) Macros

USER DEFINED FUNCTIONS

• Combining Expressions
• Declaring User Defined Functions
• Running Functionsd in Worksheets

PROCEDURES

• Parts of a Procedure
• Automating Repeated tasks
• Calling procedures

Venue

TBA

Dates