New Excel feature alert! Probably one of the biggest announcements in a long time from the Excel world: a new function to supplant VLOOKUP and HLOOKUP. What is it you ask? The XLOOKUP function. Summary of XLOOKUP benefits I discuss some of the benefits...

A few months ago, The New York Times’ Digital Transition team headed by Lindsey Cook published a blog post about a data bootcamp they led for their reporters and editors. The New York Times frequently publishes amazing data visualizations,

I read a few excerpts from Superforecasting: The Art and Science of Prediction by Philip E. Tetlock and Dan Gardner. What does it mean to be a good forecaster? How can we take lessons from the book to be better modelers?

This is probably the most click-baity title for a blog post/podcast about Excel, but we don’t get many of these in the Excel world, right? It all started in 2002 with the Dilemma music video by Nelly featuring Kelly Rowland,

In episode 12, I talked about how you can use the IMPORTRANGE() function in Google Sheets to import data form a source Google Sheet to a target Google Sheet. In this episode, I get a little more technical and discuss how you can import data using Googl...

Have you ever wanted to share data from one Google Sheet with another Google Sheet? Maybe you are a freelancer and have multiple clients, and keep all the payment data in one Google Sheet but need to send updates to your clients without sharing all you...

Google Sheets or Microsoft Excel? An age-old question since Google Sheets came onto the scene in 2006. Many saw Google Sheets just as a copycat of Excel that lacked most of Excel’s features. Over the years,

Given that this is the 10th episode of the Dear Analyst podcast, I thought it would be relevant to reflect on how I got started with KeyCuts and joined various Excel communities. I never thought I’d make it to 10 episodes, but here we are!

If you want to count the number of cells with blank values in them, you may think it’s as simple as using the COUNTBLANK() formula. Usually you do this if you want to know how much data is missing in your data set. Say you have a list of 10 students,

What are some best practices for data analyst working in the medical field? I review this blog post from the Tableau blog by Barry P. Chaiken, MD about the type of analytics used in the medical field, and the trust that must be garnered between the ana...