Teaching analytics with modern Excel
For those interested in learning Python for Excel, a key area to explore is time series analysis. In particular, Python's Pandas package is specifically designed to handle time series data …
Continue Reading about Python in Excel: How to create moving averages →
Think back to the last time you applied for a job. The process is filled with countless applications, dead-end leads, and fruitless interviews. It's a common misconception that embarking on a …
Continue Reading about How to create an intake form for Excel consulting projects →
Modern Data Analytics in Excel is my second book. On the one hand, publishing a second book doesn't seem as daunting or monumental as the first, because I'm familiar with the process. On the other …
Continue Reading about How to support Modern Data Analytics in Excel (besides buying it) →
As someone who has created LinkedIn Learning courses on AI for Excel and written extensively about the topic on my blog, I am frequently asked about how AI will influence the future of Excel. One of …
Continue Reading about How to understand what “AI-Powered Excel” is all about →
The growing excitement around artificial intelligence (AI) may lead you to wonder about the relevance of your Excel skills in an era increasingly dominated by intelligent machines and automation. I'm …
Continue Reading about How to make the transition into AI-Powered Excel →
One of my all-time favorite quotes about data visualization comes from legend Edward Tufte: At the heart of quantitative reasoning lies a single question: 'Compared to what?' In Excel, …
Continue Reading about Copilot for Excel: How to add conditional formatting to your workbook →
