Google "automatically get stock quotes excel". I saw one that used code and another that used something called "smart tags". Apparently, the smart tags can be activated in come versions via options/proofing. It is not on my version and the fix, running smartTagInstall.exe, didn't do anything as far as I can tell.

As far as "helpful formulas" to "simplify" your boss's spreadsheets, I have no idea given I don't know what you are using or trying to accomplish with the sheets.