Excel for Garments & Others

  • Date : Friday, January 27, 2017
  • Duration : Morning(9:30 AM-5:30 PM)
  • No. of Classes/ Sessions : 1 Day
  • Class Schedule : 0
  • Last Date of Registration : 25 January, 2017
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.

Introduction

In Bangladesh lots of vacancies have in garments. Computer is essential for future. Most of the person here have good knowledge in work but not have enough knowledge on excel. This training will give you chance to fight in practical field to make you perfect. Also make you confident from your colleagues. Here you will find some formula & answer what you can use your practical job life. Also can gather some practical knowledge sharing which can help for future.

Methodology

Interactive Lecture, PowerPoint Presentation, Group Discussion.

Contents of Training:

Chapter 1

1. Create excel file
2. File Rename
3. Save As
4. Case
5. Word Separation & Joining
6. Zoom
7. Header / Footer
8. Short Cut Key
9. 1 sheet to another sheet without using mouse
10. 1 file to another file without using mouse
11. Date Formula
12. Format Painter
Chapter 2

13. Conditional Formatting
14. Paste Special
15. Protection
16. Uses of $
17. Data Analysis
18. Errors (Why When How)
19. Subtotals
Chapter 3

20. Formula
i) Sum
ii) Average
iii) Count
iv) Max
v) Min
vi) If
vii) Sumif
viii) Countif
ix) Vlookup
x) Round formula & 8 Uses
Chapter 4

21. Graph (Pie, Column, Line, Bar)
22. Pivot Table
23. Speak Cell
24. Macro
25. Efficiency Formula
26. Earn Min Formula
27. Work Min Formula
28. CM Formula
29. Capacity Study formula
30. Target Formula
31. SMV Formula
32. Etc & many more

Related Courses

Mr. Sajed Khan MBA
  • Friday, January 20, 2017

This training is to help participants equip with tools and ...

RMG
Mr. Sajed Khan MBA
  • Friday, January 27, 2017

To know correct fabric consumption is a primary requisite ...

RMG
Md. Sohel Zaman
  • Friday, February 3, 2017

After the training, participants will be able to understand ...

RMG
Faruque Ahmad Khan
  • Friday, February 3, 2017

Boost your merchandising career with this intensive ...

RMG

Price: Tk. 3,000+VAT

(15% VAT is applicable in every purchase.)

Contact

9140345, 9117179 , 01811 487981, 01811410862

workshop@bdjobs.com

Anyone who want to learn about excel. Specially Garments Related Person

Resource Person

Md. Sohel Zaman

GSD Certified, Consultant & Trainer

Md. Sohel Zaman worked for Givensee Group as Sr. Manager, IE & Planning. Also he worked for Opex & Sinha Group, Mast Group & Ananta Group in the same areas of responsibilities. He has been working in IE & Planning for Seven and Half years now. By this time, he trained 100+ profession.....

Interactive Lecture, PowerPoint Presentation, Group Discussion.