Excel & Copilot Training for Teams
I am old enough to remember the computer room. You went to a particular room, sat at a particular machine, and did your computing. When you left, you were mostly done computing. Now the computer is …
Continue Reading about What will doing data analysis actually look like? →
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 →
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 →
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 →
(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 →
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 →
