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…)
I got this crazy idea for an Excel game while drinking a Space Invader IPA from www.amsterdambeer.com It turned out to be a great way to learn more VBA! (more…)
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. (more…)
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). (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.
Power Query is a powerful and intriguing tool. However, there are stumbling blocks that make it challenging. Let’s audit and then modify some M code! (more…)
Given 3 separate lists of text how can we create all combinations? I’ve known Power Query (Get & Transform) can create a cartesian product but it’s only now that it’s part of my active skill set. (more…)
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…)
