Analytics & AI for Modern Excel
I’ve been spending more time exploring Copilot Studio and what it can actually unlock for Excel workflows, sparked in part by some really strong content from Matthew Devaney: In my last post, I …
Continue Reading about How to create an expense report agent with Copilot 365 →
Like a lot of people, I’ve been digging deeper into AI agents lately. The difference is that I haven’t spent much time with tools like the Claudverse or OpenClaw. Most of my clients are deeply …
Continue Reading about How to upload Excel workbooks to Copilot Studio →
When introducing newcomers to Python in Excel, I typically recommend that they have some basic Python knowledge beforehand. This helps reduce the mental effort required to grasp the Python in Excel …
Copilot in Excel offers a wealth of opportunities, particularly for new users, to streamline and automate their work. However, there's a somewhat paradoxical requirement that this work must be …
Continue Reading about Copilot for Excel: How to work with Excel tables →
Most people know me as an expert in Excel and data analytics, but my career actually began in finance. I even earned a master's degree in finance and spent the majority of my brief full-time career as …
Continue Reading about How to automate reconciliations in Excel with Copilot for Finance →
pandas DataFrame to an Excel table using openpyxlIn a previous post I covered how to get started automating Excel with Python using the pandas and openpyxl packages: The previous script will result in the following table: If you wanted …
Continue Reading about How to write a pandas DataFrame to an Excel table using openpyxl →