Teaching analytics with modern 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 significantly enhances the capabilities of Excel users, enabling more sophisticated data analysis and visualization. However, it's important to note that Python in Excel operates …
Continue Reading about How to see all packages available in Python in Excel →
AI is significantly enhancing Excel, making it a more powerful tool for data analytics. In this post, we explore a range of free AI-powered tools that enhance Excel's functionality, aimed at those who …
Continue Reading about How to choose the right free tools for AI-powered Excel tasks →
I'll be presenting online at the Excel Virtually Global online conference, this coming Weds, Oct 11 2024 at 1pm Eastern US time on the topic, "Modern Data Analytics in Excel." Get all the details …
When you think of predictive analytics, maybe you picture programming languages like R and Python or cloud platforms like Azure or Amazon AWS. The humble Excel spreadsheet is probably not top of mind …
Continue Reading about How to perform predictive analytics in Excel using the XLMiner add-in →
The paired samples t-test can be used to test for a significant difference in measurements across observations from one time period to another. This post will demonstrate how to conduct the test using …
Continue Reading about How to perform a paired samples t-test in Excel →
