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 […]
Tag: STEM
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 […]
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 […]
About your birthday and more (Excel)
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 […]
Let’s play with all the presidents (Excel)-Part2
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. […]
Let’s play with all the presidents (Excel)-Part1
Specifically, we’re going to start with the most basic data about US Presidents, and “play” with them to extract some more meaningful, interesting tidbits. Along the way, you’ll learn how to: Recognize, and deal with unprintable characters Shape raw (unruly string) data for analytics Find trends Make interactive charts and tables Use fuzzy logic and […]
A basic spin-slot game in…Excel??
With Excel’s toolbox of thousands of formulas and VBA support, it’s not out of question to be able to create games although it’s not designed for that purpose. However, not for the sake of playing, rather for experimentation and learning, I decided to present a simple form of a spin game. Game Rules Have 2 […]
Ranked, custom charts and animation (Excel)
In this blog, I share how to use simple data, and create some meaningful charts, even with animation and custom graphics. Along the way, I’ll demonstrate techniques to rank and spark some ideas on PowerPoint<->Excel interaction. Let’s start with the dataset. Following are the responses from a survey of 1,002 consumers from a couple of […]
Timelapse animation in Excel
Not long ago I demonstrated how to create and share animated charts using Excel (search for “soccer” or “excel” in the search box of my site). Here, I present a cool 3D chart created in Excel with various dimensions including time and geo-location. This animation is based on a dataset for power stations across different […]
Random Fun with Excel
This is a seemingly useless but visually fun usage of visuals, combined with Excel functions and VBA I did to take a break from my typical gnarly Excel analytics work 🙂 How it works: 1. Fill in a formula to generate random numbers between 1 and 100 (inclusive) across the cell range. 2. Apply 2 […]