By admin

8-July-2018

Advance Excel Skills-Take your Analytical Skills to the Next Level

Advance Excel Skills-Take your Analytical  Skills to the Next Level

Objectives

The objectives of this training is to expand  analytical capabilities of participants by mastering  the power of formulas and functions; add a whole new level of depth and analysis to their worksheets and to discover how to take  data validation and analysis to an advanced level using the extensive array of tools built into Excel.

Who should attend?

  • Sales Agents
  • Business Development Officers
  • Human Resource Department (HR)
  • Sales Representatives
  • Accountants
  • MIS
  • Financial Analysts

How we deliver?

FDC believes on training for transformation and its methodologies changes with the change in corporate culture.

  • Participatory-led oral presentation
  • Demonstrations and practice exercises
  • Problem based learning/Sharing
  • Direct instruction
  • Trainer-led instruction

Contents I :

  • How to differentiate between Good & Bad Data
  • Excel Tables
  • Sort
  • Filter
  • Subtotal
  • Advanced Filter
  • Paste Special
  • Sheet Protection & Hidden Function

Contents II:

  • Import Data
  • Scenario Manager
  • Conditional Formatting
  • Errors
  • Average & Freeze Panes
  • Custom Number Formatting
  • Vlookup & Hlookup
  • Pivot Table

Training Details:

Training Cost: NRs. 6000 plus levied tax per head
Training time: 3 Days

Contact Number : 01-5707271, 9801898005, 9801048455