Teaching analytics with modern Excel
I love Excel. It's a bedrock of my blog and largely my "claim to fame" as an authority. That said, early on I intended this not to just be an Excel blog, because I saw the benefits of cross-training …
Continue Reading about The dangers of being a one-platform data analyst →
I get the sense that many analysts are frustrated and unhappy and work -- I know I was when starting out. The data appears to confirm a general pattern. What's causing this frustration, and what can …
I have a theory that most data people are hard to buy for... or, at least I am, so I can't be the only one. I’m all about productivity and innovation. I’m also not at all about superfluous gifts. You …
Continue Reading about Gifts for the data person in your life →
I had a great conversation this afternoon with Oz du Soleil about working with commissions and incentives in Excel.This is a key function of many financial analysts, including me.In this video we go …
Continue Reading about Lessons from a Commission Analyst: Interview with Oz du Soleil →
This tip comes courtesy of Alex at Excel Strategies. Check out his #TuesdayShortcuts series for more nifty Excel timesavers!Use Alt + A + M to remove duplicates in a set of data in Excel. …
Continue Reading about Alt A+M: Remove duplicates in Excel →
