Publications by George Mount
How to navigate common pitfalls with using Python in Excel
In an earlier post, I discussed typical challenges Excel users face when transitioning to Python:Python for Excel users: How to avoid common pitfallsThis article will explore the unique “gotchas” that arise specifically when integrating Python in Excel.Importing packagesPython packages are crucial for streamlined and clear data analysis. Many s...
4993 sym 16 img
How to understand the initialization environment in Python for Excel
The availability of Python integration within Excel has made Python an accessible and valuable skill for many Excel users to consider adding to their toolkit.However, as an open-source programming language, Python operates differently from proprietary spreadsheet software like Excel.This post examines a significant distinction—the use of packages...
5064 sym 2 img
Python for Excel users: How to avoid common pitfalls
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 with a distinct mindset a...
7372 sym 2 img
Live from London! Global Excel Summit 2024
After a pandemic-induced hiatus and move to fully virtual, the Global Excel Summit is BACK in hybrid format this February 2024, live from London, UK.I’m super excited to participate in person at this year’s event. Would you like to join me? Use promocode GEORGE at checkout to get 10% of all tickets:Please note I am an affiliate of this program ...
2152 sym 2 img
Here are some quick wins for visualizing data with Python in Excel
In a previous post I explored some “quick wins” for wrangling and analyzing data in Python that would be otherwise difficult to do in Excel. That post largely avoided data visualization, so this post will be on a similar topic — visualizations that would be difficult to build in regular Excel but relatively straightforward in Python, particul...
10565 sym 38 img
Here are some quick wins for using Python in Excel
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 into Excel, much of the skepticism around learning Python ...
10492 sym 36 img
Review: Football Analytics with Python & R
Look what touched down in my mailbox today… _Football Analytics with Python & R_ by Eric Eager and Richard Erickson. I had the pleasure to be a tech reviewer for this book and recommend it to anyone interested in, as the subtitle suggests, learning data science through the lens of sports.What I particularly love about this title is that it sta...
1297 sym 8 img
Using Python with Excel (LinkedIn Learning & Madecraft)
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 descriptionPython is one of the world’s most widely used object-oriented...
2201 sym
Pandas analytics for Excel users (LinkedIn Learning & Madecraft)
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 for FREE for 24 hours with this link. Course descriptionPython comes with its own built-in software library for data manipulation and analysis. It’s called pandas, and it’s an extremely f...
1976 sym
How to format a column as percentage in Excel using openpyxl
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 workbook...
922 sym