|
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 INTRODUCTION
LEVEL COURSE OUTLINE / CONTENT |
|
Microsoft Excel XP 2003 - Introduction / Foundation
Level (1 Day) |
|
|
This one day
course is for new or inexperienced users who want to
gain a basic understanding of Excel in a short space of
time. |
|
|
Delegates
require a good understanding of PCs and familiarity with
the use of a keyboard and mouse. A basic knowledge of
Windows is assumed. |
|
|
Introduction |
 |
Identify
what you can do with Excel |
|
|
Open and
close Excel |
|
|
Screen
layout |
|
|
Excel help |
|
|
Workbooks
and worksheets |
|
|
Managing and Modifying Work Books |
|
Open, save
and close workbooks |
|
|
Create a new
workbook |
|
|
Moving
around a workbook |
|
|
Insert and
delete worksheets |
|
|
Modify
worksheet names and position |
|
|
Colour sheet
tabs |
|
|
Working with Cells and Cell Data |
|
Select,
insert, delete and move cells |
|
|
Enter and
edit data |
|
|
Insert,
select, delete and move rows and columns |
|
|
Smart Tags |
|
|
Merge and
centre cells |
|
|
Check
spelling |
|
|
Adding Calculations |
|
Build and
copy simple calculated expressions |
|
|
Use AutoSum
(extended AutoSum) and AutoFill |
|
|
Use a built
in function |
|
|
Copy a
formula |
|
|
Work with
relative and absolute cell reference |
|
|
Formatting Worksheets |
|
AutoFormat |
|
|
Apply and
modify cell formats (apply a list format) |
|
|
Formatting
Toolbar |
|
|
Numeric
format, font size and type, styles and borders |
|
|
Modify row
and column settings and format |
|
|
Clear cell
formats |
|
|
Printing Worksheets |
|
Preview and
print worksheets and workbooks |
|
|
Suppress
error values when printing |
|
|
Use page
setup to adjust margins, orientation, gridlines and
header and footer settings |
|
|
Set print
area |
|
|
Creating and Modifying Charts |
|
Create a
chart using the chart wizard |
|
|
Modify chart
items |
|
|
Format a
chart |
|
|
Change the
chart type |
|
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]
|
|
