Excel remains a staple in the business toolkit, adept at facilitating quick analyses, reporting, and data entry. Beyond its prowess for on-the-fly, "back-of-the-envelope" tasks, Excel also offers …
Python in Excel: How to understand the Matplotlib package
Python's incorporation into Excel offers data analysts robust new tools, particularly in the realm of data visualization. This blog post introduces Matplotlib, a core Python library for crafting …
Continue Reading about Python in Excel: How to understand the Matplotlib package →
Will Python, Copilot, and Excel make Power BI obsolete?
Over on LinkedIn, Dennis Sawyers is always a lively and outspoken voice worth following. His latest post has sparked my interest, compelling me to share my own thoughts candidly. Dennis argues …
Continue Reading about Will Python, Copilot, and Excel make Power BI obsolete? →
How to become a citizen data analyst, data scientist and data engineer…. with just Excel!
A lot of people look at today’s AI boom and worry: “Are my Excel skills still useful? Will AI take my job and my spreadsheets?” The truth is the opposite. There’s never been a better time to lean into …
The End of DAX and M? How AI and Python Are Transforming Excel
As we delve deeper into the age of artificial intelligence and AI-assisted programming, a question arises: Are the plethora of programming languages in Excel becoming obsolete? With the advent of AI, …
Continue Reading about The End of DAX and M? How AI and Python Are Transforming Excel →
Python in Excel: Why use Python for data visualization?
Excel has for decades been a mainstay for business and data professionals, providing a familiar environment for organizing, analyzing, and visualizing data. Its built-in charts and graphs offer a …
Continue Reading about Python in Excel: Why use Python for data visualization? →