Teaching analytics with modern Excel
AI doesn't always require large, complex applications. Even a simple tool like Flash Fill can make you feel like an AI master: In this post, we'll take a look at the well-known Flash Fill …
Continue Reading about AI-Powered Excel: How to get the most of Flash Fill →
I'm excited to share that "pandas Analytics for Excel users," a course I produced with Madecraft, is now available on LinkedIn Learning. Also be sure to check your local library, …
Continue Reading about Pandas analytics for Excel users (LinkedIn Learning & Madecraft) →
CALCULATE() function in Excel Power PivotExcel users have access to a wealth of powerful functions through Power Pivot and DAX, but one function stands out as particularly crucial: CALCULATE(). This function holds the key to dynamically …
Continue Reading about How to use the CALCULATE() function in Excel Power Pivot →
Although PivotTables in Power Pivot may appear similar to those in classic Excel, critical differences exist. Creating measures is one area where Power Pivot diverges from traditional Excel, as we …
Continue Reading about How to understand implicit versus explicit measures in Excel Power Pivot →
Despite claims that AI has made Excel obsolete, the combination of AI and Excel has actually increased the program's power and accessibility for extracting insights and querying data. That said, AI is …
Continue Reading about How to get AI-powered insights in Excel with Analyze Data →
openpyxlExcel's popularity is attributed to its user-friendly data formatting and presentation features. Although Python offers distinct advantages for Excel, its raw data output is often unsuitable for …
Continue Reading about How to format a column as percentage in Excel using openpyxl →