Last Update : 2010-06-7 





Course Duration : 05 Days
Programme No : PSTI/017
Advanced Computer Training - MS Excel (Sinhala)
Objectives :

By following this programme, participants will gain a wide knowledge of computer usage required to carry out the office activities easily

Contents :
Spreadsheet Software - Introduction
Getting Started with MS Excel
Elementsbof a Work Sheet
Selecting, Inserting and Deleting of Columns/Rows/Cells/Sheets
Split Panes and Freeze Panes
Data Type and Cell Entries
Copy Data
Selection Techniques
Formatting and Editing Cells
Deleting Data
Functions
Sort and Filters Data (Records)
Pivot Table and Pivot Chart
Excel Charts
Printing
Security Setting
Target Group : Public Management Assistants / Officers recruited on graduate scheme

Training Methodology : Lectures, Handouts, practical activities

Venue : Public Service Training Institute