All guides
10 guides on Excel, Power Query, Power BI and everyday logistics calculations.
-
What to learn first: an Excel and Power BI roadmap for logistics people
A simple order for learning Excel, Power Query and Power BI if you work in logistics, freight or export documents.
-
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.
-
Chargeable weight in Excel: air and sea freight formulas
Work out volumetric and chargeable weight for air freight and sea LCL shipments with simple Excel formulas.
-
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.
-
Power Query: combine monthly shipment files in one click
Stop copy-pasting monthly reports. Combine a folder of Excel files into one clean table that refreshes itself.
-
Your first on-time delivery dashboard in Power BI
Build an on-time delivery percentage dashboard in Power BI Desktop, with the DAX formulas and the one mistake that inflates your numbers.
-
Reorder point and safety stock in Excel
Calculate when to reorder and how much safety stock to keep, using simple Excel formulas and a worked example.
-
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.
No guide matches that search. Try a shorter word, such as "pivot" or "weight".