Articles by George Mount

How to get the most of Python in Excel with the Anaconda Toolbox

November 30, 2023 | George Mount

The recent incorporation of Python into Excel marks a substantial leap in data analytics, combining Python’s powerful features with the accessible Excel workbook interface. Employing Python directly within Excel’s formula bar is noteworthy, yet add-ins further enrich this capability. This enhancement is particularly important considering that Python programming ...
[...Read more...]

How to resize Python plots in Excel

November 30, 2023 | George Mount

I’m not sure about your experience, but personally find Excel’s charting features antiquated at times. They can be quite finicky to use, particularly when it comes to customization. Iterating between various plots and executing tasks like combining different plot types or coloring by group proves to be challenging. ...
[...Read more...]

Python in Excel: How to understand how objects work

November 28, 2023 | George Mount

The concept of objects significantly distinguishes Python from Excel, enhancing its importance in programming. Integrating Python objects into Excel introduces unique behaviors and functionalities, which will be the focal point of this blog post. Download the following to explore this intriguing intersection of Python and Excel.   We’ll begin the ...
[...Read more...]

How to create a Pandas DataFrame with Python in Excel (three ways)

November 20, 2023 | George Mount

Python in Excel provides a user-friendly and data analysis-optimized approach, especially suitable for general analysts beginning with Python. Notably, it defaults to loading all data inputs as Pandas DataFrames, a wise decision considering Excel users’ familiarity with tabular structures. Basic Python, on its own, isn’t inherently tailored for such ...
[...Read more...]

How to navigate common pitfalls with using Python in Excel

November 5, 2023 | George Mount

In an earlier post, I discussed typical challenges Excel users face when transitioning to Python: This article will explore the unique “gotchas” that arise specifically when integrating Python in Excel. Importing packages Python packages are crucial for streamlined and clear data analysis. Many standard data-related Python packages come pre-installed in ...
[...Read more...]

Python for Excel users: How to avoid common pitfalls

November 5, 2023 | George Mount

As an Excel trainer with a focus on data analytics, I have instructed thousands of spreadsheet users in Python. This extensive experience has allowed me to analyze patterns in the learning process. Below are several frequent errors and misconceptions I’ve observed, especially among Excel users, who often approach problems ... [...Read more...]
1 2 3 9