Categories
Capacity ProgrammesAdvanced 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