Arvind Bhardwaj Supply chain & Logistics Careers, Excel. BI Dashb
No reviews yet

LOGISTICS, SUPPLY CHAIN, INTERNATIONAL TRADE & DATA SKILLS TRAINING - BASIC TO ADVANCE EXCEL, POWER BI
Hands-On. Industry-Focused. Career-Driven.

1. Logistics & Supply Chain Management
Complete Operational Mastery Through Real Scenarios.
Blended, Case-Based Learning

Learn through real operational examples:
Demand planning scenarios
Inventory control workflows
Transportation route analyses
Warehouse layout simulations
E-commerce logistics case studies

Comprehensive Topics
SCM foundations & strategy
Warehousing & distribution
Procurement & supplier relations
Transportation management
Green & sustainable supply chains
Digital and e-commerce logistics

2. Import, Export & Customs Tariff Training
Regulatory Clarity Through Practical Exercises
Legal & Regulatory Foundation

Learn through updated real-world examples:
Customs clearance case files
Trade documentation samples
Duty calculation exercises
Valuation & HS code scenarios

Precise Tariff Classification
Hands-on practice with:
HS code identification
WTO valuation methods
Transaction value techniques
Classification case studies

Global Trade Awareness
Stay updated on:
Changing global trade policies
Compliance risks
Ethical & regulatory requirements

3.Practical Excel & Analytics for Business Operations
Data Skills Designed for Logistics & Trade Professionals

Hands-On, Case-Based Learning
Every skill is taught using actual business scenarios such as:
Personal expense trackers
Business KPIs & dashboards
Supply chain data sets
Export documentation trackers
Operational performance metrics
Step-by-Step Skill Development

Beginner → Intermediate → Advanced Pathway

Start With:
Formulas & calculations
Formatting for clarity
Basic charts & summaries
Progress To: Pivot tables, Data cleaning,Lookup functions
Introductory analytics

WHY TRAIN WITH US?
1. Practical, Hands-On Learning
Everything is taught through real-life examples, ensuring immediate workplace application.

2. Industry-Aligned Curriculum
All modules are structured around current job roles, global compliance standards, and emerging industry trends.

3. Step-by-Step Structured Programs
Learners build skills progressively—no prior experience required.

4. Real Assessments & Case Evaluations
Scenario-based evaluation ensures genuine professional preparedness.

5. Collaborative Learning Culture
Group projects, team problem-solving, and real business simulations build leadership and teamwork capabilities.

WHO SHOULD ENROLL?
Students aiming for careers in logistics, trade, or operations
Working professionals seeking skill enhancement
Entrepreneurs involved in import–export
Job seekers wanting globally competitive skills
Corporate teams needing structured upskilling
Anyone aiming to improve practical business data skills

TRAINING/COACHING OUTCOMES
Participants will gain the ability to:
✔ Manage end-to-end supply chain operations
✔ Perform accurate HS code classification
✔ Handle import/export documentation
✔ Understand customs regulations and global trade rules
✔ Use Excel for business analysis and reporting
✔ Create dashboards, pivot tables & performance trackers
✔ Clean, analyze, and interpret operational data
✔ Make operational and compliance-based decisions with confidence

COACHING FORMAT OPTIONS
🖥️ Online Live Training
🔄 Blended Learning

Subjects

