Support

Advanced Excel VBA

2 sessions available starting from $780.00

Subject: Microsoft Excel

Ages: All ages

Skill level: All difficulty levels

TARGET AUDIENCE & PURPOSE

Excel VBA training is for highly skilled developers who wish to add high-end automation.

OBJECTIVES

By the end of this course participants should be able to:

* Record macros
* Create an application using the recorder
* Create user-defined functions
* Work with the VBA editor
* Understand VBA concepts and features
* Create procedures and sub routines
* Work with variables
* Work with Excel objects
* Use standard programming techniques and concepts
* Create custom forms
* Program custom forms
* Modify the Excel menu system to show your macros
* Make macros start automatically

PREREQUISITES

This course assumes a sound knowledge of the standard features of Excel covered in the Introduction and Advanced courses.

COURSE CONTENT

* Recorded...

see more

TARGET AUDIENCE & PURPOSE

Excel VBA training is for highly skilled developers who wish to add high-end automation.

OBJECTIVES

By the end of this course participants should be able to:

* Record macros
* Create an application using the recorder
* Create user-defined functions
* Work with the VBA editor
* Understand VBA concepts and features
* Create procedures and sub routines
* Work with variables
* Work with Excel objects
* Use standard programming techniques and concepts
* Create custom forms
* Program custom forms
* Modify the Excel menu system to show your macros
* Make macros start automatically

PREREQUISITES

This course assumes a sound knowledge of the standard features of Excel covered in the Introduction and Advanced courses.

COURSE CONTENT

* Recorded Macros
Recording A Simple Macro, Running a Recorded Macro, Relative Recording, Running a Relative Recording, Viewing The Module, Modifying a Recorded Macro

* Recorder WorkShop
Creating a Recorded Application, Examining The Data, Recording a Summation Macro, Recording An Averaging Macro, Recording The Maximum Macro, Recording The Minimum Macro, Recording Divisional Macros, Testing Macros, Creating Objects To Run Macros, Assigning a Macro To An Object

* User-Defined Functions
Creating a User Defined Function, Using a User Defined Function, Creating Another Function, Passing Multiple Arguments, Modifying a Function, Creating a Function Library

* Using The VBA Editor
Opening & Closing The Editor, Working With The Project Explorer, Working With The Properties Window, Using The Work Area, Working With a Code Module, Running Procedures From The Editor, Setting Break Points In The Editor, Stepping Through a Procedure

* Understanding VBA
Using The Immediate Window, Working With Object Collections, Setting Property Values, Working With Worksheets, Using The Object Browser, Programming With The Object Browser

* Procedures
Creating a Command Procedure, Making Sense Of IntelliSense, Using The Edit Toolbar, Commenting Statements, Indenting Text, Bookmarking In Procedures

* Using Excel Objects
The Excel Object Model, Splitting The Screen, Using Workbook Objects, Using Worksheet Objects, Using Range Objects, Using Objects In a Procedure

* Using Variables
Creating & Using Variables, Implicit & Explicit Declarations, The Scope Of Variables, Procedure Level Scoping, Module Level Scoping, Public Scoping Of Variables, Passing Variables By Reference, Passing Variables By Value, Avoiding Variant Data Types, Using Arrays

* Programming Techniques
Programming Conventions, Communicating With The User, Prompting For User Input, Using The Input Method, Using IF To Make Decisions, Testing For Multiple Conditions, Looping a Fixed Number Of Times, Looping a Specified Number Of Times, Looping An Unknown Number Of Times

* Creating Custom Forms
Creating a Custom Form, Changing The Form Properties, Adding Text Boxes To The Form, Moving Controls, Adding Label Controls To The Form, Changing Text Box Control Properties, Changing Label Control Properties, Adding a Combo Box, Adding Option Buttons, Adding Command Buttons, Running a Form

* Programming Custom Forms
Initialising The Form, Closing The Form, Updating The List, Creating Error Checking Procedures, Running a Form From a Procedure

* Custom Menus
Creating a New Menu, Creating a Cascade Menu, Adding Menu Commands, Assigning Macros To Menu Commands, Removing a Menu

* Automatic Startup
Consolidating Worksheets by Category or by Position

* Sharing Workbooks
Programming Automatic Events, Running Automatic Procedures, Automatically Starting The Workbook

Duration: Two Days

see less

Choose from 2 available sessions:

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions

When

Please contact us for upcoming dates and/or more information about this class.

Where

  • 83 York St
    Sydney, NSW 2000

Price: $780.00

Notes: Course Inclusions * Comprehensive learning materials incl. exercise... see more

Notes:

Course Inclusions

* Comprehensive learning materials incl. exercise files
* 12 months post course telephone support
* 'Certificate of Attendance'
on completion of course
* Light lunch plus morning & afternoon tea

see less

Type

  • Class / Group Sessions



My Other Listings

Microsoft Word 2010 Introduction
Microsoft Word 2010 Introduction
2 sessions available starting from $780.00
Outlook 2010 Advanced
Outlook 2010 Advanced
3 sessions available ranging from $300.00 to $390.00
Adobe Acrobat Training
Adobe Acrobat Training
2 sessions available starting from $390.00

see all listings ยป


Found In