Tabellab

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.

20 lessons 20 labs Certificate

  • 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

  1. Shipment Log Cleanup: TRIM, UPPER and PROPERLabFree
  2. Freight Cost per Shipment, per kg and per PalletLab Locked
  3. Carrier Rate Card: Weight Brackets with XLOOKUPLab Locked
  4. Dimensional Weight vs Actual Weight with MAXLab Locked
  5. On-Time Delivery Rate per Carrier with COUNTIFSLab Locked
  6. Transit Days in Working Days: NETWORKDAYS and HolidaysLab Locked
  7. Pallets, Trailers and Fill Rate with ROUNDUPLab Locked
  8. Fuel Surcharge per Kilometre on Truckload InvoicesLab Locked
  9. Warehouse Pick Productivity: Lines per HourLab Locked
  10. Stock Movements: Running Balance, Reorder Flag and Cycle CountLab Locked
  11. Carrier Scorecard: OTD, Cost per kg and RankingLab Locked
  12. Logistics Dashboard: OTD Trend, Cost per Shipment and HighlightsLab Locked
  13. Dock Appointments: Late Arrivals, Unload Times & Door HoursLab Locked
  14. Freight Invoice Audit: Expected Charges, Overbilling & DisputesLab Locked
  15. Open Shipments Report: Days Since Pickup, Overdue Flags & Counts by StatusLab Locked
  16. Freight Claims: Claims per 100 Shipments, Amounts Paid & Recovery RateLab Locked
  17. LTL or Full Truckload? Comparing Two Quotes per Order & the Break-Even WeightLab Locked
  18. Shipping Volume by Weekday: Day Names, AVERAGEIFS & Dock StaffingLab Locked
  19. Customer Delivery Profiles: XLOOKUP, Not-Found Values & Special RequirementsLab Locked
  20. Final Project: Monthly Lane Report with SUMIFS, OTD Targets, Flags and a ChartLab Locked

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy