Advance Excel Workshop

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

Duration:

8 Hours

Delivery Method

Hybrid

Commencing Date

Commencing Soon

Schedule

Sunday 9am to 5pm

About the Programme

The Advance Excel Training Programme 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

intro-image
  • 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
8 Hours
Hybrid
Commencing Soon
Sunday 9am to 5pm

Per Participant Fee: Per participant fee : Rs. 7687.50/-

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.

Refund Policy

Make Your Inquiry

Get a professional qualification.

We are conducting well-recognized professional development programmes, training, and workshops. Join us and grow your career path today. PHONE +94 11 754 4801 PHONE +94 11 754 4801 Contact Us 077

  • +94 11 7544132
  • +94 11 7544132
  • Cessder.kj@sliit.lk

Explore new possibilities, connect with us and grow your future every day

Refund Policy

  • The students who request for Refunds are strictly advised to Email the requirement to pdpcontact@sliit.lk
  • Only those who have made the full class fees are entitled to apply for a refund. The class fee paid as an 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