Articles by George Mount

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

Live from London! Global Excel Summit 2024

September 21, 2023 | George Mount

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% ...
[...Read more...]

Here are some quick wins for using Python in Excel

August 26, 2023 | George Mount

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

Review: Football Analytics with Python & R

August 24, 2023 | George Mount

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

How to format a column as percentage in Excel using openpyxl

May 22, 2023 | George Mount

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

How to automatically adjust Excel column widths in openpyxl

May 22, 2023 | George Mount

Excel’s popularity stems from its user-friendly data formatting and presentation capabilities. Take, for example, the nuisance of narrow columns. Resolving this issue in Excel is as simple as selecting the affected columns and double-clicking on any one of them: Python does present unique strengths to Excel, but visual formatting ...
[...Read more...]
1 2 3 4 5 10