mahapola port and maritime academy

Course On Advanced Microsoft Office Excel 200X



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


  • 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

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