Look what touched down in my mailbox today... 🏈 _Football Analytics with Python & R_ by Eric Eager and Richard Erickson. I had the pleasure to be a tech reviewer for this book …
Continue Reading about Review: Football Analytics with Python & R →
Using Python with Excel (LinkedIn Learning & Madecraft)
I’m excited to share that “pandas Analytics for Excel users,” a course I produced with Madecraft, is now available on LinkedIn Learning. View the course with a one-month free trial …
Continue Reading about Using Python with Excel (LinkedIn Learning & Madecraft) →
AI-Powered Excel: How to retrieve live data with linked data types
Linked data types are a cool use of AI, allowing Excel to recognize and link data to external sources automatically. This integration streamlines workflows and empowers users with up-to-date, …
Continue Reading about AI-Powered Excel: How to retrieve live data with linked data types →
AI-Powered Excel: Insert a PivotTable with Recommended PivotTable
Excel's PivotTable has always been a powerful tool for data analysis, but with the introduction of the Recommended PivotTable feature, it has become even more accessible and intuitive to unearth …
Continue Reading about AI-Powered Excel: Insert a PivotTable with Recommended PivotTable →
AI-Powered Excel: How to get the most of Recommended Charts
Data visualization is both an art and a science, and selecting the right chart can be overwhelming. My advice is to start by getting something on the page to break the logjam. You can always refine or …
Continue Reading about AI-Powered Excel: How to get the most of Recommended Charts →
AI-Powered Excel: How to create forecasts with Forecast Sheet
As analysts, we're frequently tasked with explaining past data and predicting future outcomes. Building a forecast can be invaluable for this purpose. Excel offers several methods for creating …
Continue Reading about AI-Powered Excel: How to create forecasts with Forecast Sheet →