Advanced Excel

ESOFT Metro Campus

Description of Course


This program is recommended for Executives, Accountants or the like who has a basic knowledge in MS excel and they need to master the advance functions of Excel.


Entry Requirements


All IT and non IT professionals


Course Content


  • Using Advanced Functions
  • Using Other Functions
  • Working with Tables
  • Working with Data Series
  • Using Scenario and Goal Seeking
  • Using Worksheet Protection
  • Consolidating Worksheets
  • Using Templates
  • Working with Views
  • Creating/Revising PivotTables
  • Sharing Workbooks
  • Using Data Tables
  • Using Auditing Tools
  • Interdiction to VBA
  • Interdiction to Macros


Basic Info

  • : 20 Hours
  • : LKR. 12,500
  • : pending
  • : Part time
  • : Certificate
  • : June / July
  • : N/A

Branch Info.

  • :ESOFT Metro Campus
  • : Head Branch
  • :No.03, De Fonseka Place, Colombo 04
  • :+94 11 7 572572

Advertistment


Related Courses (29)

CADD Centre Lanka

CADD Centre Lanka

CADD Centre Lanka

IDM Achievers International Campus

IDM Achievers International Campus

IDM Achievers International Campus

IDM Achievers International Campus

Londontec City Campus

Aquinas University College