ADVANCE EXCEL SKILLS FOR MANAGERS

Date Till: 23 December 2019

ADVANCE EXCEL SKILLS FOR MANAGERS

ADVANCE EXCEL SKILLS

Objectives:


After the completion of this training, trainees will accomplish the following objectives:
  •  Familiarize with various concepts of Stores and inventory Management including Physical inventory checks, priorities and role in business consolidation
  •  Evaluate procedures, change and improve methods wasteful activities and excess costs
  •  Apply the acquired techniques and essential tools for the effective management of store and inventory
Who should attend?

The content is designed for the followings:
  •  All interested
How we deliver?
  •  Participatory-led oral presentation and group work
  •  Trainer led instructions
  •  Case-analyses/Case Study
  •  Demonstrations and practice exercises
Contents
  • Vlookup & Hlookup
  • Match & Indexing
  •  Name Manager with SUMIF & COUNTIF Function
  • Excel Tables
  • Sort
  • Filter
  • Subtotal
  • Sheet Protection & Hidden Function
  •  Pivot Table 
Training Details:

Cost per head NRs.4500 plus levied tax per person
Venue: FDC Training Hall
Training time: 8hours (1 day training)

Note: Participants are requested to come with Laptop (Compulsory)