Analytics & AI for Modern Excel
pandas, openpyxl and Power QueryIn an earlier post I provided an overview of how to use the pandas and openpyxl packages together to automate the production of Excel workbooks. In that post, I likened pandas as the "Power Query of …
Continue Reading about How to understand the relationship between pandas, openpyxl and Power Query →
I had a great discussion with host Paul Barnhurst along with fellow guests and Excel MVPs Mark Proctor and Celia Alves on why and how finance and FP&A can be more effective and efficient in …
Continue Reading about How to improve your Excel skills (FP&A Today podcast) →
openpyxlIn a previous post, I discussed Python's role in the modern Excel stack. Another advantage of using Python with Excel is the wealth of data visualization options available. When working with Excel …
Continue Reading about How to visualize data in Excel with openpyxl →
pandas and openpyxlIn an earlier post I wrote about the role of Python in modern Excel and what spreadsheets users stand to gain by learning the programming language: In this post, we'll compare and contrast two …
Continue Reading about How to use Python and Excel together with pandas and openpyxl →
As the world of data analytics grows vaster and more complex, what role will Excel serve? Will it become obsolete in an AI-powered data ecosystem? This post explores the emergence of augmented …
Continue Reading about How to understand augmented analytics and the future of Excel →
This event has concluded. Thank you to the Financial Modeling Institute for the opportunity to present. In March 2023 I had the opportunity to lead a one-hour webinar with the Financial Modeling …
Continue Reading about Introduction to Python (Financial Modeling Institute presentation) →
