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 2022 (Saturday) 

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 pdpcontact@sliit.lk 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

RESERVE A SEAT

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

1 Step 1
keyboard_arrow_leftPrevious
Nextkeyboard_arrow_right
TOP
en_USEnglish
si_LKSinhala ta_INTamil en_USEnglish
logo