Data science

How to create and modify Excel workbooks with openpyxl

March 26, 2024 | George Mount

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

Copilot for Excel: How to work with Python code

March 25, 2024 | George Mount

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

Python in Excel: How to create moving averages

March 18, 2024 | George Mount

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 ...
[...Read more...]
1 2 3 96