Guides / Excel
Excel
Lookups, data clean-up, pivot tables, trackers and dropdowns for everyday shipping and export work.
-
XLOOKUP vs VLOOKUP: matching invoices to packing lists
How to match shipment data between two lists in Excel, and why XLOOKUP is easier than VLOOKUP.
-
How to clean messy carrier and supplier data in Excel
Fix extra spaces, numbers stored as text and broken dates in files from carriers and suppliers.
-
Build a simple shipment tracker in Excel
A step-by-step shipment tracker with automatic status, days late and colour highlights.
-
Pivot tables for freight cost by lane and month
Summarize freight costs by lane, mode and month with a pivot table, and avoid the average cost per kg trap.
-
Excel dropdowns for Incoterms and shipment status
Add dropdown lists to your Excel sheets so your team enters Incoterms, status and customers the same way every time.