When you’re creating some dashboard or report, one of the most common formatting operations you’ll find yourself doing is expanding the column width t...
Following up from episode #77 about mental models, I wanted to take things one step further and tie mental models to one of my favorite shows. If you ...
The promise of mental models is that it helps you bridge the gap between what’s in your mind and what happens in real life. They are interesting thoug...
Taking a slight detour off of the data analysis/spreadsheet path and getting into the world of productivity hacks with this episode. A productivity ha...
In episode 52, I talked about how to extract text from a cell. You might use this formula to extract a certain value from a cell when your database or...
While this little Excel/Google Sheets trick is a pretty straightforward hack, it led me to think about how we use our tools, how we stretch the capabi...
The path to a career in data analytics can be full of twists and turns. Along the way, you pick up tools like Excel, Python, Tableau, and R. What abou...
The impetus for this episode is a new Google Sheet (and Excel) tip I just shared on Instagram and TikTok (I never thought I’d join these platforms to ...
Learning the tips and tricks for doing data analysis in Excel is great and all, but stepping back to see the bigger picture leads to better questions ...
I’ve been planning a few advanced Excel classes with Skillshare and excited to launch my first one today called Advanced PivotTable Techniques for Ana...