Training List

Details of Procurement and Supply Chain Leadership

Session: 01
1. Development of Supply Chain Management:
2. What is Supply Chain Management?
3. What are the Principles of Supply Chain Management?
4. How Supply Chain Management Principles impact the efficiency and effectiveness of the operation and improve the company results?
5. What are the Critical Success Factors (CSF) of SCM and how to ensure efficiencies through KPIs?
6. What makes Supply Chain Competitive?
7. What should be functional set-up of an efficient Supply Chain Management?
8. Role of traditional Commercial and Purchasing Department
9. Revolutionary concept of Supply Chain Management (Change through change)
10. Business without border and its challenges. (Supply Chain Vs. Supply Chain)

Session: 02
1. Overview of Supply Chain and Logistics Engineering
2. Objective and components of Supply Chain and Logistics Engineering
3. Classical flow model of Supply Chain and Logistics
4. Supply Chain Micro and Macro process
5. Strategic Fit of Supply Chain and Logistics
6. Decisions whether to have Efficient or Effective Supply Chain
7. Critical Success Factors (CSF) of SCM
8. Supply Chain Drivers
9. Bull Whip Effect

Session: 03
1. Case study of any US Retail Company
2. Through this case study, we will try to understand the importance of a Supply Chain
3. Group discussions
4. Group Presentations

Session: 04
1. Elementary discussions on Operations Management
2. Forecasting
3. Operations Capacity and planning
4. Inventory Control Fundamentals
5. Quality Management System (TQM)
6. Just In Time (JIT)
7. Enterprise Resource Planning (ERP)

Details of Finance for non Finance Professionals

a) Introduction to Financial Statements - Balance Sheet, Profit and Loss Account, Cash Flow, Funds Flow.
b) Balance Sheet Analysis
c) Ratio Analysis: Key ratios
d) Time Value of Money
e) Simple and Compound Interest
f) Present Value and Future Value
g) Net Present Value, IRR, PBP, Profitability Index - Capital Budgeting
h) Capital Structure
i) Investment alternatives
j) Analysis on investment avenues
k) Security analysis

Details of Training on Land Documentation, Transfer & Registration

• Laws & Rules relating to property or land purchasing.
• What is Transfer of Property?
• Who can Transfer property?
• Transfer of property by a co-sharer.
• Transfer of joint property by joint owners.
• Right & Duties of buyer and seller of land.
• To buy a land how the buyers will verify the proposed land.
• Verification system in Land Office (Tahsil office) & AC Land’s office.
• Search System in Sub-Registry office.
• Prescribe Application form of Search, Inspection & copy.
• Fixation of Value of land.
• Sale Deed
• Sale Deeds Registration fees.
• Which Deeds Registration is mandatory?
• Deed writing.
• Prescribe Deed writing form.
• What information and document will have to enclose in the deed.
• Deed execution & Deed presentation to Sub-Register office for Registration.
• Who can present Deed to Sub-Register office?
• Submission time of Deed and its impact.
• Various fees of Deed Registration.
• TIN Certificate for Registration.
• Certificate for Registration & Registration Receipt/DDR.SRO Token.
• Sample of Receipt.
• Deed Registration by Commission & Commission fee.
• Action of Deed of property which lies in different Upazilla of same District.
• Deed Registration of property which lies in different District.
• Deed execution by minor.
• Rectification of Deeds.
• Deed Registration in favor of Institute.
• What is Bia Deed?
• Different types of Porcha, Specific Meaning of Khatian & Dag.
• Detailed Discussion on Porcha: CS, DS, SA, ROR, MRR, RS, BS, Dhaka City Jorip & Mutation.
• What is Land Development Tax?
• What is Rent Receipt (Dakhila)?
• What are the benefits of payment of Land Development Tax?
• What is Holding Tax Receipt?
• What are the benefits of payment of Holding Tax?
• What is Building Plan Approval?
• What are the benefits of building plan approval?
• What is NEC?
• Process of obtaining NEC from SRO.
• Mortgage, How to create Mortgage Deed, What is its Implementation
• Power of Attorney
• Land Documents relates to Financial Institutions, Security Documents/Collateral
• Security
• Land Documentation.

Details of Microsoft Excel - Advanced Professional Tips, Tricks and Functions

