I was working on a demo file about Excel’s new Data Types but I found an incredible set of templates created by Elisabetta Caldesi! Continue reading
Discover Data Types templates
Post Category → Reviews
review of 2020 posts
Let’s forget 2020 but I will review my posts. Thanks Excel for helping me through the year. Continue reading
review of 2019 posts
I’ll review the posts I wrote in 2019. But first, a challenge inspired by a Wall Street Journal article. Continue reading
UDF Rollover Jordan Goldmeier
Jordan Goldmeier’s rollover technique runs a VBA User Defined Function when you hover the mouse over a hyperlink formula. Let’s take a closer look! Continue reading
Excel ChessGames Viewer
On July 20 I woke up early and started doing tactics on Chess.com I then noticed an email from Robert Gascon with subject heading “Excel ChessGames Viewer“! Robert also reminded me that it was International Chess Day! Continue reading
Sum Cells in Overlapping Ranges
This is a cruel Excel challenge (I’ve used it!). Why? Because there is a brilliantly simple solution to summing cells that overlap two ranges. 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
Stand-up comedy about Spreadsheets
Stand-up mathematician Matt Parker did a comedy routine about spreadsheets. Hmm….why not create a post about this? How can I make it interesting? My quest to find an interesting angle led me to….well…creating a YouTube Transcript spreadsheeet! Continue reading
Game Review: The Worksheet Saga
On Christmas day, when no one was looking, I peeked at twitter and saw a tweet about an Excel based game called The Worksheet Saga. My first thought was “oh…it’s based on VBA. I wonder if the code is unlocked?”. Read more to see how this game works and how I hacked it to win 🙂 Continue reading
ModelOff Comes to Toronto – Friday Night Drinks
On Friday after work I attended a ModelOff Meetup in Toronto at The Rum Exchange located on 67 Richmond St W. It was a fun event! Continue reading