Have you ever made a decision that haunted you with doubts for weeks afterward? You wake up at night with nagging thoughts that you should have checked this, or should have thought of that? Or worse, you realize that the decision you made is NOT, in fact, the best decision. Well, fear not – we’re here… Read More »
In my younger days (many decades ago), I learned how to troubleshoot through a program to fix a particular issue. WAY back then, in the days of punch-cards, troubleshooting required logical and systematic thought. We couldn’t simply tweak the code, recompile, and try again five minutes later, because the process to submit changes to keypunch, receive the updated program cards, and get time on the compiler could be hours. I think I was a more patient problem-solver back then….
Like you, I’ve used Excel for years (decades, actually). I don’t consider myself an Excel guru. In fact, I have a wonderful long-time consultant I call on for serious Excel work (THAT GUY is a guru!). But on a day-to-day basis in my new job, I find myself doing more and more work in Excel.
Often, manipulating data in Excel is flat-out easier than working directly with the database. Here are a few real-life examples you may find helpful.
Long time Linux fan girl experiences her first Microsoft EA true-up. Ouch!