This course is designed to give you the skills to create your own macros and commands using Visual Basic.  It is ideal for the user with little or no experience in Visual Basic and will help you to get up and running in creating your applications in Microsoft Excel. Attendees receive outstanding practical Visual Basic notes in powerpoint format to work at their own pace at completion of the course.


Course Outline

    Understanding Visual Basic for Applications 
            Objects: Their properties and methods.
            Recording Macros + Editing their code
            Controlling code with If and Select
            Methods vs. Functions
            Use Message Boxes and Input boxes
            Using Variables for values and objects
            Controlling Charts and Pivot Tables.

    How to calculate with VBA

             Loops: Do / For / For Each
             Manipulating cells and ranges
             Using Functions in VBA Code
             Using relative and absolute formulas
             Using temporary arrays
             Using array functions
             Creating your own functions

    Creating Function Procedures 
            Variables, data types and constants 
            If-Then constructs 
            “Go To” statements 
            Looping instructions

    Working with and Creating User Forms 
            Using temporary arrays
            User form buttons 
            List box techniques 
            Advanced user form techniques

    Plus
            Developing excel utilities with VBA 
            Using Excel events 
            Interacting with other applications 
            Creating and using Add-ins 
            Creating custom toolbars and menus 
            Developing under-orientated applications


» Prerequisites
Attendees should have already completed our Microsoft Excel Advanced course or have skills to this level.

» Assessment
On completion of this course, attendees will be provided with a Certificate of Participation.

» Duration
2 Days - 9:00am to 4:00pm.

» Cost
$699.00 (Inc GST) per person.

» Dates
Please visit our timetable for current dates.

» Registration
To register for this course please click here.

» More Infomation
If you require more infomation please don't hesitate to contact us.