|
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. |
|
|
|
|
|
|
|
|
EXCEL XP 2003
ADVANCED LEVEL COURSE OUTLINE / CONTENT |
|
|
Courses starting
from just £225 + VAT |
|
Microsoft Excel XP 2003 - Advanced Level (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 |
|
|
Group and Outline
|
|
Apply
an AutoOutline to a worksheet |
|
|
Apply
grouping to pivot table fields |
|
|
Pivot Tables |
|
Create Pivot
tables to summarize data |
|
|
Scenarios, Views and
Reports |
|
Define and
save "what if" scenarios |
|
|
Create
custom views |
|
|
Create
reports based on Views and Scenarios |
|
|
Advanced Functions |
|
Logical,
Financial, Lookup and Date Calculations |
|
|
Auditing and
Troubleshooting |
|
Use the
Audit Toolbar |
|
|
Add Comments
to cells |
|
|
Use the
Watch Window to track cell contents |
|
|
Use the
Formula Evaluator to troubleshoot formulae |
|
|
Use the
Links Editor to manage links between worksheets and
workbooks |
|
|
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 |
|
|
The Drawing Toolbar |
|
Add notes to
a worksheet using a text box |
|
|
Run macros from an object created using the drawing
tools |
|
|
Create
Conceptual Diagrams. Add hyperlinks to (drawn) objects |
|
|
Templates |
|
Create and
use workbook templates |
|
|
|
All course contents are subject to change
with prior notice. |
|
|
|
|
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]
|
|
