At nearly every public webinar I've run this year, somebody asks me some version of the same question: We don't have Copilot licenses. Is there anything we can actually do with AI in Excel? As …
How to learn Copilot in Excel from Stringfest Analytics
So you want AI in your spreadsheets? Copilot is sitting right there in the ribbon, your boss keeps forwarding you articles about it, and you have a feeling you should be doing something with it by …
Continue Reading about How to learn Copilot in Excel from Stringfest Analytics →
How to learn Python in Excel from Stringfest Analytics
So you, an Excel user, are interested in learning a bit of Python. Where do I suggest you start? Python in Excel changed the honest answer to this question. It used to be install Anaconda, set up …
Continue Reading about How to learn Python in Excel from Stringfest Analytics →
How to learn from Stringfest Analytics on a budget
Every so often I get an email that goes something like this: "I love your content, but I'm retired and on a fixed income. Will the workshop be free later?" Or a variation: "Will the recording be …
Continue Reading about How to learn from Stringfest Analytics on a budget →
How to find unmatched items with Python in Excel
Many business and data analysis questions ultimately come down to one basic comparison: Which values appear in one table but not another? In accounting, that might mean finding invoice numbers …
Continue Reading about How to find unmatched items with Python in Excel →
Python in Excel: How to understand data structure
(Before you read this, if you want to try these out in Excel for yourself, download the exercise file below. It includes the sample data and the Python snippets from this post, so you can actually run …
Continue Reading about Python in Excel: How to understand data structure →