Teaching analytics with modern 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 →
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 →
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 →