Cell Reference (Absolute Vs Relative):
What is relative & absolute cell reference?
Different types of use of references (A4, $A4, A$4, $A$4)
Managing cell reference with complex formula in easy rule

Data Re-Arranging techniques
Changing data type- Text to number
Changing data type- Number to Text
Highlighting all blanks/errors/texts within a range
Date formatting customization
Data import from text file
Finding duplicates and removing techniques
Copying/moving cell values except hidden cells
Data transposing using function and tricks

Workbook, Worksheet and PageCustomization
Row(s) to be printed at top on every page
Fixing number of pages to be printed of whole sheet
Professional printing tricks-horizontal & vertical
Do you have 100 sheets? View all sheets in a list
Auto saving techniques
Bookmarking the most using Excel files
About Excel’s compatibility checker

Ribbon and Quick Access Toolbar Customization
Activate inactivated tabs
Change or remove existing group
Add new groups in the ribbon
Add/remove tools in Quick Access Toolbar

Use Essential Functions for Restructuring Usable Data Table
Joining multiple cells
Extracting the required portion of a cell value
Removing unwanted extra spaces
Convert a cell text to your required case
Making a function as a variable
Converting a Text number to a computable pure number or date
Rounding a cell value in different ways
Join a text with formatted number.

Convert Number in Words Automatically
Procedure to convert a number into words

Logical Functions and Operators
IF() Condition and expression of logical test
Use of AND, OR and NOT
Nested IF() with other functions

Lookup & References
Calling the required information matching a text/number
Vertical Lookup function- VLOOKUP
Horizontal Lookup function- HLOOKUP
Complex uses of VLOOKUP/HLOOKUP
2-way lookups- auto matching lookup value and column heading
MATCH function and INDEX function
Combination of MATCH and INDEX function
Dynamic reporting using INDIRECT function
OFFSET function

Naming in Excel
Examples of various types of name
Name type-Cell reference, range of cells, formula and constant value
Use name in a formula and avoid complexity

Date Functions:
Do you know how many mistakes are you doing every day using date??
Separating DAY, MONTH and YEAR from a complete date
Presenting day name and month name from a date
Combining date with a text (Report Date: 31/Dec/2014)
Calculating future date adding years, months and days
Calculating date difference using DATEDIF()
Preparing age calculator (Example: Your age is 25 Years 05 Months 16 Days)

Data Validation and Protection
Protect your workbook so that it can be used by anyone with a limited range
Locking and protecting cells
Hiding Excel formula
Restriction incorrect data entry with data validations
Creating list with static values or a dynamic range
Creating error validation messages
Create your Workbook password protected

Decorate Your Report Using Advanced Conditional Formatting
Format automatically when your required criteria meet true
Using multiple Conditional Formatting in a range
Using Data Bars, color scales and icon sets for great presentation
Advanced formula based Conditional Formatting

Advanced Data Sorting & Filtering
Multi-level data Sorting using multiple conditions
Finding unique records or duplicate records
Removing Duplicates at the same range
Data filtering using multiple conditions
Multi-level data filtering with customized conditions
Customized filtering using IF () condition

Error Handling and Cleaning Reports
Type of Excel errors and when it occurs
Circular reference
Error handling using ISERROR, IFERROR and other functions
Magic tips to find error cells and cleaning
Formula tracing and debugging techniques

Data Linking Techniques
Introduction of data linking
Data linking between multiple worksheets
Data linking between multiple workbooks
Managing linking and updating
Difference between direct and indirect linking

Describe Your Data Using PivotTables, PivotChart and Slicers
Data mapping to prepare a PivotTable
Understanding PivotTable Field List
Row Labels, column labels, values area, report filter
Examples of various types of PivotTable in different angles
Various types of report layout-report in compact form, report in tabular form
Customizing subtotal at any row label data and subtotal category
Changing PivotTable data source
Inserting a calculated field and calculated item
Drill-down to the Pivot data
Summarizing data by month, quarter, year etc. from date
Decorating reports and changing styles
Containing customized data format that will not be changed on refresh
Containing customized column width that will not be changed on refresh
Applying conditional formatting to a PivotTable that will not be changed on refresh
Decorating PivotTable report using “Data Bar”, “Color Scales” and “Icon Sets”
Sorting and filtering techniques in PivotTable data
What is slicer in PivotTable?
Creating, changing and formatting slicer
Make your PivotTable dynamic using slicer
Filling empty cells with zero (0)
Creating PivotChart from existing workbook data
Make your PivotTable data source dynamic

