Macros Basics
The concepts and use of macros.
Recording simple macros and viewing the results.
Placing macros in the worksheet.
Naming macros.
Activating macros.
Editing Macros
Rules and conventions.
Laying out macros.
Documenting macros.
Using the macro Help facility.
Locating Problems
Locating problems in macros and pinpointing failed commands.
Basic Macro Commands
Macros command structure. Overview of some common commands, building in adaptability.
Moving the active cell around the worksheets, locating path.
Information Functions
Obtaining and using information regarding the active cell around the worksheet.
Locating data.
User Interaction
Displaying dialogue boxes to ask users to enter labels and numbers.
Validation of entered data.
Placing data into the worksheet.
Conditional Functions
Commands that perform tests and then take actions that depend on the outcome.
Conditional error testing.
Repeating routines until a condition is met.
Repeating routines a fixed number of times.
Linking Macros
Calling other macros to act as sub-routines.
Giving program control to other macros.
Optional Macro Topics
Generating text file reports on macros progress.
Using database functions.
Version manager.
Graphics.
Solver.
Course Overview:
With basic skills and some experience of Lotus of 123, the topics covered on this course will enable you to further enhance and automate your spreadsheets.
Course Duration:
1 Day
Course Pre-requisites:
It is assumed that you have a skill level equivalent to that gained through attending 123 Introductory and Advanced training courses.At the end of this course
you will be able to:
- Convert your existing knowledge of Lotus 123 in to automated macro routines.
- Interpret and edit Lotus 123 macros.
- Apply programming functions such as conditions and loops to your macros.
Price Band:
Specialised
