|
|
|
|
ESP advanced - agenda
|
| Format: seminar with hands on sessions - computers will be provided |
| Duration: two days |
| Arrival and refreshments: 9:00 am |
|
Start: 9:15 am |
|
Finish: 4:30 pm |
|
|
Your power-packed agenda.
|
|
|
In this seminar, you set up various automated applications. You make use of many of the ESP automation components to set up these applications in a fraction of the time it would take normally.
|
|
Automate tasks:
- Greatly speed up common tasks.
- Automate data copying.
- Automate inserting row into table.
- Automate importing data and comparing against a map.
- Automate matching and copying data from table to table.
- Automate merging multiple units’ data into one sheet.
- Automate placing data into reports.
- Use ESP tools to rapidly build the reports.
- Include crosschecks.
- Locate codes missing from reports.
- Drill down.
- Automate multiple tasks in one process.
- Include your own macros in an automation process.
Create maintainable applications:
- Set up applications so that updates can easily be provided without loss of data.
- Use the database approach for speed of setup and maintenance.
|
|
“Build Your Own Application” workshop:
- Build an application of your own with the use of the automation components. If you wish, bring along a spreadsheet of your own to work on.
Learn good spreadsheet design:
- Understand the pros and cons of different layout structures.
- Discover how memory is used.
- Be aware of various factors that affect calculation speed and learn techniques for faster calculation.
- Learn procedures to create well-designed spreadsheet applications.
- Discover testing techniques.
Discover good macro-writing rules:
- Learn the ESP macro conventions for naming, structure and much more.
|
|
|
|
Who should attend:
-
You should be familiar with all material covered in the ESP essentials, ESP next step 1 and ESP Next
Step 2 courses. As you will be further enhancing some applications with custom macros, you should
have a basic understanding of macro-writing, and should already know how to record a macro and to
create a button to run a macro.
|
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.
|
|