Excel is not meant to store historical data. That’s what databases do. However, Tom Urtis shows us a trick to keep the all time min value from a single input cell. Continue reading
I keep hearing “flatten the curve” during these uncertain times of covid-19. What’s that? What do we do? Also, what can we do to reduce anxiety? For me I decided to create a “flatten the curve” demo in Excel and in Power BI 🙂 Continue reading
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
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. Continue reading
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
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
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