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, […]
Category: Education
What generation are you, what does it mean?
Generational names and their time ranges help to identify and categorize people born within specific periods, often characterized by unique experiences, cultural trends, and societal changes. In this post, I share its brief history and an interactive embedded program where you can find out about your or anyone else’s generation details. History of naming generations […]
Excel…aww…I love you too!
Is it possible to use Excel for romantic or sentimental purposes? Absolutely! While Excel is commonly associated with routine tasks in accounting, finance, and data analysis, its capabilities extend far beyond these uses. In this post, I will showcase another unusual application of Excel that taps into its potential for more heartfelt endeavors. I experimented […]
Creating A Game Timeline Chart in Excel
BONUS VERSION Added on July 2, 2024 on a Euro 2024 game at end of the post. Recently, while following the thrilling Premier League soccer (European football) matches, I came across an eye-catching visual representation of the day’s game scores and timelines on BBC Sports. The post appeared as follows (on my mobile app): It’s […]
Creating Quizes and Surveys in Microsoft Forms
With the latest release of Microsoft Forms, creating a quiz, survey, or essentially any type of form for free using either work or personal account has never been easier. There are different ways to share the survey too such as emailing; and it’ll even help you write the invite or via Teams to anyone or […]
Hummers in western Washington
Do we need to give the darling hummingbirds a helping hand after the spring, summer flowers begin to wilt and many bugs begin to die off? Some of the birds hang around in the western WA state all year-round such as Anna’s. Yet, there’s not enough flowers and bugs they can survive on; with the […]
Electoral Votes by State/Jurisdiction
With the presidential election sneaking up fast, I thought it’d be good to get the latest electoral numbers by all states and District of Columbia based on the most recent census. So, here’s a map chart I created based on the published data. TIP: Use your mouse wheel while holding down Ctrl key on your […]
Interactive Reports – State Facts
Here’s an interactive data visualization of some key stats about each state (and DC) such as: state capital, size in square miles, largest city (by population), state population, year of statehood, population density (taking into account land size), population change in percentage over the years, highest peak in state and median household income. Population change […]
Population, Procreation Simulation (Python)
In this post, I share my design and code for simulating some propagating organisms (you can think of them as humans, other creatures, cells, objects, whatever you like) with certain rules. And although I have a couple of other variations of this made in C/C++ in the past, I wanted to do it in Python […]
A very effective, new AI-driven Video Creator
I am constantly scanning the AI space for new developments and newcomers in the arena. One of the most practical and stable tool I recently discovered is Pictory. It does video creation with a simple text script input, it generates videos even from a URL from any source (like a blog or article online) and […]