Copyright 2019 © SLIIT. All Rights Reserved. Concept designed and developed by Web Lankan

Advance Excel Workshop

The Advance Excel Training Program is designed specifically for beginners, intermediate and advance users who want to develop their skills in Microsoft Excel.

This workshop provides the participants a hands on Microsoft Excel experience which assist them to learn several Excel tricks and tips thus taking their career to the next level by differentiating themselves quickly and dramatically.

Further, we will conduct customize workshops based on Cooperate requirements.

In Completion a Participation Certificate will be Awarded by Sri Lanka Institute of Information Technology

  • Excel Basics
    • Moving and Selecting
    • Copying, Cutting, Pasting
    • Other Basic Tools and Configurations
  • Working with Formulas
    • Using Absolute, Relative Addresses
    • Showing Formulas in R1C1 Notation
    • Using Range Names
    • Auditing Formulas
    • Calculation Options
    • AutoSum button
    • Evaluating a Formula
    • Using External Formula References
  • Working with Charts
    • Creating a Chart
    • Locating a Chart
    • Modifying a Chart
  • Working with Functions
    • Function Help
    • Counting, Summing, Averaging Functions
    • IF Function, VLOOKUP, HLOOKUP Function
    • Math Functions
    • Text Functions
  • Tools for Analyzing Data
    • Tables
    • Pivot Tables
    • Goal Seek
  • Importing External Data
    • From Built-in Connections
    • From the Web
    • From a Text File
    • From a Database
  • Making Professional Applications
    • Documenting Your Work
    • Conditional Formatting
    • Working with Flash Fill
    • Data Validation
    • Protecting Worksheets and Workbooks
    • Adding Form Controls

Online via Zoom

Commencing on : –  20th August 2023 (Sunday) 

08 Hours , Sunday 9am to 5pm

per participant fee : Rs. 7687.50/-

The Program fee can be paid to/transferred to Bank of Ceylon in favor of the SLIIT current A/C 0072821605 and the receipt should be emailed to before the commencement of the Program.

Following are the required Payment Details:

  • Name of the Bank – Bank of Ceylon
  • Name of the Account – Sri Lanka Institute of Information Technology
  • Account Number - 0072821605
  • Branch – Kollupitiya
  • Branch Code - 034

Please include your Full Name, Home Address, NIC Number, Mobile Number, Email Address and Minimum Qualification when emailing the payment receipt.


To confirm your seat please hand over your bank slip before the class commencement to avoid any disappointments.

1 Step 1

For Further Details, Please Contact

Hotline :- 077 33 000 66
General :- +94 011 754 48 02  |  +94 11 754 31 84  |  +94 11 754 31 73
Certificates/ Transcripts/ Letters can be collected during the following days/times only.

Day Time
Monday – Friday 8.30 am – 3.00 pm
Saturday 8.30 am – 5.00 pm

Refund Policy 

  • The students who request for Refunds are strictly advised to Email the requirement to  
  • Only those who have made the full class fees are entitled to apply for a refund. The class fee paid aan installment will not be refunded  
  • Applicants who have not followed the course for more than one week will be entitled to a refund of 90% of the payment provided  
  • Applicants who have  followed the course for less than one month will be entitled to a refund of 50% of the payment provided  
  • No refund will be provided after a period of one month 
  • The course fee is not transferable under any circumstance 
si_LKSinhala ta_INTamil en_USEnglish