 |
 |
|
|
 |
 |
| |
| |
|
|
| |
|
One Day
Course
This course is suitable
for new or recent
users of Microsoft
Excel or those who
are self taught
and wish to learn
the correct and
quicker ways of
doing things. This
is not intended
as a conversion
course from an earlier
version. Delegates
will need a basic
understanding of
Microsoft Windows,
and be able to use
a keyboard and mouse.
|
| |
|
Contents: |
|
Getting
Started |
|
Exploring
the
Excel
Window
Title
bar,
menu
bar,
toolbars
Scroll
bars,
status
bar
|
|
Getting
Help |
|
|
Using
the
Office
Assistant
Other
ways
of
getting
help
|
|
|
Creating
Spreadsheets |
|
|
Entering
text
and
numbers
Saving
spreadsheets
Opening
and
closing
spreadsheets
Custom
lists |
|
Editing
Spreadsheets |
|
Selecting
cells
Editing
techniques
Clearing
cell
contents
Using
Undo |
|
|
|
|
|
|
|
|
Formulae
and
Functions
|
|
Entering
basic
calculations
Using
AutoSum
Using
basic
functions
Copying
and
moving
formulae
Understand
relative
referencing
Use
Auto
fill
|
|
Formatting
text
and
numbers
|
|
The
formatting
toolbar
Alignment
of
text
and
numbers
Using
the
format
painter
|
|
Structuring
the
worksheet |
|
Inserting
and
deleting
rows
and
columns
Inserting
and
deleting
worksheets |
|
|
|
|
|
|
|
|
|
|
|
| (BCT),
bct.gb, birmingham
commercial training,
birmingham commercial,
BCT, BET, birmingham
electrical training
|
|
|
|
|
|
|
|
|
|
|
|
|
