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.

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

  • Introduction
    • Changes in Excel 2007
    • Changes in Excel 2010
    • Changes in Excel 2013
  • 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
      • SUM, AVERAGE Functions
      • SUMPRODUCT Function
    • Two Essential Excel Functions
      • IF Function
      • VLOOKUP Function
    • Math Functions
      • INT, ROUND Functions
      • ABS, SQRT, SUMSQ Functions
      • LN, EXP Functions
      • RAND, RANDBETWEEN Functions
    • Text Functions
      • TRIM, VALUE Functions
      • Concatenating Text
      • Parsing with Text to Columns
      • Parsing with Text Functions
    • Date Functions
    • Statistical Functions
    • Financial Functions
    • Reference Functions
  • Tools for Analyzing Data
    • Data Tables
      • One-Way Data Tables
      • Two-Way Data Tables
    • 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

The Workshop on Microsoft Excel will be conducted in the SLIIT Metropolitan Campus (16th Floor, BoC Merchant Tower, Kollupitiya, Colombo 03).

Commencing on : – 

8 Hours - Saturday, 9.00 am to 5.00  pm

Per Participant Fee: Rs. 7,500/-

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.

For Further Details, Please Contact

Hotline :- 0773300066
General- +94 0117544802+94 11 7543184, +94 11 7543173


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

1 Step 1
Programyour full name
First Name
Last Name
si_LKSinhala ta_INTamil en_USEnglish