Let’s explore Wayne Gretzky’s goals (it’s his birthday tomorrow!). I’ve thought of some good questions and one “great” question that we can answer using this dataset. Finally, could Ovechkin break Gretzky’s goal record? (more…)
Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas.
I’ll review the posts I wrote in 2019. But first, a challenge inspired by a Wall Street Journal article. (more…)
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! (more…)
Let’s explore an advanced way to use Conditional Formatting in Excel. We’ll make a face move around the screen without any vba! Bonus: see how to interact with target cells! (more…)
FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! (more…)
In Canada we have long harsh winters but July was REALLY hot this year! How hot? Let’s combine heat & humidity to determine the real temperature we feel.
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. (more…)