Now that the 2019 NFL regular season is in the books, we have complete data available about the teams’ performances. What can we glean from them? In this blog, I share some findings, answers, and the process of analytics behind discovery of the answers. I will focus on overall team performance data, not individual positions, […]
Blog
A Real Data Merge Challenge (Excel)
Instead of demonstrating what each of the thousands of functions does in Excel, it’s most helpful, I think to demonstrate how to solve real-life scenarios and the formulas that come in handy as secondary. Today, I present this. The Challenge: You are given 2 datasets of fruits and their prices. One set includes some items/fruits […]
New Year Mega Crab Stage 10 (Boom Beach)
Zero casualties 🙂 Enjoy!
GOTO conference in Amsterdam: Agile
Although the message was delivered about the misinterpretations of Agile back in 2015, few heeded. Or perhaps few could hold back the ocean of this profitable industry with a broom while the proponents pushed a new framework as a methodology to the panicky companies entering the hashtag#programmanagement hashtag#agile 21st century. This clip is of Pragmatic […]
A Christmas Tree in Excel (Happy Holidays!)
Merry Christmas and Happy Holidays, everyone! Here’s a quick and dirty animated tree decorated by me for Christmas in Excel (yes, I have a real one at home but not as wonky). It uses Excel’s basic conditional formatting and number generator functions to create this cute, blinking tree. With a little VBA code, you can […]
Claim: Most 13th of the months fall on Fridays anyway (+Test)
Someone claimed recently that most 13th of the months fell on Fridays in recent years. This claim came upon the heels of my blog on how to find Friday-13ths for any year in Excel. So, obviously I had to check it out for myself if the claim is true. And I want to check it […]
Weather report in Excel
Below is a 10-day weather report for Seattle in Excel using external data connections. The following is the live embedded sheet (however, online Excel does NOT support external data connections in the browser…yet). To get the data to refresh, just save the file locally or click Open in Desktop App button along the top of […]
Yeah, I use it for ‘research’!
That’s Lean!
Happy Friday (the 13th!). Have you ever wondered…?
If you’re anything like me, you’ve at least once wondered: How can I get Excel to show me all the Friday-13ths in any given year? Well, I have (don’t ask me why)…and here’s the solution. I found a couple of ideas on how to do this, but my method I believe, is the most straight-forward […]