On this course, learners will create macros for repetitive tasks in Excel, use VBA to automate spreadsheets using program control statements, iterative loops, dialog boxes, custom forms and some basic programming techniques.
Full Day Course Price: €495 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
- Dates available on request, please call for details – 1 Day
Aimed at experienced Excel users who want to automate repetitive tasks in Excel. This course is suitable for participants who are responsible for building interactive spreadsheets for other users.
Participants should be experienced users of Microsoft Excel who can create, edit, format and print a spreadsheet. They should also be able to create Excel formulas and, ideally, should have completed one of our Excel training programmes.
GOALS AND OBJECTIVES
Having completed this course, participants will be able to:
- Create macros for repetitive tasks in Excel
- Understand VBA in order to automate spreadsheets using program control statements, iterative loops and dialog boxes
- Create custom forms
- Have a good working knowledge of basic programming techniques
Overview of the Macro Facility
When to use Macros
Efficient Storage of Macros
Recording a Macro
Absolute & Relative Record Facilities
To a Button
To a Toolbar
Viewing Recorded Macros
Editing Recorded Macros
VBA Basic Concepts
Visual Basic Editor
Objects, Methods, Properties
Using Message Boxes and Input Boxes
Using Program Control Statements
Building and Using Iterative Loops
Creating Menus for Easy Use
Stepping Through the Macro
Adding and Managing a Watch Window
On Opening a File
On Closing a File
Understanding and Using Client
Specific Project Files
Course Summary and Review