You can customize your quick access toolbar. I've never seen a rule against 3rd party add-ins so I'm not sure about those. Keyboard shortcuts and lookup/logic/date/math/dynamic array functions are key along with data tables if you want to try and solve the challenge in one go.
ASAP Utilities was my weapon of choice when I was deep in excel data extraction work. But I think that should count as "auto aim" in a sport setting...
