Modern business intelligence demands speed, and utilizing AI tools for Excel is the ultimate way to hyper-charge your data workflows this year.

[GAS / Python / VBA / AI] The Reality of Technology Selection The golden rule for choosing tools is to base it on 'compatibility with the on-site environment,' not on trends or intuition. 'Because ...

XLIDE gives Excel VBA projects a modern VS Code workspace. Add one or more .xlsm, .xlsb, or .xlam workbooks to your VS Code project and XLIDE detects them automatically. Navigate each workbook's VBA ...

In the first installment, I discussed "Excel cleanup (data structuring)," which serves as the foundation for all efficiency improvements. The next thing you need is the "motive power" to keep tasks ...

This article is not about ethics, privacy, security, ownership, or corporate governance — I am going to circumvent all of this here by using some made-up data relating to supermarket sales: Here, I ...

Git XL is an open-source Git command line extension for managing Excel workbook files in Git. The extension makes git diff work for Excel VBA (xls, xlt, xla, xlam ...

In the rapidly evolving world of AI, OpenAI has launched ChatGPT Agent — a versatile tool that’s can transform our everyday tasks. ChatGPT Agent is an autonomous assistant capable of generating ...

Have you ever found yourself endlessly repeating the same tasks in Excel—formatting cells, applying formulas, or sorting data—wondering if there’s a better way? You’re not alone. Many Excel users ...

Have you ever found yourself endlessly clicking through repetitive steps in Excel, wishing there was a way to make the process smarter and faster? While Power Query is a fantastic option for ...

Right now, I'm working off one of Microsoft's infamous giant press releases. The company has a tendency to do brain dumps in press release form, so we both have to sift through the release to give you ...