பதிப்புரிமை 2019 © SLIIT. அனைத்து உரிமைகளும் பாதுகாக்கப்பட்டவை. வடிவமைக்கப்பட்டது மற்றும் உருவாக்கிய கருத்து 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
      • COUNT, COUNTA, COUNTBLANK Functions
      • COUNTIF, SUMIF, AVERAGEIF Functions
      • COUNTIFS, SUMIFS, AVERAGEIFS 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).

Conducted on : 14th December 2019

8 Hours (Saturday – 9 a.m to 5 p.m)

Fee Per Participant: Rs.5,650/-

Program fee can be paid at any branch of Bank of Ceylon in favor of the SLIIT current A/C 0072821605 and the receipt should be handed over to SLIIT Metro campus before the commencement of the Program.

[Program Fee can also be paid by a Credit Cards/Debit card VISA/MASTER at the SLIIT Metro Campus]

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
Programyour full name
First Name
Last Name
Telephone
Previous
Next
முதல்
ta_INTamil
en_USEnglish si_LKSinhala ta_INTamil
logo