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 Excel. During the conversation, I mentioned my free white paper on essential Power Query ... [...Read more...]

In 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 data visualizations using Python, you have two options: automating the production of an Excel chart entirely from ... [...Read more...]

In 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 essential packages using Python with Excel: pandas and openpyxl. Why pandas for Excel? If you’... [...Read more...]

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 analytics and the role Excel will play in this transformation. Data is getting more complex In 2017, the International ... [...Read more...]

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 Institute (FMI) on an introduction to Python. Event description: If you’re a financial professional looking to grow your ... [...Read more...]

[...Read more...]

[...Read more...]

[...Read more...]

I’ve mentioned a few times on this blog (example) about the growing possibility for Python Excel interoperability. Here’s a simple task done in a way I wasn’t aware of (h/t — where else? — StackOverflow.) Usually when combining Python and Excel I use specific packages like openpyxl, xlwings ... [...Read more...]

[...Read more...]