Teaching analytics with modern Excel
I see people crafting all sorts of Excel pickup lines, but what about trash talk? After all, how many dates are Excel nerds getting anyway? (And let the trash talk begin.) Here are some Excel …
Continue Reading about Spreadsheet Smackdown! Excel Trash Talk to Crunch Your Rivals →
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 →
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 →
