mahapola port and maritime academy

Course On Advanced Microsoft Office Excel 200X

Apply Online
Download:Course Brochure

COURSE DESCRIPTION

Objective

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

For Whom

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

Contents

  • 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

Methodology

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

Enquire now

Duration : 14 days
Medium : English / Sinhala
COURSE FEE: Rs. 10,000.00
apply now

Course On Advanced Microsoft Office Excel 200X - Course Schedule


Next Commencing Date : 21 May 2019

Time Schedule not available.
Payment Method Amount
One Time Payment
Rs. 10,000.00
Short Term Installments
Rs. 5,000.00 X 02
Qualification Requirement

  • Mr. W. A. C. Wickramarachchi, BSc. (Hons.) Software Engineering

    Senior Manager (Training - Management & Information Systems)

  • Mr. N. P. P. Malalasekara, MSc. (Geo Information Systems)

    Training Officer (Information Systems)

  • Mr. S. M. Weerasekara, MBCS

    Training Officer (Information Systems)

There are many ways to learnHow to Apply