Data Summarizing Techniques from Large Data
Data summarizing from a large dataset using functions
Basic & advanced SUMPRODUCT function
COUNTIFS, SUMIFS and AVERAGEIFS functions
Use these functions with multiple criteria and conditions
Data summarizing using INDIRECT linking

Data Consolidation from Multiple Data Range
Data Consolidation Using 3-D References
Data Consolidation Using "Data Consolidate"
Preparing a sample OPEX budget

Creating Chart and Visual Presentation
Data visualization using Sparklines
Choosing the perfect chart for your data
Creating various types of Charts-Column, Bar, Pie, Line etc.
Customize your chart’s labels, axes and background
Use different chart type for different series within a chart

Macros (Basic): Automate Your Excel Action
Overview of macro in Excel step by step
Create your first macro without having any programming knowledge
Automation techniques using macro
Creating macro to generate report using criteria
Carefulness of macros!

Problem Solving Session
Share your Excel problem
The facilitator will share some critical real cases
Group work with brainstorming

Details of “Master Class on Dashboard Reporting Using MS Excel”

INTRODUCTION OF DASHBOARD REPORT IN MS EXCEL
What is Dashboard report and how to develop?
Components of Dashboard report
Purposes and benefits
Essential rules should be maintained to develop dashboard in Excel
Summary report interaction using various parameters
What to do and what not to do for developing Dashboard report

DATA SUMMARIZATION AND INTERACTION TECHNIQUES
Data summarizing using multiple criteria and conditions
Advanced SUMPRODUCT function
COUNTIFS, SUMIFS and AVERAGEIFS functions
Data summarizing using INDIRECT linking

DASHBOARD PROJECT-1

USING PIVOTTABLES, PIVOTCHARTS AND SLICERS TO DESCRIBE DATA
Data mapping to prepare a PivotTable
Understanding PivotTable Field Lists
Row Labels, column labels, values area, report filter
Fixing PivotTable’s output area
Fixing PivotTable’s data format
Techniques to apply conditional formatting to a PivotTable
Creating PivotChart from existing workbook data
Make your PivotTable data source dynamic
What is slicer in PivotTable?
Creating, linking, changing and formatting slicer
Dashboard techniques using PivotTable Components

DASHBOARD PROJECT-2

ADDING CONTROLS AND LINKING WITH SUMMARY TO INTERACT REPORT DYNAMICALLY
Get introduced with Form Controls
Inserting and Controlling Form Controls
Button, Check Box, Option Button, List Box,
Drop-down, Spin Button and Scroll Bar
Where will you use form controls?
Interaction of tables and graphs using controls
Linking drop-down or option button with summary and charts

DYNAMIC GRAPHICAL OR VISUAL PRESENTATION
Data visualization using Sparklines and charts
Choosing the right chart for your dashboard
Using static and dynamic chart
Make your chart data source dynamic
Creating and customizing layout and design
Special chart (thermometer) for target/growth/progress analysis
Link your chart with drop-down or option button
Interact your chart using various objects

DASHBOARD PROJECT-3

USING ADVANCED CONDITIONAL FORMATTING IN DASHBOARD
Multiple Conditional Formatting-manage rule
Using Data Bars and icons for great presentation
Changing Data Bars and Icons parameter
Formula based Conditional Formatting

PROTECT AND VALIDATE DASHBOARD REPORT AND RAW DATA
Locking and protecting Dashboard report sheet
Restriction incorrect data entry with data validations
Creating list with static values or a dynamic range
Create your dashboard password protected

ERROR HANDLING AND CLEANING DASHBOARD
Error handling techniques in different ways
Formula tracing and debugging techniques
Make your dashboard clean avoiding errors

EXCLUSIVE MASTER PROJECT SESSION TO BUILD AN INTERACTIVE DASHBOARD REPORT
DASHBOARD PROJECT-4

PROBLEM SOLVING AND BRAINSTORMING SESSION AND OPEN DISCUSSION
Share your Excel problems
Open discussion regarding Excel issues

