Every once in a while we get a unique challenge in Excel. This one required some creativity to quickly create a solution due to a pending deadline.
Continue reading
Variable Sized Groups Within Each Column
Excel data concept taught backwards
I’ve been a data analyst since 2001. It’s often challenging to accurately & quickly explain certain concepts. There is one that is a classic. I’m going to explain it with the help of Hugh MacLeod’s book “Evil Plans”. No nerdy data terms. The concept first. Continue reading
NYT Lack of Cat Research article leads to Spanish study
How did a New York Times article about the lack of scientific cat research lead me to this spreadsheet: “Affective norms of 875 Spanish words for five discrete emotional categories and two emotional dimensions” ? Continue reading
Excel Pivot Tables Analyze Taco Data!
During our recent vacation to New York City my wife and I loved eating tacos at TACOMBI. However, when I saw the menu it reminded me of a common data challenge! Continue reading
Create Your First Pivot Table in 5 Minutes
One of Microsoft Excel’s most prolific features is the Pivot Table. Pivot Tables offer an efficiency and effectiveness in making sense of large amounts of data in almost no time. With that in mind, we now turn our attention to a scenario where we will create a Pivot Table in five minutes. Continue reading
Mr Excel & excelisfun Trick 141: Lookup 3 Items in 3 tables
I enjoy the dueling Excel podcasts between Bill Jelen and Mike Girvin! The challenges, the energy, the solutions, the community involvement…everything! Let’s look at Excel duel 141 (the PI episode). The best solution depends on asking one question. Continue reading
The Einstellung Effect in Excel?
How did a Scientific American article help me create a much simpler solution in Excel? And what connection does it have to the Einstellung Effect? Read on and I’ll tell you 🙂 Continue reading
Women Who Excel
Despite years of experience I still do a lot of Excel google searches. I’m often in a rush and I know which websites to trust. Three of my favorite go to Excel websites are run by: Debra Dalgleish, Mynda Treacy and Leila Gharani. Continue reading
YouTube Video Transcript Template
Have you noticed there’s no way to create bookmarks within a YouTube video? I’ve always thought that it would be a great feature. Well, I have created an Excel template that can do this! Continue reading
Who Won the 2018 Winter Olympics?
I watched the closing ceremonies of the Olympics last night. It was very nice…but who won the Olympics? Continue reading