I would rate myself, on a scale of 1-10 using excel, as maybe a 7.0 or 7.25. Now that I am comfortable using the vlookup function, perhaps even a 7.5 on a scale of 10.0.
I was given the responsibility to automate how certain state tax data is imported into OneSource, the tax processing software used by my company. I had a very good idea how the automatic importation was supposed to work, but I did not have the know-how on how to do it much more efficiently. Learning vlookup helped, but that was not enough.
After speaking to a colleague who gave me a few tips, it made the process of importing data into onesource much easier, which finished my task. The scary thing is all I wound up doing differently was using paste specials, transposing functions, and a new function where a data field is named to make this so much easier to manipulate data. It saved me probably four hours on my project.
It is truly scary what technology is capable of doing sometimes, and how simple functions can really save lots of time.
No comments:
Post a Comment