|
Open Public
Courses |
| Tutor led
public courses which are scheduled on a regular basis at our
SE1 London training centre. |
|
|
 |
|
Company Specific Courses |
| Company
specific courses are available for organisations that have
several employees who all need training at the same time or the
course required is not part of our normal Open Public Course
schedule. . |
| These closed
courses are ideal where tailoring of the standard course content
is required. When compared to the Open Public Course option,
they typically provide cost benefits when there are three or more
employees who need training simultaneously. |
| Courses can be
run on-site if suitable facilities exist or at our
SE1 London training centre. |
|
|
 |
|
One-On-One Mentoring -
Personal Coaching |
| Ideal for
individual delegates who have a specific requirement from the
software or where previous knowledge makes group training
inappropriate. The pace and the content of the course can then
be adjusted to the individuals exact needs. |
|
|
 |
|
Floor - Walking |
| Where
attendance on a course may not be considered appropriate, our
trainers will visit clients offices on an ad-hoc or regular
basis, resolving individual issues on a case by case basis
- delivering quick training sessions on the "front line" at the
desk. |
|
|
 |
|
|
| In addition to
classroom based courses, we also offer a substantial range of
computer (CBT) and web (WBT) based training courses. C/WBT
are alternative education methods for those individuals looking
for perhaps a cheaper alternative to traditional instructor led
(ILT) training. |
|
|
|
|
|
|
Microsoft Excel 97 & 2000 - Advanced Course (1 Day) |
|
|
This 1-day course is
for competent users who wish to use Excel extensively
and enhance their working knowledge of the program. The
course is intended as a natural progression from the
Intermediate course. |
|
|
Delegates require a good understanding of
the features detailed in our Intermediate course. Good
keyboard skills are essential. |
|
|
Improving Data Entry
and Readability |
 |
Conditional formatting |
|
 |
Data validation |
 |
Custom formats |
|
 |
Add notes using a text box |
|
|
Pivot Tables |
 |
Create Pivot
tables to summarize data |
|
|
Group and Outline
|
 |
Apply
an AutoOutline to a worksheet |
|
 |
Apply
grouping to pivot table fields |
|
|
Scenarios, Views and
Reports |
 |
Define and
save "what if" scenarios |
|
 |
Save
different worksheet views |
|
 |
Create
reports based on views and scenarios |
|
|
Advanced Functions |
 |
Logical,
Financial, Lookup and Date Calculations |
|
|
Auditing and
Troubleshooting |
 |
Use the
Audit Toolbar |
|
|
Macros |
 |
Write, edit
and run macros |
|
 |
Determine where a macro should be stored and whether
absolute or relative actions are involved |
|
 |
Run a macro
from the keyboard, a menu or a toolbar button, menu or a
shape generated using the Drawing Toolbar |
|
|
Templates |
 |
Create and
use workbook templates |
 |
|
All course contents are subject to change
with prior notice. |
|
|
|
 |
 |
Company
Specific & One-On-One Course
Pricing |
|
 |
|
|
|
Excel Company Specific Courses |
|
|
The price for company specific courses is £490 per day for up to
6 delegates, plus £65 per day for each additional delegate.
If the course is run at our SE1
London Training Centre, there is an additional charge of
£170 per day for use of the training facilities, lunch etc.
|
|
|
Prices include all course materials and are exclusive of VAT.
For courses run outside the Greater London Area at a customer's
site, the trainer's travel and and any required accommodation
expenses are charged extra at cost. |
|
|
Request a Quote |
|
|
Excel One-On-One Tuition - Mentoring, Coaching
& " Floor-Walking " |
|
|
The price for One-On-One Tuition and
"Floor-Walking" engagements is £490 per day. |
|
|
Prices are stated exclusive of VAT. For courses run outside the
Greater London Area at a customer's site, the trainer's travel
and and any required accommodation expenses are charged extra at
cost. |
|
|
Request a Quote |
|
 |
|
|
|
|
To
discuss individual requirements, or
to book a course, please do not hesitate
to contact us. |
|
|
|
E-mail: |
site.enquiry@computerliteracy.co.uk |
|
|
|
Telephone: |
0870
240 6160 |
|
|
|
|
|
 |
View a printer friendly version of this page
in a new window |
|
|
|
[Tutor Led Courses] [Open Course Schedule]
|
|