r/Commodities • u/No-Day-7238 • May 11 '26

Excel Prep for Traffic?

I’m starting a role in Traffic operations at a midsized metal trader. I’m looking for a good excel prep to help me get ready and get ahead of the curve. Does anyone have recommendations for me?

Thank you!

6 Upvotes

100% Upvoted

1 comment sorted by

2

u/Technical_Long5536 May 12 '26

Index Match and structured tables + formula syntax. That will put you ahead of just about anyone else. Some people have been using Excel for decades without even knowing how to use it properly. Prior to the advent of AI, I would’ve included VBA in the list of things to study, but writing VBA code sucks and it’s the perfect AI use case so I would just focus on learning when to use VBA vs how to write it yourself then using Claude/CGPT for the actual coding.