One of the best things about my job is that it’s filled with challenges to keep my mind sharp. No crossword puzzles required! This week’s challenge is to create some dashboard-type output from a bunch of Excel spreadsheets. I picked up a few tips from Udemy, so I need to give them a shout-out. If you… Read More »
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.