Monday, May 20, 2013

What are you doing to me Bill?

There are few things I remember about college classes at this point. As they say, if you don't use it, you lose it. What I do remember however, is an older professor in Finance who would often yell at the sky and ask, "what are you doing to me, Bill?" He was referring to Bill Gates. Like most finance classes, we lived in Excel. However, Excel didn't always like to play nice. Since then, I think my Excel skills have vastly improved and there are few problems that stump me. If I do encounter one that does, I turn to my trusty friend Google who almost always delivers.

From time to time I browse what people are posting on LinkedIn. I often find the articles more enlightening than those on Facebook and other social media sites. A friend posted this article on advanced Excel tips and I must say, it's absolutely fantastic. Not only do I count myself as an Excel guru, but I'm always interested in learning new features or functions that will make my life more automated.

For all the moments when my professor cursed Bill, I have to say, GOOD JOB BILL! Index-Match alone can replace the frustration of not being able to add columns to a spreadsheet without ruining a vlookup!

Hope you enjoy!