Excel for Logistics Coordinators: Shipments, Freight Costs & On-Time Delivery
20 hands-on labs for logistics and shipping coordinators: shipment log cleanup, freight cost per kg and pallet, carrier rate brackets, dimensional weight, on-time delivery, transit days, pallets and trailers, fuel surcharge, pick rates, stock balances, a carrier scorecard and a dashboard – plus dock appointments, freight invoice audits, open-shipment reports, claims, LTL vs full truckload, weekday staffing, customer lookups and a monthly lane report.
- One-time payment
- Instant access right after payment
- Secure checkout with Stripe
About this course
This beginner course teaches the spreadsheet skills a logistics or shipping coordinator uses every day, with a fictional home-goods distributor as the example. In 20 hands-on labs you clean a shipment log, calculate freight cost per kg and per pallet, look up carrier rate brackets, compare actual and dimensional weight, measure on-time delivery and transit days, plan pallets and trailers, add fuel surcharges and check pick rates and stock balances. You build a carrier scorecard and a dashboard, then go further: dock appointments and unload times, a freight invoice audit against contract rates, an open-shipments report with overdue flags, freight claims per 100 shipments, LTL versus full truckload, weekday volume and dock staffing, customer lookups with special requirements and a monthly lane report with targets and a chart.
Lessons
- Shipment Log Cleanup: TRIM, UPPER and PROPERFree
- Freight Cost per Shipment, per kg and per Pallet Locked
- Carrier Rate Card: Weight Brackets with XLOOKUP Locked
- Dimensional Weight vs Actual Weight with MAX Locked
- On-Time Delivery Rate per Carrier with COUNTIFS Locked
- Transit Days in Working Days: NETWORKDAYS and Holidays Locked
- Pallets, Trailers and Fill Rate with ROUNDUP Locked
- Fuel Surcharge per Kilometre on Truckload Invoices Locked
- Warehouse Pick Productivity: Lines per Hour Locked
- Stock Movements: Running Balance, Reorder Flag and Cycle Count Locked
- Carrier Scorecard: OTD, Cost per kg and Ranking Locked
- Logistics Dashboard: OTD Trend, Cost per Shipment and Highlights Locked
- Dock Appointments: Late Arrivals, Unload Times & Door Hours Locked
- Freight Invoice Audit: Expected Charges, Overbilling & Disputes Locked
- Open Shipments Report: Days Since Pickup, Overdue Flags & Counts by Status Locked
- Freight Claims: Claims per 100 Shipments, Amounts Paid & Recovery Rate Locked
- LTL or Full Truckload? Comparing Two Quotes per Order & the Break-Even Weight Locked
- Shipping Volume by Weekday: Day Names, AVERAGEIFS & Dock Staffing Locked
- Customer Delivery Profiles: XLOOKUP, Not-Found Values & Special Requirements Locked
- Final Project: Monthly Lane Report with SUMIFS, OTD Targets, Flags and a Chart Locked
Learner reviews
Be the first to review this course.