Publications by George Mount
How to create and modify Excel workbooks with openpyxl
Several packages facilitate working with Python and Excel, but openpyxl stands out as an excellent choice due to its comprehensive features for reading and writing workbooks. In this blog post, we will explore how to get started with creating Excel workbooks from scratch and modifying existing ones using openpyxl.For this lesson, I’ll assume you�...
3884 sym Python (339 sym/10 pcs) 1 img
How to create named ranges and tables in Excel with openpyxl
Working with Python code becomes significantly more manageable when objects are assigned clear, sensible names, and Excel is no different. This blog post covers how to create named ranges and tables in Excel using openpyxl.To begin this demonstration, we will import several modules from openpyxl, along with a sample of rows from the penguins datase...
3467 sym Python (1316 sym/10 pcs) 1 img
How to work with cells, rows and columns in Excel with openpyxl
Just like in biology, where cells are the building blocks of life, in your Excel workbook, cells serve as the foundational elements. In this post, you’ll discover how to interact with individual cells and then extend your knowledge to managing entire rows and columns using openpyxl.For this demo, I’ll assume you’re familiar with installing an...
3165 sym Python (1609 sym/17 pcs)
Copilot for Excel: How to work with Python code
One of the key insights Excel users should appreciate about Copilot is its vital role in keeping Excel current in the AI era. It achieves this by innovatively integrating multiple intelligence sources, expanding Excel’s functions beyond traditional spreadsheets. Today’s era is characterized by growing system interoperability.In particular, I’...
8125 sym 6 img
How to compare Python versus Power Automate for Excel automation
Excel users are increasingly tasked with accomplishing more with fewer resources. The volume of data to manage is constantly expanding, yet there are fewer individuals available to help manage it. Adding to this challenge is the looming presence of AI, which has instilled a fear of future job security in many. The concern is that failing to automat...
8432 sym 1 tbl
Python in Excel: How to create moving averages
For those interested in learning Python for Excel, a key area to explore is time series analysis. In particular, Python’s Pandas package is specifically designed to handle time series data effectively, often much better than Excel.In this post, we’re going to look at a common task with time series data: creating moving averages. This method hel...
5506 sym 5 img
How to resize Python plots in Excel
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.On the other hand, Python prov...
6282 sym 12 img
How to get the most of Python in Excel with the Anaconda Toolbox
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 Py...
10332 sym 24 img
How to get started using Python in Excel (First steps)
I’ve long advocated for Excel users to enhance their skills by learning some Python. In fact, I’m so passionate about this idea that I authored a book on how Excel users can embrace Python. However, I recognize the hesitation. Python isn’t just another application where you can simply navigate through clicks to learn; it’s a programming lan...
11843 sym 14 img
How to get the most of Python in Excel with the Python Editor from Excel Labs
The Python in Excel environment is notably user-friendly, especially for those accustomed to Excel. It resonates with users familiar with writing formulas and functions in Excel cells, as this is precisely the approach Python in Excel adopts.However, Python workflows differ from those in Excel. Rather than relying on interdependent cells, Python ty...
5300 sym 14 img