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 Instructor

Niroshan Priyanga Author

 

Enroll Now

රු1,900.00

Enroll