Python-bloggers

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...]

[...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...]

[...Read more...]

[...Read more...]

[...Read more...]

[...Read more...]

[...Read more...]