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
Post Category → Articles
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
Rouge National Urban Park
My wife and I recently visited Rouge National Urban Park. We wanted to spend some time away from TV, internet and Excel. We did…but I discovered some data in the Park! Continue reading
Dynamic Hyperlinks in Excel to HockeyDB
About 16 years ago I discovered HOCKEYDB. I was hooked! Why? Growing up in the late 70s and 80s I was a huge hockey fan but without cable or the internet information was limited. I had so many unanswered questions. Continue reading
Chandoo’s Sequence Number Puzzle
I saw this sequencing challenge from Chandoo “Generate a new sequence number when value changes“. His formula solution is great but I kept thinking “What if we have 20000 rows?“ Continue reading
Video 00174 Ranking Values into Tiers in Excel
Last year I started visiting some REDDIT Excel groups. A few weeks ago I saw an interesting Excel question and provided a simple two step solution. Continue reading
Change Text to Sentence Case
As Puneet Gogia mentions in his post, we can change text using UPPER, LOWER and PROPER functions but we don’t have a SENTENCE function to capitalize the first letter of each sentence. Puneet solves it with a very interesting formula. How exactly does it work? Let’s audit it! Continue reading
An off switch! What an excellent idea!
Some Excel models have so many complex formulas that they just can’t calculate any more. These models often need to be re-created. Some models can be saved by making formulas more efficient. One technique is to add an OFF SWITCH to heavy formulas. Continue reading