Commercial Management with Excel Skills training centre in Bangladesh

New
Get 20% discount

Commercial Management with Excel Skills

Introduction

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.

Methodology

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
• UPAS L/C

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

Md. Delwar Hossain Bhuiyan
  • 29 Apr - 15 May 2018

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

Commercial
Md. Delwar Hossain Bhuiyan
  • 30 Apr - 30 May 2018

Over 3 million Bangladeshis are employed in this industry. ...

Commercial
Md. Delwar Hossain Bhuiyan
  • 2 - 19 May 2018 (8 sessions)

This course particularly emphasizes the guideline of ...

Commercial
Md. Delwar Hossain Bhuiyan
  • 4 - 5 May 2018 (2 Days Long)

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

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