Details of Microsoft Excel-PivotTable Comprehensive Features with Advanced Reporting

SESSION-1
Introduction of PivotTable in Excel-2010
Structure of a PivotTable
Data mapping to prepare a PivotTable
Creating a PivotTable in Excel
Understanding PivotTable Field List
Row Labels, column labels, values area, report filter
Examples of various types of PivotTable in different angles
Various types of report layout-report in compact form, report in tabular form
SESSION-2
Automated page break after each item group
Customizing subtotal at any row label data and subtotal category
Changing PivotTable data source
Changing type of calculation in value fields
Creating a running sum column in values field
Inserting a calculated field and calculated item
Decorating reports and changing styles
Containing customized data format that will not be changed on refresh
Containing customized column width that will not be changed on refresh
Applying conditional formatting to a PivotTable that will not be changed on refresh
Sorting and filtering techniques in PivotTable data
What is slicer in PivotTable?
Creating, changing and formatting slicer
Make your PivotTable dynamic using slicer
SESSION-3
Drilling down of PivotTable data
Filling empty cells with zero (0)
Sharing PivotTable to the web using web services in Excel
Expand/Collapse the group (manually & automatically)
Show text in PivotTable values area
Creating PivotChart from existing workbook data
Creating PivotChart from external data source (from Access/SQL Server)
Create PivotTable using multiple consolidation ranges
Make your data source dynamic
SESSION-4
What is PowerPivot Add-Ins?
PC Requirements and process to install PowerPivot in Excel 2010
Activating PowerPivot in MS Excel-2010 and 2013
Clear concept about Excel table
Creating PivotTable using PowerPivot window linking tables within the Excel workbook
Creating PivotTable using PowerPivot window linking tables/queries from external data source (from Access/SQL Server)
Creating relationships among the tables
Creating Data Model
Creating calculated column using Data Analysis Expression (DAX)
Techniques to use fields and slicers from PowerPivot Field List
Data presentation and BI reporting
SESSION-5
Overview of automated Excel dashboard
Techniques to create Excel dashboard

EXCLUSIVE PRACTICAL SESSION-PREPARING AN AUTOMATED INTERACTIVE REPORT USING PIVOTTABLE

Overview of the Whole Session
Consolidation of Learning
Brainstorming
Q & A Session

Details of Management Skills for New Managers or Non Managers

1. Introduction
Power of Motivation:
2. Management & Managers
3. Role of the Supervisor
4. What does the company expect from supervisors?
5. What do employees want from their jobs?
6. How to deal with the needs of your employees:
7. Functions of Management
8. Theories of Human Nature
9. Types of Managers
10. What are the Roles of a Manager?
11. Managerial Skills
12. Attitude
13. Managing Request
14. Managing Working Relationships
15. Interpersonal Relationship
16. Motivating
17. Appreciation
Management Skills:
18. Supervising staff
19. Developing staff
20. Negotiation
21. Effective Communication
22. Listening Skill
23. Time Management
24. Priority Setting
25. Stress Management
Leadership and Team Building:
26. Team Work
27. Leadership & Management
Innovations:
28. Improvement of Productivity
29. Perform effectively and efficiently

Details of Skill Development for Floor Supervisors

Introduction:
Management Skills:
1. Behavior
2. Attitude
3. Leave Management
4. Relationship
5. Effective Communication
6. Listening Skill
7. Loyalty
8. Skill
9. Team Work
10. Motivating
11. Time Management
12. Training
13. Employee Engagement

Supervisory Skills:
14. Motivation
15. Lean Six Sigma
16. Productivity & Efficiency
Labor Laws & Rules:
17. Working Hours
18. Disciplinary Actions
19. Termination
20. Grievance Handling
21. Industrial Relations
International Conventions:
22. Business Responsibility and Human Rights
23. Most Common Human Rights violations in Business
24. Respect for Labor and Human Rights
25. Right to Non Discrimination.

Details of IT Management for Non-IT Managers

