Robert Gascon not only created a shortest formula challenge but he also challenged me to write a post about it! Continue reading
Post Category → Videos
Aggregating Text
Is it ok to make one manual adjustment to an automation task to avoid the complexity of a fully automated task?
awkward-data/power-query-solution
My last post was about an awkward dataset. Now I’ll review Daniel Choi’s Power Query solution that rearranges the data. 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
Kevin’s Formula Challenge
My friend Robert Gascon was thinking about Excel formula challenges and Kentucky Fried Chicken (he loves KFC) while drinking a beer. 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
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 )
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 reading