I’ll review the posts I wrote in 2019. But first, a challenge inspired by a Wall Street Journal article. Continue reading
Date Archives → 2019
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
mmult function
MMULT function is incredibly powerful and yet mysterious to most. Let’s explore this complex function (this post inspired by a formula challenge from contextures.com )
Advanced Conditional Formatting
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! Continue reading
Excel Beer Game
I got this crazy idea for a game while drinking a Space Invader IPA from www.amsterdambeer.com It was a great way to learn more VBA!
Continue readingStandard Deviation in Excel
How tall is tall? How smart is smart? How do we compare? Normal Distribution and Standard Deviation answer this. We’ll review the concepts and use Excel to crunch the numbers. Continue reading
Learn VBA UDF
These days dynamic arrays, power query and DAX seem to be all the rage. But let’s not forget about an old friend: VBA UDFs (User Defined Function). Continue reading
Chess FEN viewer
FEN notation provides the necessary info to restart a chess game from a given position. See how I created a FEN viewer in Excel! Continue reading
Humidex Formula in Excel
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.
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