1. Information Technology as a service
a) Information technology as a service
b) Types of IT asset
c) Generic IT solution
d) Solution in multiple layer [Application, System, Network etc ]
2. Information Security
a) Business goodwill and information security
b) Digital Security management consideration
3. Development and Adapting new technology
a) Organizational need identification
b) Concept of Cloud computing: IaaS, PaaS, SaaS
c) Business Intelligence and Big-data: Trigger, Challenge, & management
4. Managing IT development
a) IT project management – the waterfall method
b) Why managing software projects are different than other project project
c) Optimization approach
5. SLA planning and management
a) Outage Impact
b) Contingency Planning
6. Technology Identification
a) Open Source, Closed source software
b) On the shelf, cusotmized and in-house developed software
7. Ethical & Social issues in managing IT
a) Environment friendly IT : Green IT
b) IT as a development tool
8. Strategic outsourcing : IT dependency and cost management

Details of Google Marketing Essential Training for Business Growth

-An overview of Google Marketing
-An overview of AdWords
-Account Management
-Campaign and Ad Group Management
-Keyword Targeting
-Language and Location Targeting
-Budgets and Bidding
-Measurement and Optimization - I
-Measurement and Optimization - II
-Measurement and Optimization - II
-Performance, Profitability, and Growth - I
-Managing Multiple Accounts
-Search Fundamentals Review
-Ad Formats
-Ad and Site Quality
-AdWords Tools
-Performance Monitoring and Reporting
-Optimizing Performance
-Performance, Profitability, and Growth
-AdWords API
-The Google Display Network
-Display Ads on You
-Display and Video Ads on Mobile Devices

-An introduction to web analytics in general, and Google Analytics in particular
-The dozens of reports Google Analytics provides you "out of the box"
-How to generate actionable insights from your website’s data
-How to measure business outcomes rather than just count users
-How to build reports and dashboards that really bring value, and ultimately revenue, to your business

Details of Health Risks and Rescue at Work Place

Introducing Health Risks at Work
Rescue Health Risks at Work
Introducing Health Risks at Work In Depth
Rescue Health Risks at Work In Depth
Risks to your breathing
Rescue from your breathing problems
Risks to your skin
Rescue from your skin problems
Risks to your muscles, bones and joints
Rescue to your muscles, bones and joints issues
Risks and rescue to your hearing and touch
Risks and rescue to your wellbeing
Where to get help

Details of Workplace Psychological First Aid

Welcome

Module 1: Introduction to PFA
Simulation

Reflective Listening/Rapport

Module 2: Reflective Listening/Rapport
Simulation
Assessment

Assessment and Prioritization

Module 3: Assessment
Simulation

Module 4: Prioritization
Simulation
Assessment

Intervention and Disposition

Module 5: Intervention
Simulation

Module 6: Disposition
Simulation
Assessment


Self-Care and Wrap-Up

Module 7: Self-Care and Wrap-Up
Assessment

Details of Essential Features of MS Excel - 2010

Start Working with Microsoft Excel 2010
The Excel-2010 screen
Introduction of ribbon
Recognizing the essential tools
Customizing quick access toolbar
Sheet moving in the same workbook and any other workbook
Quick tips to page setup
Worksheet scaling to print
Print large data professionally and save papers
Column headings to be printed at top on every page

Managing Workbook with Big Data
Full screen print preview in Excel-2010
Make a certain range that will be visible all the time
Do you have 100 sheets in a workbook? Manage professionally

Cell Reference (Absolute Vs Relative):
What is relative & absolute cell reference?
Different types of use of references (A4, $A4, A$4, $A$4)
Managing cell reference with complex formula in easy rule

Use Essential Functions for Data Re-Structuring
Techniques to resize your downloaded data from ERP
Extracting the required portion(LEFT/RIGHT/MIDDLE) of a cell value
Joining multiple cells
Removing unwanted extra spaces and texts
Convert a cell text to your required case
Format cell values quickly

Logical Functions and Operators
IF() Condition and expression of logical test
Use of AND, OR and NOT
Nested IF() with other functions

Lookup & References
Vertical Lookup function- VLOOKUP
Using VLOOKUPs for different purposes

Data Validation, Protection and Workbook Security
Protect your workbook so that it can be used by anyone with a limited use of Excel
Locking and protecting cells
Restriction incorrect data entry with data validations
Creating list with static values or a dynamic range
Creating error validation messages
Create your Workbook password protected

