COURSE DESCRIPTION

To provide advanced knowledge and develop competencies on Windows Based Electronic Spread Sheet Application using Microsoft Excel

• Executives Officers / Personal Secretaries
• Management Assistant Staffs, Store Keepers
• Work Superintendents, Supervisors
• Other relevant work groups at SLPA

• Introduction to Electronic Spread Sheet Packages and its behaviours
• Introduction to Microsoft Excel
• Creating a Data Sheet
• Formatting a Worksheet / Data Sheet
• Create Formulas and use Built-in Functions
• Practice Sorting methods
• Calculate Sub totals
• Apply Conditional Formatting Concepts
• Practice Logical AND / OR / NOT operators
• Practice Advanced Filtering events
• Data Analysis using Pivot Tables
• Data export and import among Separate Sheets in Work Book
• Data export and import among Separate Work Books
• Practice to create and Activate Macros
• Print a Work Sheet
• Create, Modify and Print a Graph

All the sessions will be Lectured followed by practical sessions, discussions, assignments