Teaching analytics with modern Excel
Recently, I encountered a task in Excel where I needed to identify the top N values within each group. Generally, I've found that working with groups in Excel can be less than user-friendly for many …
Continue Reading about Python in Excel: How to find the top N values by group →
Download this post as a PDF: 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 …
Continue Reading about Python in Excel: How to create interactive visualizations →
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 →
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 →
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 →
openpyxlSeveral 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 …
Continue Reading about How to create and modify Excel workbooks with openpyxl →