Commercial Management with Excel Skills training centre in Bangladesh


Commercial Management with Excel Skills

  • Date : 19 March - 04 April 2019
  • Duration : Evening(6:30 pm-9:30 pm)
  • No. of Classes/ Sessions : 6 sessions
  • Class Schedule : Tuesday and Thursday
  • Total Hours : 18
  • Last Date of Registration : 18 March, 2019
  • Venue : Bdjobs Training, BDBL Building (Level 19), 12 Kawran Bazar C/A, Dhaka 1215.


This course is a rare combination of Commercial management and Excel skills.

This training has been designed to enhance the professional capacity in commercial & Procurement area – with a customization of two subject domain. Participants, in the same course, will learn commercial management skill efficiently and start using Excel tools to get a faster and more reliable output.

These two modules are facilitated by respective subject specialists, thus, participants get the subject knowledge in full length.


Exercise, PowerPoint Presentation, Question and answer session.

Contents of Training:

Chapter 01: How to Be an Efficient Commercial Manager

Session 01:
• Government Import Policy Order
• Government Export Policy Order
• Business Licensing Procedures
• Documentation on Export & Import
• Risk & Cost Minimizing
• Various types of L/C
• UCP-600, UCPDC

Session 02:
• L/C at sight
• Various types of B/L
• Foreign Suppliers Sourcing
• Competitive procurement
• Landing cost calculation Procedures
• Cash Incentive Procedures
• L/C amendment procedures
• Activities with EPB, BGMEA, BKMEA, BTMA
• Customs Duty & VAT
• Port authority charges
• Export Facilities
• International Payment methods

Session 03:
• SWIFT Code & H.S Code
• Various types of S.R.O
• GSP & PRC Procedures
• Shipping Bill and Shipping Guarantee
• Dealing with C&F Agent and Freight Forwarding Agent
• Lien Bank and Offshore Banking
• CCI&E Permission (IRC,ERC )
• Bangladesh Bank Permission

Session 04:
• Various types of Loan
• Required documents for various types of Loan
• Master L/C & Back to Back L/C
• Bond License
• Third Party documents
• Air Freight Calculation
• Bill of Export, Bill of Entry, Bill of Exchange

Chapter 02: Excel skill for Commercial Manager

Session 05:
• Getting Started with Spreadsheet
• Exploring MS Excel
• Cells reference styles
• Cells referencing or addressing
• Excel key board shortcut
• Data modeling concept
• Data Visualization & Data Tools
• Excel function and formula stands for
• IF, nested IF, complex IF function
• Sumifs, Countifs, Averageifs function
• Lookup, Vlookup function
• Subtotal , Sumproduct function

Session 06:
• Visualization using Slicer and Timeline
• Managing table columns
• Excel chart elements
• Plotting secondary axis in chart
• Excel charts customization
• Creating charts using custom template
• Mail merge stands for Mail merge process

Related Courses

Course at Chattogram
Price 5,000 Tk + VAT
Mohammed Mizanur Rahman
  • 26 Feb - 12 Mar 2019

Comprehensive Training that will help participants to ...

Course at Chattogram
Price 2,000 Tk + VAT
Mohammed Mizanur Rahman
  • Friday, March 1, 2019

To reap the benefits of all opportunities of effective ...

Md. Delwar Hossain Bhuiyan
  • 1 - 2 Mar 2019 (2 Days Long)

Due to lack of clear understanding about the customs rules, ...

Course at Chattogram
Price 2,000 Tk + VAT
Mohammed Mizanur Rahman
  • Friday, March 1, 2019

Comprehensive Training that will help participants to ...

Professionals working in Commercial and Procurement Sectors who want to improve their management efficiency along with advanced excel skills

Resource Person

Md. Delwar Hossain Bhuiyan

Managing Director

Having achieved masters degree from University of Dhaka in 1991, Mr. Bhuiyan started his career with an international trading company and worked for LG Corporation, Korea, Sumitomo Corporation, Singapore, Mitsui Corporation, Mitsubishi Corp. Japan, Hyundai Corporation, Singapore at later stage of his life.
Mr Delwar Hossain has established his own consulting firm, Desh Consulting Ltd, and providing professional solutions in Banking, Marketing, Commercial, Documentation, Customs procedures, Shipping procedures, International Trade, E-tender, L/C, Indenting Business, C & F Agent Business, Project Profiling, Buying House and Export- Import Business.

He has trained over 10,000 new entrepreneurs, professionals, business owners, technical and management experts and still counting in.
He attended many trainings and seminars on international business and got experience in import, export, indenting and international tender business. He participated in many international tender with PDB, REB, DESA, WASA, DGDP and Biman Bangladesh Airlines. He has been with international business for about 20 years, where he deals with Banks, Insurance, Inspection Co., Customs Authority, C&F agents, DCCI, BIAA, BOI, EPB and others business related organizations.

Exercise, PowerPoint Presentation, Question and answer session.