Advance MS Excel Skills

Categories

Capacity Programmes

Advanced MS Excel Skills

Designed For

Government Officers with basic knowledge on MS Excel and wish to update their knowledge on advanced skills in MS Excel applications.

Duration (Hrs)

12 hours

Course Fee

Rs 13,000/-

Medium

English & Sinhala

Programme Outline

  • Introduction to MS Excel
  • Speeding up Data Entry
  • Formatting Cell Entries
  • Using Formulae and Functions
  • Addressing Cells
  • Working with Databases
  • Array Formulas
  • Data Validation
  • Goal Seek Analysis
  • VLOOKUP & HLOOKUP function
  • Match & INDEX functions
  • Charts
  • Pivot Tables & Pivot Charts
  • Financial Analysis with Data Tables
  • Printing & Viewing Worksheets
  • Security Settings