Stop losing your manual Excel edits during data updates with this guide to preserving custom columns in Power Query.

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

There is a common mistake that people who have learned Power Query tend to make: trying to do everything with Power Query. Power Query is not a panacea. It is important to understand what it excels at ...

At 49, I taught myself Power Query. As a member of the employment ice age generation, I started in non-regular employment and, after changing jobs nine times, I joined a foreign-affiliated IT company.

Ask Claude to analyse your Power BI data. Get answers — not context-window crashes. Connect Claude (or any MCP client) to your Power BI semantic models. Explore tables and measures, run DAX queries, ...

Have you ever felt like importing data into Excel is more complicated than it needs to be? Below My Online Training Hub walks through how Microsoft’s latest Excel functions, `IMPORTCSV` and ...

The task of converting JSON to an Excel CSV file won’t take a long time. We suspect it can take less than a minute if you move fast enough and have the relevant knowledge. In order to move on, you ...

Microsoft’s January 2026 update puts Excel back in the spotlight. After a brief pause late last year, the company has resumed its monthly feature recap, and this time the bulk of the changes land ...

Microsoft has restarted its monthly feature round-up, detailing how Excel changed during January 2026 across Windows, Mac, and the web. The headline upgrade is Agent ...

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 ...