Teaching analytics with modern Excel
openpyxlIn a previous post, I discussed Python's role in the modern Excel stack. Another advantage of using Python with Excel is the wealth of data visualization options available. When working with Excel …
Continue Reading about How to visualize data in Excel with openpyxl →
pandas and openpyxlIn an earlier post I wrote about the role of Python in modern Excel and what spreadsheets users stand to gain by learning the programming language: In this post, we'll compare and contrast two …
Continue Reading about How to use Python and Excel together with pandas and openpyxl →
As the world of data analytics grows vaster and more complex, what role will Excel serve? Will it become obsolete in an AI-powered data ecosystem? This post explores the emergence of augmented …
Continue Reading about How to understand augmented analytics and the future of Excel →
This event has concluded. Thank you to the Financial Modeling Institute for the opportunity to present. In March 2023 I had the opportunity to lead a one-hour webinar with the Financial Modeling …
Continue Reading about Introduction to Python (Financial Modeling Institute presentation) →
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 …
Continue Reading about What is the role of Python in modern Excel? →
These courses are now available for viewing on LinkedIn Learning and can be accessed here. Happy viewing and thanks again to Madecraft for partnering on the production! In January 2023, I traveled …
Continue Reading about What it’s like recording analytics courses at a professional studio →
