|
|
|
|
Macros short introduction - agenda
|
| Format: Lecture-style with group hands-on exercise sessions - computers will be provided |
| Duration: Half-day course |
|
|
|
Your power-packed agenda
|
|
|
Speed up everyday tasks
- Automate universal tasks with the macro recorder.
- Record a macro and discover its Visual Basic code.
- Tidy up what the recorder records.
- Make universal macros always available.
- Create toolbar buttons and on-sheet buttons to run macros.
- Discover shortcut keys and other ways to run macros.
- Record and edit a macro to automate a common task: print several reports.
Create a macro that automates many steps
- Create a macro that imports a text file, fills in missing data and inserts Total columns.
- Record relative movements.
- Have the macro place formulae into cells.
- Select a data range in which the length and width can vary.
- Debug a macro by running one instruction at a time.
- Stop Excel from displaying unnecessary prompts.
Program the flow
- Use If…Then…Else.
- Create a custom function to create shorter, easier-to-understand formulae.
|
|
|
|
|
|
Who should attend:
- Those who have mastered the basics; that includes formula construction, formatting and printing.
You are definitely not a beginner.
|
Learn in a positive environment
- Be assured the advice you get is well-proven and utilised.
- Feel free to ask questions.
- Get time away from the office and constant interruptions.
- Enjoy a friendly environment where you don’t feel you’re holding others up.
- Instantly apply what you’ve learned on return to work.
The courses cover Microsoft Excel releases XP(2002) through 2010.
Where there are differences among the covered releases, they are pointed out.
Course cancellation policy:
A course booking is considered final when an invoice is sent, and can be cancelled
up to ten working days before the course. After that, payment is expected in full
and no refund will be given.
All cancellations must be notified in writing, i.e. post, fax or email.
Another delegate may be substituted at any time.
|
|