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)
|
|
|
|
|
|
|
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.
|
|
|
|
|
|
|
|
- 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
- WORKING WITH CHARTS
- IN-CELL CHART
TECHNIQUES
PIVOT TABLE AND PIVOT CHARTS WITH SLICER
|
|
|
|
|
|
- LEARN excellent
Formatting and Filtering tools and Techniques.
- KNOW amazing Data
Management Methods.
- SUMMARIZE data using
Pivot Table & Pivot Chart.
- PERFORM faster using
Formula and Functions.
- ANALYZE data using
different advance Charts.
- PROTECT data using
data security tools.
- POWER your Excel
skill form Basic to Advance Level.
|
|
|
|
|
Fees: Subsidize
fee of Rs. 7,499/participant
Discount : 10%
off for early birds (31st October 2019)
Payment will be paid by cash or pay order in favor of
“Blue Apple Trainers”.
Fee includes Training material, Certificate, Lunch &
Teas etc.
|
|
|
|
|
|
|
|