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 & Intermediate Level; OR
·
Able to switch
between task applications
·
Able to perform
IF Functions
·
Able to perform
NESTED Functions
·
Able To define
And use Range Names
·
Able To use Auto
And Advanced Filter
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:
·
Analyze data
Using Pivot Tables
·
Perform What If
Analysis using:
o
Goal Seek,
Solver, Scenarios and Input Table
·
Use VLOOKUP
function to extract data
COURSE OUTLINE
COURSE OUTLINE
