|
One Day
Course
This course is suitable
for users with a
basic knowledge
of Excel who want
to consolidate and
expand on their
knowledge. |
| |
|
Contents: |
|
More
advanced
formulae
and
functions |
|
Formulae
with
several
operators
Understanding
relative
and
absolute
referencing
Conditional
formulae
using
“if”,
“and”,
“or”
Preventing
rounding
errors
Using
dates
in formulae
|
|
|
Managing
workbooks
|
|
|
Inserting
and
deleting
worksheets
Controlling
page
breaks
Working
with
large
sheets
Opening
a second
workbook
|
|
|
|
Register your interest |
|
Back
to course
list |
|
|
|
|
|
|
|
Toolbars
|
|
Displaying
hidden
toolbars
Customising
and
creating
toolbars
|
|
Formatting
the
worksheet
|
|
Borders
and
shading
AutoFormat
|
|
Creating
Charts |
|
The
Chart
Wizard
Moving
and
resizing
charts
Changing
chart
type
|
|
Headers
and
footer |
|
Creating
and
customising
headers
and
footers |
|
|
|
|
(BCT),
bct.gb, birmingham commercial
training, birmingham commercial,
BCT, BET, birmingham electrical
training |
