My friend Robert Gascon was thinking about Excel formula challenges and Kentucky Fried Chicken (he loves KFC) while drinking a beer. Continue reading
Kevin’s Formula Challenge
Wayne Gretzky’s Goals
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? Continue reading
Power Query Challenge – What Did They Order from the Menu?
Alan Murray (Computergaga) had an interesting challenge on YouTube. It’s a classic case of “Analyze my awkward dataset!”. He solved it using Power Query. Can it be solved using formulas? Continue reading
use vba to name checkboxes
Over the holidays I saw some vba code for checkboxes from the book ‘More Excel Outside the Box’ by Bob Umlas.
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
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