Learn Excel Online

  • Overview – Learn Excel Online 
    • This course has been designed for working professionals of both the public sector and private sector. Course gives you hands-on experience of the useful functionality of any MS Excel application version to assist with learner’s daily routines.  
  • Learning outcomes
    • Introduction to MS Excel working interface
    • Formatting workbook
    • Understand basic functions
    • Understand advance functions

  • Lesson Plan
    • Introduction to MS Excel
    • Review Basic MS Excel
    • Document Saving
    • Insert a Word Art
    • Using Basic Excel Functions (Sum, Average, Count Numbers, Max and Min)
    • Using Freeze Panes
    • Using Data Sort and Filter 
    • Using Subtotal
    • Checking Spelling and Grammar
    • Page Setting and Printing Techniques
    • Creating Tables
    • Creating Charts
    • IF Function
    • VLookup Function

  • Duration 
    • Approximately 55 minutes.
    • The length of the course may depend on your absorption power to study materials. 

  • Target Audience
    • This training is designed for working professionals of both the public sector and private sector.

  • Entry Requirements
    • Students with basic ICT knowledge.

  • Medium
    • Mix of Sinhala & English

Course Information

Estimated Time: 55 Min

Difficulty: Beginner

Course Instructor

Niroshan Priyanga Niroshan Priyanga Author

Enroll Now

රු1,900.00

Introduction to MS Excel

Review Basic MS Excel

Document Saving

Using Basic Excel Functions (Sum, Average, Count Numbers, Max and Min)

Using Freeze Panes

Using Data Sort and Filter

Checking Spelling and Grammar

Page Setting and Printing Techniques

VLookup Function

What Others Have Said