Using Advanced Conditional Formatting
Format automatically when your required criteria meet true
Using multiple Conditional Formatting in a range
Using Data Bars, color scales and icon sets for great presentation
Advanced formula based Conditional Formatting

Using Name in Excel
Examples of various types of name
Name type-Cell reference, range of cells, formula and constant value
Use name in a formula and avoid complexity

Advanced Data Sorting & Filtering
Multi-level data Sorting using multiple conditions in different angles
Finding unique records in a range and paste at another place
Removing Duplicates at the same range
Data filtering using multiple conditions
Multi-level data filtering with customized conditions

Error Handling and Cleaning Data
Type of errors and when it occurs
Circular reference
Carefulness for errors!
Error handling using ISERROR and IFERROR function
Magic tips to find error cells and replacing quickly
Formula tracing and debugging techniques

PivotTables, PivotChart and Slicers
Data mapping to prepare a PivotTable
Understanding PivotTable Field List
Row Labels, column labels, values area, report filter
Examples of various types of PivotTable in different angles
Various types of report layout-report in compact form, report in tabular form
Customizing subtotal at any row label data and subtotal category
Changing PivotTable data source
Inserting a calculated field and calculated item
Drill-down to the Pivot data
Summarizing data by month, quarter, year etc. from date
Decorating reports and changing styles
Containing customized data format that will not be changed on refresh
Containing customized column width that will not be changed on refresh
Applying conditional formatting to a PivotTable that will not be changed on refresh
Decorating PivotTable report using “Data Bar”, “Color Scales” and “Icon Sets”
Sorting and filtering techniques in PivotTable data
What is slicer in PivotTable?
Creating, changing and formatting slicer
Make your PivotTable dynamic using slicer
Filling empty cells with zero (0)
Creating PivotChart from existing workbook data
Make your PivotTable data source dynamic

Overview the Whole Session
Consolidation of the learning
Q&A Session

Details of "Changes of VAT Acts, Rules, SRO, Rate of duty in this FY-(16-17)''

1st Half:

First session:

Introduction

Latest changes in FY (16-17) budget
Brief history, Background, Mission & role of VAT
National Board of Revenue (NBR) at a glance
NBR roles in import & Export product
General features of VAT (Indirect taxation) system of Bangladesh
VAT at manufacturing & trade point

How does VAT works, Tax liability, net work & value addition
Characteristic & Input tax credit mechanism of VAT
VAT- able product, services, VAT exemption & tax rate
Cottage industry & turnover tax
Registration process of manufacturer, services, traders & importer
Stages of VAT, when it payable & how?
ECR & advance trade VAT
Value calculation & payment of tax
Tariff value, Excise duty & obligation of VAT unit
When to pay? & mode of payment
Submission of return, Record keeping & Right of Tax payer
Offence, penalty, adjudication & dispute statement
Different forms on VAT
Dispute & Need

Second session:

VAT at Service sector

Network/Scope, Exemption, calculation
Registration process
Tax base/procedure of VAT
Truncated base &VAT at source
VAT payment &collection System
Central Registration Process
VAT on Banking & Insurance Sector
Hotel, Restaurant, Construction firms and Building Developer
VAT system on Export, Deemed Export and Bond
Various reporting Under VAT law
Refund system

2nd Half:

Third session:

Valuation System

Tax base & determination of assessable value for VAT
Different kinds of value
Legal provision
Declaration & Calculation of value
Components of value
Value approvals
Fourth session:

Adjudication & Appeal

What is Adjudication?
Offences for adjudication
Power of adjudication
Imposition of penalties
Adjudication process
Record Keeping and Accounting in VAT

Importance of record keeping in VAT
Obligation & Record keeping
Characteristics of VAT as a tax system
Record keeping (mainly)
Commercial documents
VAT Accounting and Payment Procedures
Question & answer

Details of Customs Procedures & formalities with all the changes in this FY-(16-17)

-Customs mission, role and stakeholders
-Latest changes in FY 2016-17 budget
-Government policies of import and export at present
- HS Code, Valuation & duty calculation
-What to do before, during and after import and export
-Tools, regulations and customs procedures
-know how to minimize cost of business and what not ?

