PAKISTAN HOSIERY MANUFACTURERS & EXPORTERS ASSOCIATION

PHMA House, 37-H, Block-6, P.E.C.H.S, Karachi.

Tel: 0092-21-34522769, 34522685, 34544765

Fax: 0092-21-34543774, E-mail: info@phmaonline.com



To: All Members of the Association (Southern Zone)


Subject: Circular: Workshop on "Basic to Advanced Ms. Excel (2010-2013-2016)"




Through e-mail

PAKISTAN HOSIERY MANUFACTURERS & EXPORTERS ASSOCIATION
PHMA House, 37-H, Block-6, P.E.C.H.S, Karachi. Tel: 0092-21-34522769, 34522685, 34544765
Fax: 0092-21-34543774, E-mail: info@phmaonline.com 

Ref. No. PHMA/Cir-060/2019
Dated: 15th October, 2019

To: All Members of the Association (Southern Zone)

 

SPECIALIZED TRAINING WORKSHOP ON

"Basic To Advanced Microsoft Excel "

(2010 / 2013 / 2016)

on 6th November, 2019

@ PHMA House, P.E.C.H.S, Karachi. (09:00 AM to 05:00PM)

Course Overview

Nowadays speedy change in the global business environment, bring together many new challenges for us. Much of our success links on how well we can manage the data - statistics, planning, reporting - that we encounter on a daily basis. The effective and powerful tool for doing this is Microsoft Excel. Excel spreadsheets are commonly used across business to display financial information and other data relevant to the running of the business.  

 This course comprises everything that you need to know & learn about Excel. This is a comprehensive training program on Power of Excel from basic to advance level that provides you with valuable tools readily applicable at your business environment.

 

Contents

  • THE MS EXCEL SCREE N
  • QAT- CUSTOMIZATION AND APPLICATIONS
  • FORMATTING NUMBERS
  • WORKING WITH LIST
  • CHANGING VIEWS
  • PRINTING TECHNIQUES
  • CONDITIONAL FORMATTING
  • DATA FILTERING TOOLS
  • DATA MANAGEMENT TOOLS
  • EXCEL TABLE AND STRUCTURE REFERENCES

 

  • DATA SECURITY
  • APPLICATIONS OF COMMENTS BOX     
  • ADDING ILLUSTRATIONS TO SPREADSHEETS
  • INTRODUCTION TO FORMULAS & FUNCTIONS
  • NAME RANGES AND ITS APPLICATION
  • USEFUL FORMULAS AND FUNCTIONS
  • INTRODUCTION TO CHART