Zero casualties 🙂 Enjoy!
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 […]
Merry Christmas and Happy Holidays, everyone! Here’s a quick and dirty animated tree decorated by be for Christmas in Excel (yes, I have a real one at home but not as wonky). It simply uses Excel’s conditional formatting and number generator functions to create this crude tree. With a little VBA code, you can make […]
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 […]
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 […]
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 […]
Here’s a basic application in Excel I put together for fun that gives information about a birth date. For example, which day of the week was the person born? What’s the zodiac sign? The zodiac symbol for the person, and also a direct link to a web site to find his/her horoscope information (including daily […]
This is Part 2 of the blog Let’s play with all the presidents (Excel)-Part1. Please read Part 1 there first to follow along. To find the zodiac sign of a president we need to map his month and day portion of his birthday to a table that map the month and day to a zodiac. […]