As a long-time Python enthusiast who has frequently recommended Excel users delve into Python (and even authored a book on the subject), a prevalent question I encountered from hesitant Excel users is: What can I achieve in Python that I can’t in Excel? With the recent integration of Python ... [...Read more...]

[...Read more...]

I’m excited to share that “pandas Analytics for Excel users,” a course I produced with Madecraft, is now available on LinkedIn Learning. View the course with a one-month free trial here. Also be sure to check your local library, university or workplace for access. Course description Python is one ... [...Read more...]

I’m excited to share that “pandas Analytics for Excel users,” a course I produced with Madecraft, is now available on LinkedIn Learning.   Course description Python comes with its own built-in software library for data manipulation and analysis. It’s called pandas, and it’s an extremely fast and powerful ... [...Read more...]

Excel’s popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for business purposes. The following notebook demonstrates how to create a calculated percentage column in pandas and format the results in an Excel ... [...Read more...]

[...Read more...]

[...Read more...]

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