First session
1) National Board of Revenue (NBR) at a glance
2) What is customs? Its Mission & role
3) Stakeholders & Government agencies
4) Customs administration, area, agencies & allied acts
5) Government policy of import & export at present
6) What to be done before, during & after import & export
7) Tools & regulations of import & export
8) Import & export complex Procedures & feature of Customs
9) Major roll of customs & its modernization

Second Session
10) Duty structure, barrier, present rate of duties & duty exemptions
11) Banned, restriction & conditional import& export items
12) Harmonized system, Classification rules & 1st schedule
13) Valuation system in Bangladesh & Base value of duty
14) Import & export formalities/clearance process
15) ASYCUDA world BoE Process & duties of Customs officials
16) Appraisement & Assessment system
17) Import/Export Manifest declaration & Most important documentation
Third Session
18) Bonded Warehouse module
19) What is a warehouse & Bonded warehouse?
20) Special Bonded Warehouse (SBW) Operator’s Functions
21) Bonded warehouse, its facilities & Duty Drawback system
22) Temporary import & export
23) Export incentives (IPO)
24) Abatement, Refund system
Fourth Session
25) Airport/Air cargo import & Airport declaration
26) Area of dispute, legal solutions, Appeal & settlement
27) Port charges or demurrage etc. (minimize cost of business)
28) Baggage rules & Fixed duty & taxes under Baggage Rules
29) Role of clearing and forwarding agent in import and export
30) Risk area & its management
31) Rights of the Importer/Exporter
32) Important section of Customs Act
33) Discussion,
Question &Answer

Details of Practical Accounting

Session 1: Getting Introduced to Double Entry Systems
Key concepts of accounting
Understanding Debit and Credit Mechanisms and Getting Rid of Misconceptions
Journalizing in practical way
Developing spreadsheet models to store and classify all debit credit accounts.

Session 2: General Ledger Maintenance and Accounts Management
Understand the overall accounting process
Developing Chart of Accounts
Creating and Updating Ledger Accounts
Developing Spreadsheet Models for Accounts Management

Session 3: Using Accounts Balances for Regular and Periodic Financial Reporting
Preparing Trial Balance Manually and Automatically from Spreadsheet Models
Prepare Profit and Loss/ Income Statement (Regular and Periodic);
Prepare Cash Flow Statement (Regular and Periodic);
Prepare Balance Sheet (Regular and Periodic)

Session 4: Internal Auditing, Adjustments and Corrections
Know how to audit accounts for finding scopes for Adjustment and Corrections;
Adjustment in Practical Accounting;
Correction in Practical Accounting;
Prepare Adjusted and Corrected Financial Statements (Automatic and Manual)

Session 5: Practical Cost Accounting
Develop Key Concepts of Cost Accounting;
Practical Methods of Costing your Products and Services;
Conduct Break-even Analysis and Report to Top Level Management;
Practical Approaches to Budgeting.

Session 6: Efficient use of Spreadsheets and Accounting Software Packages
Get introduced to Programming for Accounts Management in Excel;
Get introduced to Standard Accounting Packages;
Know how to develop an Accounting Information System;
Steps toward strategic issues and top level Accounting

Details of Understanding Accounting Source Documents for Professionals

Ice Breaking
Concentration
Team Work and Team Management
Definition:
1. Accounting, Budgeting and Financing
2. Accounting documents Vs. Source documents
3. Accounting Concepts
4. Accounting Control System
5. Accountant's liability
6. Accountant
7. Internal control and internal check

Brief discussion
What is common about source documents?
What should be done with the source documents?
• Types Of Accounting Source Documents
o Quotes
o Orders
o Delivery Dockets
o Sales and Purchase Invoices
o Credit and Debit Notes
o Payment/Remittance Advices
o Cheques
o Receipts
o Deposit Slip
o Other

• Uses of accounting documents
• Filing the Documents
• Contents and clarification of accounting documents
• Uses of Source Documents
• Types of payment
• Types of receipt
• Application of Internal control and internal check
• Company’s accounting policy
• Retention & Filing of accounting and Source Documents
• Accounting report and Financial statement

Question and Answer Session
Conclusion

Details of Credit Risk Management in Business: Theories and Practices

