Embedded Files
Introduction
Supply Chain Management (SCM) maximizes customer value. It also handles the transportation and storage of the materials required to make a product. It involves managing inventories and tracking finished items from their point of production to their final destination
Objective
Supply Chain Management (SCM) course helps you to find out how to optimize the flow of goods and services by following the best practices and procedures. Also how a supply chain management system comprises the flow of goods and services. Besides, you can enroll in more difficult training programs that cover supply chain risk management's significance and practical application.
Benefits
Benefits
UGC approved certificate
A concern of Daffodil International University
Recorded Video of the sessions
Class materials
Outcomes
Outcomes
Companies' Management Structure will be more organized.
Course Outline
Course Outline
Day 1
Marge and Centering
Managing List & Database Concept
Creating Workbook
Data Type
Format Painter
Day 2
Cell Reference
Offset Function
Excel Functions (Basic)
Structure of Excel Function
Order of operation
Basic Excel Formulas
DAY 3
Find and Replace
Text Find & Replace
Advanced Find & Replace
Data Validation
Basic Data Validation
DAY 4
Calculation Based on Logic
IF Function (Basic)
Multiple use of IF Function in one formula
3D Formula
Sumproduct Functions
DAY 5
Vlookup Hlookup Functions
Index and Match Functions
Loan Calculation and financial formulas
Manage Duplicate Data
Managing Data by Group
DAY 6
Date Formulas
Mention Date inside Function
Import or Export Date by Formula
Working Day Calculation
Time-Related Functions
DAY 7
Managing Multiple Windows
Template
Formatting by Formula
Timeline
Formula Auditing
Managing Comments in Excel
DAY 8
Introduction to Excel Macro
Macro Project
Course Outline
Course Outline
Fahim A Khan
Founder Coordinator- BSCC,
Head of Supply Chain & Corporate Affairs - RANCON Electronics Ltd.
Duration
Duration
14 Hours
14 Hours
Cost Per-Person
Cost Per-Person
2000tk
Report abuse