I'm genuinely excited about the suite of AI tools Microsoft has been introducing for Microsoft 365, particularly Excel. However, I do wish the naming conventions were sometimes easier to understand. …
How to use Copilot in Excel for non-Excel tasks
Copilot in Excel can help with a variety of everyday tasks for working with your data, such as adding conditional formatting or creating basic calculated columns. But did you know that you can also …
Continue Reading about How to use Copilot in Excel for non-Excel tasks →
Python in Excel: How to create interactive visualizations
One of the greatest wins for Excel users learning Python is access to a comprehensive suite of data visualization tools. However, compared to Excel, the default plots produced with Python in Excel can …
Continue Reading about Python in Excel: How to create interactive visualizations →
Python in Excel: How to run a Monte Carlo simulation
Monte Carlo simulations leverage probability and randomness to simulate processes multiple times, exploring a wide range of possible outcomes. This approach can illuminate the inherent uncertainty and …
Continue Reading about Python in Excel: How to run a Monte Carlo simulation →
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 …
Continue Reading about How to work with cells, rows and columns in Excel with openpyxl →
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 …
Continue Reading about How to create named ranges and tables in Excel with openpyxl →