1. Identifying and quantifying the risk
1.1 Defining risk and credit risk
1.2 Importance of credit risk and its interaction with other risks
1.3 Seven C’s of Credit Risk
1.4 Categories of credit risk:
Risk types: lending risk, issuer risk, contingent liabilities, settlement, transfer/country risk
1.5 Methodologies for quantifying the exposures
1.6 Exercise: types of risk for a single customer.
2. Credit Analysis
Financial statement analysis
a) Ratio Analysis
b) Liquidity Ratios
c) Turnover Ratios
d) Profitability Ratios
e) Leverage Ratios
f) Elements of Cash Flow Statement: Direct Method, Indirect Method,
g) Calculating and interpreting Cash Flows Operating Cycle, Cash Conservation Cycle, and Capital Investment Cycle
Non-financial analysis
h) Economy analysis
i) Industry analysis
j) Business analysis
3. Credit assessment and evaluation techniques
a) Assessment and evaluation of Project Loan including BMRE
b) Assessment and evaluation of Working Capital Loan
c) Assessment and management of Trade Credits
d) Assessment and evaluation of Import Credit
4. Managing credit risk
a) Credit limits, concentration limits, and safeguards thereof
Credit Policy Manual
Credit Operation Process
Credit procedures
b) Credit approval authorities and transaction approval process
c) Aggregating exposure limits by customer, sector, correlations
d) Credit mitigation techniques: collateral; termination clauses, re-set clauses, cash settlement, netting agreements
e) Applications and risks of mitigation: wrong way trades
f) Documentation: covenants, primary security, collateral security
g) Exercise: managing credit risk exposure
5. Cost of Credit
Cost of credit concepts: cost of fund, administrative costs and premium appropriate to risk class
Risk Adjusted Return on Capital (RAROC)
6. Portfolio Management
a) Credit portfolio management techniques: syndication, sub-participation, whole loan sales, credit derivatives, securitization
b) Exercise: portfolio management at a major international bank

Details of Credit and Collection Management of Corporate

Session 01
Working Capital Credit Management
Components of working capital; Operational and financial impacts of components of working capital; Working capital strategies/approaches: Conservative Strategy, Aggressive Strategy and Hedging (Maturity Matching) Strategy

Session 02
Receivable Management (including fundamentals of inventory management system):
Cash Discount, Collection Procedures, Collection Policy, Credit Period, Credit Policy, Credit Quality, Credit Standards, Incremental Profit, Credit Policy Issues, Carrying Costs, Economic Order Quantity, Just in Time Production System, Lead Time, Non-value adding activity, Order Lead Time, Ordering Costs, Reorder Point, Safety Stock, Stock-out Costs, Value adding activities,

Session 03
Analysis of Personal Lending propositions
Character, Ability, Margin, Purpose, Amount, Repayment, Insurance

Session 04
Interaction between Lender and Customer
Understanding behaviors, Effective Communication, Building (and maintaining) rapport, Interview techniques

Session 05
Credit monitoring
Monitoring the Lending Portfolio, Customer Interactions (revisited), Negotiation Skills, Bad and Doubtful Debts, Legal framework of monitoring and collections.

Details of Essential English for Front-Desk Professionals

Day One Training Contents

Session 1: 10:00 am
Email Correspondence:
10 most crucial email expressions
3 paragraph email patterns
CC or BCC?
Replying to clients’ enquiry mails
Session 2: 11:30 am
Dealing with clients:
Answering the phone & responding to the inquiries
Essential phone conversation phrases
Practice with authentic telephone conversations.
Session 3: 2:00 pm
Handling with Complaints
Complaints language
Making and replying to complaints
Practice with complaints

Session 4:3:30 pm
Face to face with customers
Basic socializing language
Small talk
Follow up
Meeting Do’s and don’ts
Writing Incubator: 4.30 pm

Training: Day 2
Session 1: 10:00 am
Review of day 1
Formal & Informal writing
Firm but polite language.
Five Cs of customer care writing
Session 2: 12:00 am
Essential grammar
Right forms of Verbs
Active & Passive writing
Subject verb agreement
Session 3: 2:00 pm
Call Centre success
Taking an order
Hotline troubleshooting
Clarifying and explaining
Session 4: 3:30 pm
Participants’ Individual case Presentation
Language Incubator: 4.30 pm
** Special four-hour intensive language incubator practice

Page 8 of 9, showing 20 records out of 179 total, starting on record 141, ending on 160

1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9

Powered by - Business Express