Support

Thank you from doMore

I'd like to thank you for being involved in the doMore.com.au community and the team and I hope that you've received value from being a part of it.

doMore was our original passion project born out of the desire to help connect people wanting to learn something new with experts that could teach them over 10 years ago.

Over the years we have helped almost 70,000 learners connect with one of over 1,500 courses and providers, across the country. For that, we're very proud and grateful for your contribution.

doMore.com.au also served to teach us about how to help measure and improve business performance and inspired the launch and growth of two other companies as a result, one of which we've decided to dedicate our resources and energy to making great.

We'll be switching the site off on Tuesday 31st of July. If you have any questions or concerns, please contact us directly on [email protected].

Thanks again and good luck with your teaching endeavours in the future.

Warm regards,

The doMore team.


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 2002 / 2003 Introduction
Microsoft Word 2002 / 2003 Introduction
2 sessions available starting from $780.00
Introduction to Excel 2002 / 2003
Introduction to Excel 2002 / 2003
3 sessions available starting from $780.00
Adobe Acrobat Training
Adobe Acrobat Training
2 sessions available starting from $390.00

see all listings ยป


Found In