Esoft Courses Private Courses Professional Courses in Sri Lanka

Advanced Excel

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.

  • All IT and non IT professionals

Duration :

20 Hours

Course Fee :

Rs.8,000/= (All Inclusive)

Installments: :

Installment 1: 4,800/=
Installment 2: 3,200/=

  • 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