For decades, Excel training meant formulas, charts, and PivotTables. Now, learners open Excel and see a Copilot icon in the ribbon, a Python cell, or an automated workflow running in the background. …
Copilot in Excel: How to build exponential smoothing forecasts with Python
Forecasting is a constant challenge for Excel users. Business data doesn’t just grow in straight lines... it shifts with trends, cycles, and noise. Exponential smoothing is a family of methods that …
Continue Reading about Copilot in Excel: How to build exponential smoothing forecasts with Python →
Python in Excel: How to do statistical bootstrapping with Copilot
As analysts, we constantly report on KPIs and metrics critical to our businesses. That's essential... but the numbers we present aren't always as black-and-white as they seem. Every metric comes with …
Continue Reading about Python in Excel: How to do statistical bootstrapping with Copilot →
My new upcoming O’Reilly Media live Online Training sessions
I'm excited to share that I have two new O'Reilly Online Learning courses coming up in April 2020: First Steps with Power Query for Microsoft Excel Course description: Power Query is a …
Continue Reading about My new upcoming O’Reilly Media live Online Training sessions →
Practice R and Python on the Cloud for Free
R and Python, the "dynamic duo" of data science, are both free, open-source programming languages. That means that there's no "vendor" in the sense that, say, Microsoft owns Excel. This can make …
Continue Reading about Practice R and Python on the Cloud for Free →
Guest Post: Three Things You’ll Love Doing in Power Query
[Note: This guest post is from Aprajita Sharma at ExcelChamps.com. I am a friend of ExcelChamps co-founder, Puneet, and look forward to learning from Aprajita as well. Today she shares how to perform …
Continue Reading about Guest Post: Three Things You’ll Love Doing in Power Query →