Description

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