My husband is the reason for this post. I don't know how we got on this topic but over dinner tonight with our neighbors I was explaining how my new favorite excel function is =COUNTIF. My husband began talking about the many uses of =COUNTIF and went off on a pivot table tangent. I stated that there was something I was trying to do at work today but I didn't think there was a way to do it in excel. My husband explained "Nothing is impossible with excel!"
As usual, he was right. I explained in detail what I was looking to do and in under 15 seconds my husband rattled off the equation I needed. Today I spent 10 minutes rearranging data to do what he could have done in a flash.
What was the most valuable thing you ever learned to do in excel?
Once in an internship I built an excel workbook that dynamically built a series of scripts which replaced about 4 hours of manual data entry on our website which would need to be done almost every week and would run in about 10 minutes. It took me close to 2 days to build it, but the time investment was totally worth it.
ReplyDelete