Workshop on Advanced Excel for Professional (English Medium)

NIBM

Department

Business
NIBM Programmes

Campus

Colombo /
NIBM Programmes

Level

Workshops
NIBM

Duration

02 Days

ENTRY REQUIREMENTS

  • Those who seek to learn Advanced Excel for use in a business environment

Commencement

  • 31st October 2019
  • 7th November 2019

Course structure and modules

  • Basic Formulas
  • Filtering
  • Vlookup, Hlookup, Index
  • Working with forms
  • Date and Time Formulas
  • Database Functions
  • Statistical Analysis
  • Advanced Formulas & other advanced features with pivot tables
  • Trend Analysis & Graphs
  • Scenario Analysis
  • Financial Functions (with IRR)
  • Financial Statement Analysis

Programme Fees

Current Fee Structure

  • Course Fee: LKR 15,000/= (Per Day)

*Subject to change with prior notice. Conditions apply.