Logistics control tower Excel

A while back, a logistics manager told me he was drowning in Excel files and still couldn’t answer one basic question:
“Where are my containers, and what’s costing me money right now?”

So I built him a solution.

In this video, I’ll walk you through a Container Tracking Dashboard in Excel — a tool I created to simplify global shipping visibility, highlight urgent containers, and track logistics costs like detention, inland freight, and ocean charges.

This dashboard includes:

A dynamic shipping dashboard with slicers
Container cost breakdown by type and timeline
Container status tracking (in transit, delivered, returned, stuck)
Weekly arrival forecasts
Custom alerts for containers that need urgent return

📊 Whether you're managing international freight, working with freight forwarders, or just love seeing what Excel can really do — this one's for you.

🧠 All built using Excel formulas and pivot tables — no VBA required.

🎁 Want this file?

📺 Subscribe for more Excel dashboards

[azizalosaimi]

Great stuff! I hope you could go over formulated cells of every column next time. Over all though, This video is an eye opener and a life saver 😅👍

[bubuinbed]

helpful for international logistics professionals

[antoniosarmento]

Thank you for the file. Just a question. If I need to change the data, I.e. port of loading, destination, container #... What tab do I make the changes? Data or DB?

[jannienasser]

This Dashboard is an eye opener please send me the file

[xBlackragex]

If the container is returned on the same day as the delivery to final destination the container status remains Delivery to final destination instead of Container returned, how could I solve this? Thanks!

[eng.mohammed]

Hello,

It's awesome video, could please help by providing the file.

I would be grateful if could attend to this matter.

Thanks in advance

[diobaguspangestu]

I already sent you an email about this video. Kindly check the email. Thankyou

[whistleblower]

Please can you share source sheet on my gmail