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 create a two-way lookup with Python in Excel
A two-way lookup is one of those everyday data tasks where Excel gives you plenty of options, but none of them feel totally satisfying. It is hard to avoid some messy nesting, usually involving a mix …
Continue Reading about How to create a two-way lookup with Python in Excel →
How to build a simple Excel model auditor with Python
With AI assistants and Excel agents now capable of producing entire workbooks from a prompt, we’re entering a world where models can be created in seconds. That’s exciting, but it also raises an …
Continue Reading about How to build a simple Excel model auditor with Python →
How to save and reuse prompts for Copilot in Excel
I get asked a version of this question nearly any time Copilot in Excel comes up in training or advisory work. These questions are reasonable. They also possibly reveal a misunderstanding about …
Continue Reading about How to save and reuse prompts for Copilot in Excel →