This is an Excel trick that's not super complicated but super useful for labelling a simple table in Excel. Let's say you have one set of labels along the rows (e.g. "Region") and then another set of labels along the columns (e.g. "Month").

Given the media attention placed on the coronavirus (COVID-19) in the media the last few weeks, I thought it was important to take a step back and look at the math behind infectious diseases and how diseases spread.

This episode is based on a video and Tweet posted by Mr. Excel (Bill Jelen). Bill discusses an Excel challenge someone emailed him about regarding how to "transform" a badly structured table of data into a structure that makes it easy to do PivotTables...

I discuss how to calculate percentiles in Excel or Google Sheets using the PERCENTILE function. With the PERCENTILE function, you can calculate the value that would represent nth percentile in your list of values.

In this episode, I discuss how to calculate trends over time in Excel for the purposes for forecasting future values. I reference an old post about calculating trends where someone recently left a comment about the counter-intuitiveness on calculating ...

If you are by your computer, you may want to open this Google Sheet to understand the example discussed in this episode. I walk through a rather long formula involving the FREQUENCY(), COLUMN(), MAX(), and the ARRAYFORMULA() functions in Google Sheets....

This is my talk from Webflow’s No-Code Conference that took place on November 13th, 2019 in San Francisco. The title of my talk was called Building No-Code Tools and Applications from Spreadsheets. The slides from my presentation are on SlideShare here...

A few weeks ago I had the opportunity to teach a week-long data analytics course through General Assembly. The course was taught entirely online using Zoom. I discuss some of the topics the students learned in the class,

A bit of a click-baity title, but I wanted to talk through some of the signs you know you’re using too much Excel. If you are worried about a friend who is using too much Excel, ask him or her if they recognize any of these signs.

Range: Why Generalists Triumph In A Specialized World by David Epstein came on my radar after listening to another podcast. Thought the premise was interesting in that people who “dabble” in various interests and hobbies end up excelling (no pun intend...