DURATION:
1 Day
AUDIENCE
This course is designed for Clerks, Officers,
Executives, Supervisors, Administrators, Managers of all levels; and personnel
who already know and understand and want to further enhance their knowledge and
practical uses of Microsoft Excel.
REQUIRED PREREQUISITES:
Basic knowledge of Microsoft
Excel is essential with the follow pre-requisites:
·
Have attended
Microsoft Excel – Foundation Level; OR
·
Able to switch
between task applications
·
Able to create a
spreadsheet with simple formatting
·
Create a chart
·
Print a
spreadsheet with headers and footers added
METHODOLOGY
This
program will be conducted with interactive lectures, PowerPoint presentation,
discussions and practical exercise
COURSE
OBJECTIVES
Upon
completion of this program, participants should be able to:
·
Create simple to
complex formulas and functions, like:
o
IF Functions
o
Nested Functions
·
Validate data in
a Worksheet
·
Filter data
using Auto & Advanced Filters
COURSE OUTLINE
COURSE OUTLINE