SQL Intermediate
Logistics & Supply Chain Management Expert
Power BI dashboard Expert
Advanced & Basic Excel Expert
Data Analysis ( Microsoft Excel, PowerBI, and Database Management SQL Expert

Experience

LOGISTICS Executiv (Jan, 2025–Present) at OCS India, Mumbai

· Transportation Coordination: Overseeing transportation involves arranging the movement of goods, selecting optimal
transportation methods, and ensuring compliance with legal and safety standards.
· Vendor Relations: Building and maintaining robust relationships with vendors as CHA, Freight Forwarder
· Coordinating with workers related to logistics area to provide good service
· Involving in negotiating contracts, ensuring quality standards, and timely deliveries from the supplier
· Inventory Management: Managing monitoring Transport vehicle's details, forecasting demand, and implementing just -in-time
inventory systems for efficient handling by optimizing inventory & warehousing concept as ABC analysis, 5S
· Implementing and monitoring quality control measures throughout logistics is essential.
· Planned and supervised shipments from production to end-user and scheduled daily and weekly routes.
· Coordinated with the vendor shipping requests for expedited delivery and documented accurately to achieve correct billing.
· Tracked orders and notified customers of status, or potential delays
· Co-ordinating with CHA for filling BOE in Customs E-Sanchit Portal. & Close queries received from Customs.
· Data Analysis: Utilizing data analytics tools as Power BI, Advance Excel, SQL logistics operations executive analyses
performance metrics to identify trends, optimize operations, and make informed decisions.
· Involving in the tracking of key performance indicators to improve logistics processes continuously.
LOGISTICS OPERATIONS EXECUTIVE | (Feb, 2024–May, 2024) at Oxyde Chemical & Polymers Pvt Ltd - Mumbai

Coordinating with customers for signing of sales contracts and Letters of Credit for shipment.
May provide assistance to sales management for the preparation of weekly, monthly, and sales reports.
Handling various chemical shipment bulk, containers in drums, and ISO Tank shipment.
Follow up with CHA for clearance of the chemical shipment, and send it to our customer directly from the port.
Follow up with our counterparts regarding the status of the shipment and sailing schedule. Transit time.
Checking LC terms and conditions directed by top officials.
Follow up from vessel chartering party regarding load of shipment, survey report, and test report.
Follow up with the chartering party's shipping agent for the actual arrival and discharge of chemical from bulk
vessel, to calculate the demurrage occurred or not.
Preparing demurrage reports and sending them to our foreign counterpart for validation of the demurrage
amount. After getting verified, then send to our customer demurrage payment.
LOGISTICS COORDINATOR (May, 2021–Feb, 2024) at HUNTSMAN INTERNATIONAL PVT LTD - Mumbai, India

Operations and Transportation management.
Handling pre-shipment and post-shipment documentation activities.
Coordinating with CHA for export clearance of goods.
Coordinate with the freight forwarder for air and sea booking, and obtain the quote from them.
Coordinate with customer service and the planning team to arrange the dispatch of finished goods or ready
to-move items.
Liaising with a new transport vendor for better service to a particular route, or existing route.
Monitoring warehousing activity, inventory control, distribution, and checking the status of goods during in-transit.
Preparing monthly provision on the first working day of each month.
Ensuring spot rate approval for new locations, and contracting the same as per the need and urgency.
Prepare an MIS report related to warehousing, transportation, and documentation.
Creation of purchase requisitions for various logistical activities, doing the GRN of invoices.
Creating dispatch documents such as invoices, e-way bill.
Coordination with the transport vendor for placing vehicles.
Coordination with warehouse staff for stuffing the cargo in the vehicles for transportation.
Working with our Supply Planners to supply the goods to the Manufacturing Plant and Warehouse.
Working in SAP MM and SD Module, and MM Module various other transactions.
Generated documentation and information required for customer shipments.
LOGISTICS COORDINATOR (Jan, 2019–May, 2021) at SAMSUNG C&T CORPORATION PVT LTD - Mumbai, India

Business Development & Operations: Work with manager to improve processes, identify and correct problems,
and revise documentation.
May provide assistance to sales management for the preparation of weekly/monthly sales reports, develop draft
sections of sales contracts, purchase orders, and communicate with exporters and importers.
Perform outbound calls and provide warm leads to the Sales Manager and prospective customers to develop
new markets. Work with our Sales Planners and Sales Managers to assist and support their daily responsibilities in
terms of chemical sales.
Logistics Executive (Apr, 2015–Feb, 2017) at GIA: Gemological Institute Of America

Receive electronic import shipment notifications; prepare and issue import instructions to brokers (CHA) for the
release of goods by customs.
Handling import consignments such as machines for diamond grading, microscopes, diamond grading tools,
laser machines, and all other related goods required for diamond grading and scripting.
Dealing with queries from Freight Forwarders both internationally and in India regarding shipment of goods, and
approval of Bill of Entry checklist which is filed by.
CHA to get Bill of Entry from India customs.
Releasing of customs duty payment coordination with the accounts department, with the help of managers.
DGFT-related: applying for the Advance licence for the duty benefit, and IEC amendment.
Checking and forwarding invoices raised against services by freight forwarders, CHA, and local transporters

Education

Postgraduate Diploma in Logistics & Supply chain management (Aug, 2015–now) from Garware institute, Mumbai university–scored 100
Bacholer in Management Studies (Aug, 2007–Jul, 2010) from Mumbai university, Santacruz East–scored 60

Fee details

₹500–1,500/hour (US$5.26–15.79/hour)

It depend upon the complexcity of Subject of Assignment

Courses offered

SmartLogiX
- ₹24999
- Duration: 3 Months
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Hindi
- Certificate provided: No
●Coaching for Logistics and Supply chain.
●Logistics Dashboard & Route Opmtimization Consulting
● Excel for Supply chain Training
● Power BI tools for report and presentation with Power BI.
Basic to Advance Excel
- ₹5999
- Duration: 90 Hours
- Delivery mode: Online
- Group size: Individual
- Instruction language: English, Hindi, Marathi
- Certificate provided: No
Advanced Microsoft Excel & Power BI – From Zero to Business Analyst

Mode: Live Online
Total Duration: 90 Hours
Course Length: 10–12 Weeks
Delivery Style: Hands-on | Assignments | Industry Projects

This program is designed to make learners job-ready data professionals who can:
Handle real corporate datasets
Build MIS reports & dashboards
Perform advanced analysis
Create Power BI business dashboards
Apply skills in Logistics, Supply Chain, Finance, Sales & Operations

MODULE 1: Excel Fundamentals
⏱ 6 Hours Topics Covered
Excel overview & industry use cases
Workbook, worksheet, cells & ranges
Excel interface, ribbon & shortcuts
Data types: text, number, date, time
Data entry, edit, AutoFill, Flash Fill
Copy, paste & paste special
Find, replace & Go To Special
Page setup & printing
Practical Example
Creating a basic MIS data entry sheet
Daily operations tracking format
✅ Outcome: Strong Excel foundation, zero fear of Excel

MODULE 2: Formatting & Data Presentation
⏱ 6 Hours Topics Covered
Number formatting (currency, %, accounting)
Cell formatting, styles & themes
Conditional formatting (basic rules)
Alignment, borders, colors
Custom formats (dates, numbers)
Professional worksheet presentation
Practical Example
Creating a professional management-ready report
✅ Outcome: Clean, readable, corporate-standard sheets

📗 PHASE 2: CORE EXCEL – PROFESSIONAL LEVEL
MODULE 3: Core Formulas & Functions
⏱ 8 Hours Topics Covered
Formula logic & references (relative/absolute)
Mathematical functions:
SUM, AVERAGE, COUNT, MAX, MIN
Logical functions:
IF, Nested IF, AND, OR
Date & time:
TODAY, NOW, DATE
Rounding functions
Practical Example
Salary calculation sheet
Performance scorecard
✅ Outcome: Accurate calculations & logical thinking

MODULE 4: Data Handling & Validation
⏱ 6 Hours Topics Covered
Sorting & filtering (basic + advanced)
Data validation & dropdown creation
Remove duplicates
Text to columns
Freeze panes & named ranges
Practical Example
Customer master & vendor master control
✅ Outcome: Structured & controlled datasets

📙 PHASE 3: ADVANCED EXCEL – ANALYST LEVEL
MODULE 5: Text, Logical & Error Handlin
⏱ 6 Hours Topics Covered
Text functions:
LEFT, RIGHT, MID, LEN, TRIM
UPPER, LOWER, PROPER
CONCAT, TEXTJOIN
Error handling: IFERROR
Logical combinations
Practical Example
Cleaning raw logistics / sales data
✅ Outcome: Data cleaning & standardization expert

MODULE 6: Lookup & Reference Functions
⏱ 8 Hours Topics Covered
VLOOKUP & HLOOKUP (limitations)
XLOOKUP (modern replacement)
INDEX + MATCH (advanced logic)
Multi-criteria lookups
Real-life lookup scenarios
Practical Example
Rate master mapping
Product–customer mapping
✅ Outcome: Advanced data mapping skills

MODULE 6: Lookup & Reference Functions
⏱ 8 Hours
Topics Covered
VLOOKUP & HLOOKUP (limitations)
XLOOKUP (modern replacement)
INDEX + MATCH (advanced logic)
Multi-criteria lookups
Real-life lookup scenarios
Practical Example
Rate master mapping
Product–customer mapping
✅ Outcome: Advanced data mapping skills

📊 PHASE 4: REPORTING & DASHBOARDS
MODULE 7: Pivot Tables & MIS Reporting
⏱ 8 Hours
Topics Covered
Pivot table creation
Sorting, filtering & grouping
Calculated fields
Pivot charts
Slicers & timelines
MIS design concepts
Practical Example
Monthly sales MIS
✅ Outcome: Management-level MIS reports

MODULE 8: Excel Dashboards & Visualization
⏱ 6 Hours
Topics Covered
Dashboard design principles
KPI identification
Charts: bar, column, line, combo
Interactive dashboards
Professional formatting
Practical Example
Operations performance dashboard
✅ Outcome: Interactive Excel dashboards

🔄 PHASE 5: ADVANCED ANALYTICS & AUTOMATION
MODULE 9: Advanced Excel Analytics
⏱ 6 Hours
Topics Covered
SUMIFS, COUNTIFS
Dynamic arrays:
FILTER, SORT, UNIQUE
What-if analysis
Goal seek
Scenario manager & data tables
Practical Example
Cost optimization & scenario analysis
✅ Outcome: Decision-making with data

MODULE 10: Power Query (Excel Automation)

⏱ 4 Hours
Topics Covered
Importing Excel, CSV data
Data cleaning & transformation
Merge & append queries
Refresh automation
Practical Example
Automated monthly MIS refresh
✅ Outcome: Time-saving automation skills
Logistics Management
- ₹6000
- Duration: 2 Months
- Delivery mode: Online
- Group size: Individual
- Instruction language: English
- Certificate provided: No
Module 1
Introduction to Logistics
What is logistics · Supply chain overview · Key players · Industry sectors
Module 2
Transportation Basics
Road, rail, sea, air · Modes comparison · Freight terminology · Incoterms intro
Module 3
Warehousing & Storage
Warehouse types · Storage systems · Inventory basics · Receiving & dispatch
Module 4
Order Management
Order lifecycle · Fulfillment process · Packaging · Returns (reverse logistics)
Module 5
Logistics Documentation
Bill of lading · Packing list · Invoice · Customs declarations

Module 6
Intro to Technology
TMS · WMS basics · Barcodes & RFID · Track & trace