Why write SQL queries when you can get an LLM to write the code for you? Query NFL data using querychat, a new chatbot ...

Discover expert Power Query tips to reduce steps, streamline workflows, and optimize performance for cleaner, faster data ...

In July 2025, Microsoft added lots of new capabilities to Excel. Starting off with a feature shared between Windows, Mac, and the web, we have Compatibility Versions.

By using these strategies, you’ll be able to streamline your workflows, save time, and unlock valuable insights from your datasets. Remember, mastering Excel Power Query is an ongoing journey.

Here’s what’s new in this version, and what it will cost you. Multiple new Excel features Excel 2024 gets several new features.

Power Query transformations can assist in splitting data into rows, based on various factors such as delimiter, text patterns, and data types.

Until now, users had to run Python code on Microsoft Azure’s cloud servers. To provide Python in Excel locally, Anaconda used Microsoft’s existing Excel plugin capabilities combined with their own ...