Between Power Query and Power Pivot alone, “modern” Excel boasts so many features that it’s impossible to learn them all. Add to that Office Scripts, Power BI, LAMBDA() and more and it’s easy to get overwhelmed. One “Excel-adjacent” tool that can be particularly intimidating for prospective learners is ...

In January 2023, I traveled to Santa Barbara, sunny Californ-i-a to record two data analytics courses with Madecraft. There will be plenty of opportunity to discuss the contents of these courses, but for now I’d like to reflect on the process of recording them in the studio. Making a video ...

Many packages exist for working with Python and Excel, but xlwings may be the most powerful all-around due to its many reading and writing features. This versatility, however, comes at the cost of being relatively more difficult to set up. For example, one of the most useful features of xlwings ...

1 hour to Power Query in Excel (PDQ = Pretty Darn Quick!) It’s the most exciting Excel development in a generation… but you’d be forgiven for not knowing about it! Overview This free one-hour workshop will serve as an introduction to Power Query in Excel: How tables serve as the “...

What makes data clean? You may not be able to name those qualities, but you likely know messy data when you see it. In this blog post, we’ll look at a frequent offender: unpivoted data. You’ll learn what this is, how it can make for “tidier” data, and ...

Python has become in many ways the lingua franca of computing, with the open source language being used in everything from web development to artificial intelligence to… why, yes… data analytics. If you’re a heavy Excel or Power BI user, Python is a great tool to add to your ...

To be honest, Python is not the easiest program to manage on your PC. I suggest newcomers download it from Anaconda because it does most of the behind-the-scenes lifting for you. Completely new to Python? Check out my Python launch checklist Among other benefits, Anaconda comes with many of the ...

John Michaloudis reserves an annual edition of his MyExcelOnline podcast to a roundup of the top Excel tips and tricks of the year from community leaders. I was happy to again be invited to participate in this podcast. This year, I chose more of a general piece of advice than ...