You
will learn
How to
create, modify, share and revise
workbooks using templates,
automated procedures and the Web.
====================
Audience
Holders of
ECDL or MOS Comprehensive level
Certification.
Anyone
wishing to enhance their
employment opportunities.
====================
Duration
7 weeks X 3
hours
====================
Cost
====================
|
|
Overview
Spreadsheets
are now pervasive and vital tools
that are used by many. This
course is designed for the
individual who manipulates and
analyses data, prepares reports,
and who wants to realize the full
potential of modern spreadsheet
applications.
What
is covered
·
Custom number and conditional
formatting
·
One-input, two-input and
what-if tables
·
Querying and filtering
·
Data linking and consolidation
·
Charting techniques
·
Date/Time, mathematical,
statistical, financial, logical,
text, lookup and reference
functions.
·
Pivot tables, dynamic
crosstabs and named scenarios.
·
Spreadsheet auditing
·
Templates and macros
·
Spreadsheet formatting and
presentation
CERTIFICATION
Candidates
may choose to take the Advanced
ECDL test using MS Excel or the
Excel Expert Level, MOS.
Objectives
To ensure
all participants gain the skills
necessary to use their personal
Computers at an optimum level.
|
