You may already know that all date type values in Excel are converted to a serial number in Excel. This is an effective way to store date because not only do the digits take less space, it can be calculated upon for all sorts of date maths such as finding difference in days, months, years, […]
Tag: Excel
GENETIC QUIRKS OF THE WORLD 2024
Here are some interesting facts (oddities?) from around the world and their associated visuals in Excel. Data source: worlpopulationreview.com Data rounded to nearest single decimal digit when applicable.
Generate Bar Codes, QR Codes in Excel: Quick & Easy Way
In this post, I’ll show you a quick, easy, and a free method that you can use today to generate QR codes, bar codes in UPC-A, UPC-E formats, and custom bar codes based on the product information you enter in Excel as text. How it works Two things are at play here that make it […]
How to calculate streaks in Excel
Streaks refer to trends in the data. These can be linear, exponential, damped, seasonal, irregular/random, stationary, or cyclical. Streaks are important for several reasons: There isn’t any built-in function in Excel for calculating streaks, but there different ways we can make Excel do some of that heavy-lifting by using a combination of functions such as […]
What’s Your Chart Signature? Graphing a name in Excel
Have you ever wondered: how does my name look like if plotted in Excel? Well, wonder no more. In this post, I’ll show you how to enter any name (or any string of characters) and plot it in dynamically to make your unique name come alive as a chart. To make it fully dynamic, I […]
Comparing and merging lists in Excel, Python
Identifying anomalies, duplicates, and updating data necessitates comparing information from various sources. Accurate execution of these tasks is crucial, whether working solely with spreadsheets or using a mix of tools and languages like databases and web services. In this post, I will demonstrate various methods for comparing lists of identical or differing sizes across different […]
How much does it cost to retire in each state?
Recently, I collected data on cost of living, and average longevity in every state + D.C. From the data, I derived the COLI, or Cost of Living Index, which is then normalized to 100 (where 100 represents the national average cost of living). Additionally, using data from Bureau of Labor Statistics (BLS), I populated by […]
Conditional Coloring of Bar, Column Charts: 3 Examples
There are times when we want specific colors for bars or column in Excel charts to represent certain values or categories. Unfortunately, this isn’t a default feature, and it necessitates manually coloring each bar or series, which doesn’t automatically adjust when the data is altered. However, there are ways to achieve that with a little […]
Creating a dynamic weather report visual in Excel
In this blog post, I’ll share how I created a professional looking weather report tile using Excel without using any charting or pivot tables, but just just formulas and data inputs that is repeatable and scalable to daily reports without any change in the workbook. Just input the new data, and the new visual is […]
McKinsey-style bar chart in Excel
In this post, I’ll demonstrate how to create a McKinsey-style bar chart using just symbols and formulas, without using any Excel’s built-in chart components. BENEFITS OF THIS TYPE OF CHART:▪ It’s basically a bar chart with end points of our choice and much more vertically space-efficient and flexible.▪ It’s based on formulas, we can even […]