This project offers a collection of functions and useful queries for Power Query Formula Language (also known as M language) and a loader to import source code from external modules into Power Query.

Power Query replaces risky and time-consuming manual edits with a safe, user-friendly system that speeds up everyday spreadsheet work.

Instead of tedious hands-on repairs, Excel lets you quickly clean, reshape, and combine CSV files through repeatable Power ...

These tricks show how AI tools, new import formulas, and classic features improve productivity. Excel has outlasted many tech trends, and in the age of AI, it remains very much in the mix. While new ...

The Time Series Brush Slicer enables users to select time ranges visually using a brush interaction over a time series chart. Unlike traditional slicers that query data for every filter combination, ...

If you often work with data that starts life as a text file or CSV, Microsoft Excel now has new built-in tools that simplify how that information gets pulled into a spreadsheet. The update introduces ...

Excel is a powerhouse at transforming and manipulating data, thanks to a wide variety of Excel formulas and in-app tools. Add Power Query to this already powerful mix, and you get an even more ...

It’s the end of the month, and you’re staring at a mountain of Excel spreadsheets that need updating. You sigh, knowing that hours of tedious work lie ahead. But what if I told you there’s a way to ...