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 for Excel: How to work with Excel tables
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 →
How to automate reconciliations in Excel with Copilot for Finance
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 →
How to write a pandas DataFrame to an Excel table using openpyxl
In 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 →
A tour of the Power Query Editor in Excel
Power Query is possibly the most exciting new Excel feature of its generation... but you might never know it considering how hidden it is from the Excel interface! If you're looking to connect a data …
Continue Reading about A tour of the Power Query Editor in Excel →
Every dataset in Excel should include these two features
Don't listen to the haters. Excel is a fantastic way to learn data analytics and a valued slice of the data analytics stack. That said, you may need to make a couple of tweaks from Excel's "default …
Continue Reading about Every dataset in Excel should include these two features →