It’s April 21 and winter is supposed to be finished here in the Toronto area. However, I went for a walk and it’s still cold out! A combination of cold & wind. Let’s calculate the wind chill in Excel. Continue reading
Calculate Wind Chill in Excel
Post Category → Articles
arithmetic progression
Let’s take a look at something that’s SO easy to calculate today with a simple spreadsheet but was very challenging to calculate in the past. Continue reading
Worksheet_Change Keep All Time Min Max Numbers
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
Flatten the Curve
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
Old School Helper Columns
For Mr Excel’s recent challenge I decided to go with an old school formula helper column solution. Why? I’ll explain. Continue reading
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
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 )