|
Home
>
Training
>
Microsoft
Office 2003
Excel
2003
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
Review of formulae and functions
Getting help on functions
Relative and absolute references
Naming cells and cell ranges
Text functions: CONCATENATE
The Paste Special command
Date and time functions
Financial functions: PMT
Logical functions: IF, COUNTIF, SUMIF
Using the AND and OR logical functions
Using the LOOKUP functions
Using Excel with Other Applications
Embedding objects
Linking objects
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
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
2003 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
|
