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
Author Archives → Kevin Lehrbass
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
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
Rank within Groups in Excel
How can we rank within groups in Excel? Most experts will tell you to use the SUMPRODUCT function. Why? It’s the only solution they know or maybe they’re concerned about compatibility. Is anyone still using Excel 2003? Let’s compare SUMPRODUCT and COUNTIFS. Continue reading
Video 00173 Dynamically Combine Data From Excel Tables
An ounce of prevention is worth a pound of cure but how does this apply to Microsoft Excel? In this post I will show you a common example. Too late for prevention? I’ll show you two solutions. 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