Step charts are suitable for showing fluctuating or irregular values over time. There’s no built-in Step chart type in Excel, so most people use a Line chart instead, which is not really ideal or sometimes accurate (I’ll explain that below). With proper data shaping, it’s possible to create Step charts in Excel. In this post, […]
Tag: education
Building an at-a-glance holidays timeline
Today, I share the steps required to build an overall holiday calendar timeline in Excel. This allows you to see the entire year’s holidays with different categories (e.g. company holidays, federal, personal vacation, etc.) at a glance without requiring you to navigate month by month to see the events. All the year’s key events can […]
Prisoners of the world
In this post, I touch on a complex and touchy issue of the human society. We look at the prisoners’ population around the world for selected countries, while casting a wide net of diversity. With the data and visualizations presented, we should be able to answer: Which countries have the highest number of prisoners? Which […]
Calculating Playoff Chances
With the NFL regular season winding down after week 15, we have a pretty good idea of which teams are definitely out of the playoff hunt, which teams have clinched a playoff berth, but the rest are still up in the air. In this blog post, I calculate the chances of making the playoff for […]
Plotting ranges of values – Cat metrics
In this purr-fectly delightful blog post, I’ll guide you through steps to meaningfully depict ranges of values in Excel, all the while crafting irresistibly cute charts—no graphic skills needed! You’ll discover a few charts showcasing upper and lower values, Means, and custom markers. Using data such as the lifespans, weights, and prices of different cat […]
Unicode transformation fun
In this post, I share some exercises of encoding a usual string of English/Latin alphabets into a readable Unicode version with styling but still into a text that can be copied/pasted anywhere without any special app, and then transform the input text into some interesting Unicode symbols (that can also be copied/pasted anywhere as text). […]
Custom Chess Board Setup for Sim and Puzzles
In addition to solving real-life and abstract challenges, I love playing chess and mulling over different scenarios. When I don’t want to play the entire game from beginning to end, but rather start at a climactic stage, it makes it even more exciting and challenging to play it to the end with someone or even […]
Daily Chess Puzzle
I always loved Chess since I was a mere child. And I still love playing it. If you do too, or just want to improve or learn some chess skills, the following widget might be of interest to you. It brings fresh puzzles daily from chesspuzzle. net site based on famous players but the challenge […]
What would be your NFL team’s Unicode logo?
If you were to select a Unicode symbol for every team in NFL, what would they be? It cannot be graphics, emojis, or ASCII art…you must select a single Unicode character for each team that are in the standardized blocks. That means, the character can be copied and pasted as text in any text editor, […]
Fun with AI: Text and Image->Video
One of the relatively newer tools that came online for the general public designed to transform ideas into AI-generated videos is Hailuo AI. In this post, I’ll share a couple of examples of its outputs based on my paintings, drawings, digital creations, and text prompts. Hailuo’s Conch Video is a product of Minimax, a China-based […]