Publications by George Mount
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
How to automatically adjust Excel column widths in openpyxl
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 of the data can b...
906 sym 2 img
How to understand the relationship between pandas, openpyxl and Power Query
In an earlier post I provided an overview of how to use the pandas and openpyxl packages together to automate the production of Excel workbooks. In that post, I likened pandas as the “Power Query of Python,” highlighting its role in cleaning and transforming tabular data.Readers might question the need for a Power Query substitute in Python whe...
2843 sym 2 img
How to improve your Excel skills (FP&A Today podcast)
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 knowledge for Excel users. Download it below.five-things-excel-users-sho...
857 sym
How to visualize data in Excel with openpyxl
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 Python, or creating a Python visual an...
1416 sym 1 tbl
How to use Python and Excel together with pandas and openpyxl
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:What is the role of Python in modern Excel?In this post, we’ll compare and contrast two essential packages using Python with Excel: pandas and openpyxl.Why pandas for Excel?If you’re working with any...
6062 sym
How to understand augmented analytics and the future of Excel
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 complexIn 2017, the International Data Corporation (IDC), a market intelli...
7504 sym
Introduction to Python (Financial Modeling Institute presentation)
This event has concluded. Thank you to the Financial Modeling Institute for the opportunity to present.In March 2023 I had the opportunity to lead a one-hour webinar with the Financial Modeling Institute (FMI) on an introduction to Python. Event description:If you’re a financial professional looking to grow your data analysis skills, Python offer...
1892 sym