|
Are you a competent user of
Access, Excel or Word and would like to go to the next level or would
like to know how to automate routine but complex and/or time consuming
tasks using macros?
In either
case, one or more of our 2 day Programming in VBA (Visual Basic for
Applications) courses could be right for you.
You do not
have to have programming experience to do these courses but it is vital
that you are very good users of the product in question.
We have
sourced excellent courseware from Watsonia Publishing and have
supplemented this with practical examples that we know from our
consulting and training experience, are similar to the type of
automation tasks our clients are regularly undertaking, or wish to
undertake, with Office applications.
The courses
cover the following topics:
Microsoft Excel
At the completion of this course you will have covered
the following topics:
- recording and running a macro to format cells
- obtaining user input during a macro
- introduction to using variables in modules
- relative v absolute recording
- viewing a VBA module
- editing a VBA module
- automating a data consolidation process
- assigning a macro to a button or graphic
- creating user defined functions
- using the Immediate Window
- creating an Excel "add-in" file
- using the VBA editor
- using comments, breakpoints and indents
- testing and debugging VBA code
- automating the creation and manipulation of a PivotTable using
VBA
- using variables and arrays
- overview of the Excel Object Model
- using workbook and worksheet objects
- prompting for user input
- using IF to make decisions
- looping through code
- creating and running a custom form
- programming custom forms
- creating a custom menu
- assigning macros to menu commands
- programming automatic events
Our next course is on:
Thursday
6 March - 7 Friday March
Microsoft Access
At the completion of this course you will have covered
the following topics:
- The Visual Basic Editor and converting macros to VBA
- Using variables and constants
- Standard v Class modules
- Making decisions in code
- User input and message boxes
- User Functions and passing parameters
- Objects Properties and methods
- Looping through code
- Scope of variables
- DAO/ADO
- Debugging and error handling
- Updating Data with SQL in Code
- Event Driven Programming
Our next course is on:
Tuesday 25 March - Wednesday 26 March
Microsoft Word
At the completion of this course you will have covered
the following topics:
- record, run, edit and delete a macro
- create and run a Sub procedure
- open and work in the VB Editor
- create and work with variables
- create and work with functions
- create decision structures which will allow your program to
respond to different situations
- create loop structures which will repeat statements for various
purposes
- manipulate text using a variety of objects
- perform basic document management tasks
- create and run a UserForm with various controls
- create a simple program incorporating a UserForm
- create simple error handlers in your programs
- use Word's built-in dialog boxes in a VBA program.
Our next course is on:
Wednesday 26 March - Thursday 27 March
|