MS Excel for RMG Professionals

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

Introduction

In Bangladesh, there is a lot of vacancy in garments industry. Expertise in computer knowledge is mandatory for the progression in future. Most of the person in this sector have sound knowledge regarding their working sector but they do not have appropriate knowledge on computer; i,e; excel. The training based on excel will give them the chance to cope up with their working arena through proving them compatible which will help to increase their confidence level. They will get some excel formula along with solution which is very useful in job sector. It will help them to gather some practical knowledge and enrich their skill through sharing capabilities 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, March 24, 2017

Anybody after attending the workshop would be able to ...

RMG
Mr. Sajed Khan MBA
  • Friday, March 31, 2017

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

RMG
Mr. Sajed Khan MBA
  • Friday, April 7, 2017

Knowledge on doing correct fabric consumption is a primary ...

RMG
Md. Sohel Zaman
  • Friday, April 7, 2017

This training will help you gain practical knowledge about ...

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 is working for EPIC group as a Manager Planning & Co-ordination. Also he worked for Givensee Group, Mast Group, Ananta Group & FCI Group in IE & Planning responsibilities. He has been working in same areas of responsibilities for eight & half years now. By this ti.....

Interactive Lecture, PowerPoint Presentation, Group Discussion.