|
This course is designed for
proficient Excel users who wish to learn how to develop programs in VBA.
Are you
a competent user of Excel who would like to take your knowledge to a new
level?
If so,
our 2 day Programming in VBA course Using Excel will be relevant to you.
We have sourced
excellent courseware from Watsonia Publishing and have supplemented this
with practical examples that approximate the type of automation tasks our clients are
regularly undertaking or wish to undertake with Excel.
This course aims to
increase your productivity by providing the skills and knowledge to create
VBA code within Microsoft Excel effectively.
At the completion of this
courseware participants will be able to:
-
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
After attending this
course you will be able to push Word to the limits and save yourself
time performing routine tasks.
Our next
courses are on:
Tuesday 16 &
Wednesday 17 August 2005
Wednesday 21 & Thursday 22 September 2005
 |
We are offering a special 10% discount for anyone booking into this
course during 2005. Click on the dates of the course to go to our
online booking form. |
|