Teaching analytics with modern Excel
pandas DataFrame to an Excel table using openpyxlIn a previous post I covered how to get started automating Excel with Python using the pandas and openpyxl packages: The previous script will result in the following table: If you wanted …
Continue Reading about How to write a pandas DataFrame to an Excel table using 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 →
XLOOKUP()I've often called VLOOKUP() the "duct tape of Excel" for its ability to combine data from two sources. It's a phrase I even included in my book Advancing into Analytics, and I had a graphic …
Continue Reading about How to write modern lookup functions in Excel with XLOOKUP() →
Traditionally we've considered Excel a tool to be used only with relatively small, structured (i.e. rows with columns of consistent datatypes, etc.) data: However, the typical "rules" about what …
Continue Reading about How to conduct sentiment analysis in Excel with Azure Machine Learning →
Traditionally, filtering a dataset by multiple AND/OR conditions involved use of the Advanced Filters feature. While menu-driven, Advanced Filters can be difficult to manage and applies filters …
Continue Reading about How to filter a dataset by one or more criteria using Excel formulas →
