Thanks to the technology behind ChatGPT, it’s become surprisingly simple to query a data set in plain English. As with most generative AI, results from OpenAI’s API are still imperfect, which means ...

Back in late 2023, Microsoft announced Python integration in Excel. Like many, I was skeptical at first and continued to rely on VBA and built-in Excel formulas for data analyses and visualization.

The two worlds of Excel and Python are colliding thanks to Microsoft’s new integration to boost data analysis and visualizations. The two worlds of Excel and Python are colliding thanks to Microsoft’s ...

Have you ever found yourself drowning in a sea of messy spreadsheets, spending hours manually cleaning and organizing data? For many Excel users, this is a frustratingly familiar scenario. But what if ...

Power Query is a game-changer in terms of the amount of time I save, ensuring imported data is ready for analysis in Excel. If you're new to this tool, it's helpful to know a few commands that can ...