|
Home
>
Training
>
Microsoft
Office 2002
(XP)
Excel
2002 (XP)
Advanced
1 day
This comprehensive
course will
help you
to discover
and take
advantage
of Excel's
advanced
features
and functions.
The course
is designed
for delegates
who use
Excel regularly
on a day-to-day
basis and
now wish
to harness
the full
power of
Excel.
Advanced
functions
Getting
help on
functions
Relative
and absolute
references
Naming cells
Text functions:
CONCATENATE
Date and
time functions
Financial
functions:
PMT
Logical
functions:
IF, COUNTIF,
SUMIF
Pivot
tables
Summarising
data with
pivot tables
Creating
a pivot
table
Formatting
and editing
pivot tables
Calculation
functions
Working
with fields
Hiding and
showing
detailed
data
Grand totals
and subtotals
Grouping
and sorting
items
Using
Excel with
other applications
Embedding
objects
Linking
objects
Auditing
tools
Using the
Auditing
tools
Cell precedents
and dependents
Tracing
errors
Data
analysis
Goal seeking
What-if
scenarios
This course
is designed
for delegates
who are
familiar
with Excel
to the level
of our Excel
2002 Intermediate
course,
and who
have been
using Excel
regularly
in the work
place.
10:00am
to 5:00pm
Comprehensive
course manual
included.
Refreshments
and lunch
are provided
on all courses
at the Information
Horizons
Training
Centre.
 Back
to the top
|
