|
|
|
|
Excel Standardisation Programme
|
|
These courses are for you if you want to:
- Become much more productive in your use of spreadsheets through the use of conventions and standard components.
- Make it easier for both you and others to understand spreadsheets.
- Reduce errors in your spreadsheets.
- Build workbooks faster.
- Make applications easier to maintain.
|
|
The objectives of the Excel Standardisation Programme (ESP)
are increased productivity and error reduction
To achieve those objectives, ESP:
- MAKES MAJOR ASPECTS OF A WORKBOOK UNDERSTANDABLE BY:
- Inclusion of standard sheets at start of workbook to correspond
to standard pages of a book such as title, contents, publications
page, preface and references.
- Creating Menu sheet to help describe structure of the workbook
- MAKES THE ORGANISATION AND PURPOSE OF SHEETS CLEAR BY:
- Arrangement of sheets into standard order.
- Colour-coding and naming of sheets to help describe the flow of
data within a workbook.
- MAKES THE FLOW OF DATA AMONG SHEETS AND WORKBOOKS UNDERSTANDABLE
BY:
- Use of Source and Destination Areas and LinkTags.
- Automatic creation of a diagram that describes the data flow.
- MAKES INDIVIDUAL SHEETS EASY TO FOLLOW BY:
- Use of named styles, indenting, outlining, titles arrangement,
cell colour conventions and good typographical style.
- MINIMISES ERRORS BY:
- Inclusion of crosschecks and validation.
- Automatic insertion of a Crosschecks sheet that monitors all
crosschecks in workbook.
- Using reliable techniques such as for file-links across
workbooks.
|
- HELPS WORKBOOKS BE BUILT FASTER BY:
- Use of the ESP add-in to insert standard components
- MAKES APPLICATIONS EASIER TO MAINTAIN BY:
- Making applications easier to understand.
- The application of conventions (named ranges, sheet names, tab
colours, named styles, indenting, lines, typographical rules,
workbook names, data flow).
- Inclusion of documentation.
- Recording of changes simultaneously at location and on Changes
sheet.
- Inclusion of a central Params sheet.
- Structuring so that a workbook can easily be split into separate
workbooks.
- Using the database approach to construction of many common
applications.
- ENABLES FASTER NAVIGATION BY:
- Navigation to and fro along the forward and backward hyperlink
trail.
- Use of the Menu sheet as a navigational aid.
- Use of the ESP add-in features.
- AUTOMATES COMMON TASKS:
- ESP Automates such tasks as copying data, matching and copying
data between tables, and placing data into reports. No ability to
write macros is necessary, though you can include any of your own
macros in a process.
|
- SEMINAR FORMAT
All four seminars have interactive lecture sessions, interspersed
with small team (two or three people) hands-on problem-solving
exercises. Computers are provided.
- POST-COURSE SUPPORT
Following each seminar, you have twelve months of unlimited free
access to AbleOwl's email hotline for all of your Excel questions.
|
- THE ESP ADD-IN
The add-in helps you apply the AbleOwl ESP standards, insert
standard components and work more productively. Included in the price
of the ESP essentials course is a single-user licensed copy of the
add-in for unlimited-time use. Note that the ESP add-in does not need
to be installed in order for any spreadsheet you create to be used.
|
Course structure:
- Excel Standardisation Programme
Duration: Three one-day seminars, one two-day seminar. Format: seminar interspersed with small team hands-on
problem solving exercises. Computers are supplied.
What you get for each course:
- The ESP add-in: helps you to apply the AbleOwl ESP standards, insert standard
components and work more productively. Included in the seminar price, you
receive a single-user licensed copy of the add-in for unlimited-time use. Note:
The ESP add-in does not need to be installed in order for any spreadsheet you
create to be used.
- Free unlimited email support for 12 months following the seminar for any Excel
question you may have.
- A well-written indexed manual explaining each of the points in detail.
- A USB flash drive containing the example files used.
- Multiple Place discount - 10% off for 3 or more places.
- Refreshments and lunch are included in the price.
- Learning in a positive environment from the leading spreadsheet company.
- A copy of each of our monthly publications: Instant, In-depth and Visual Basic Excel Sheets.
- Certificate of attendance (available on request).
Who should attend:
-
Regular users of Excel who are familiar with all of the basics. See the
agenda above.
|
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.
|
|