In Excel or Google Sheets, text manipulation is usually associated with data cleaning, data cleansing, and data transformation. Sometimes your data is "dirty" and needs to be categorized in a different way or you need to "extract" a piece of text from ...

On a recent episode of The Intelligence, The data editor at The Economist spoke about a U.S. presidential election forecast their publication is working on. I looked more into their model and discuss some of the features and parameters of their model a...

Have you ever wondered what the underlying meaning of your dreams are? Chances are you may have tried Googling something like "What does it mean to dream about [INSERT DREAM]." In The Shape of Dreams, Federica Fragapane answers this very question of wh...

This is one of my favorite VLOOKUP tips. Given that it's pride month, we'll be applying this tip to a list of all pride events in the United States. Here is the Google Sheet if you want to follow along with this example.

The Black Lives Matter movement has come to the forefront in the news media. People around the world are looking for ways to fight racial injustice. If you are in a position to donate to an organization fighting racial injustice,

The QUERY() function in Google Sheets gives you the ability to quickly filter and sort your data similar to how you might get data from a database. If you write SQL queries, the QUERY() function feels easy and natural to use.

I worked on a "small" side project recently to sync data between Google Sheets and tables in Coda. The full blog post tutorial is here, and the GitHub repository is here. I started using Google Apps Script last year and it's a super powerful way to con...

Now that you're staying home and picking up new hobbies and taking classes online, here are a few tips on how to learn Excel and spreadsheets from an online class. I have seen viewership on my own Excel classes spike since COVID-19 hit which has led me...

Have you ever wondered what an "array-entered formula" is? It's an intermediate/advanced concept in Excel but in late 2018, Microsoft released dynamic array functions and formulas that "spill" into the cells below your current cell with a function.

This spreadsheet tip is based on a question I get asked all the time when I teach (well taught) Excel at in-person classes: How do I fill a formula down to the last row of my data set without over-shooting the last row with keyboard shortcuts?