Tuesday, August 13, 2024

## How to create Overlapping Charts in Excel

Sometimes a seemingly simple visual can be difficult to convey with a built-in Excel chart. I present here such an example. For instance, I will describe how and why to create an Overlapping Column Chart, aka 100% Overlapping Column Chart in Excel. It can also be turned into an Overlapping Bar chart. Say, we have […]

## How To Pick Rows Or Columns, And Combine Them With Other Functions For Powerful Uses. Part 2

In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: DROP(). In another blog, I discuss […]

## How to pick rows or columns, and combine them with other functions for powerful uses

In this post, I’ll share an Excel function that enables us to easily pick specific number of rows and/or columns from a range of data. Additionally, I’ll share examples of how it can be combined with other functions to do some powerful tasks. The function I am discussing here is: TAKE(). In the next blog, […]

## Euro 2024 Analyzed with Visuals

Introduction With the summer of soccer, beautiful football having come to an end, let’s dive into some team and player statistics and assay the tournament. I have collected various stats and facts, and organized them into a digestible format as a tribute to the fantastic players and the tournament. In this post, I’ll cover some […]

## How to convert a standard date format <-> Excel date serial number

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, […]

## 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 […]