Teaching analytics with modern Excel
nulls in Excel Power QueryIn Excel's Power Query, blank values are treated as nulls to signify the absence of data or to indicate an unknown, missing, or inapplicable value. This approach is consistent with database and …
Continue Reading about How to replace blank values with nulls in Excel Power Query →
The integration of Python into Excel marks one of the most thrilling advancements for the application in recent times. This feature offers Excel users a multitude of straightforward and rapid …
Continue Reading about How to insert a Python cell into your Excel worksheet (three ways) →
Fuzzy matching in Excel Power Query is a technique for comparing and linking data that may not be an exact match but instead shares similarities. This approach is particularly beneficial for …
Continue Reading about AI-Powered Excel: How to do fuzzy matching in Power Query →
Here's a frequent scenario in Excel: you need to create a new column that reflects patterns identified in an existing one. Excel provides several options for accomplishing this. First, there's …
Continue Reading about AI-Powered Excel: How to use Formula by Example →
In an earlier post, I discussed typical challenges Excel users face when transitioning to Python: This article will explore the unique "gotchas" that arise specifically when integrating Python in …
Continue Reading about How to navigate common pitfalls with using Python in Excel →
As an Excel trainer with a focus on data analytics, I have instructed thousands of spreadsheet users in Python. This extensive experience has allowed me to analyze patterns in the learning …
Continue Reading about Python for Excel users: How to avoid common pitfalls →
