Teaching analytics with modern Excel
Over the years, I've been a strong advocate for the integration of Python into the workflow of Excel users, followed by the incorporation of AI technologies. Microsoft has now directly integrated both …
Continue Reading about Excel, Copilot and Python… the new trinity of data analysis? →
As analysts, some of the more interesting, personal, and important data we might gather could come from surveys, and using Microsoft Forms is a great way to easily create and share those surveys. We …
Continue Reading about Power Automate for Excel: How to view Microsoft Forms responses in Excel →
Most of us remember writing book reviews in school, but reviewing a technical book is often an entirely different beast. Instead of simply commenting on whether you liked a story or not, you’re …
Continue Reading about How to review technical books: a comprehensive guide →
The TEXTBEFORE() and TEXTAFTER() functions in Excel represent a significant enhancement to the traditional Text To Columns feature, offering a higher degree of customization and auditability. These …
Continue Reading about How to understand the TEXTBEFORE() and TEXTAFTER() functions in Excel →
Working with text can be notoriously challenging because it's often unclear how to store the data. Should you combine first and last names in the same cell? What about city and state? Often, what …
Continue Reading about How to understand the TEXTJOIN() function in Excel →
When working with text data in Excel, it's common to need to split strings by various delimiters such as commas, semicolons, and so forth. Although the legacy Text to Columns feature has its uses, …
Continue Reading about How to understand the TEXTSPLIT() function in Excel →
