Teaching analytics with modern Excel
Data analysts should be proactive about missing values in their data, as these can significantly impact analysis outcomes. First of all, many algorithms such as linear and logistic regression as well …
Continue Reading about Python in Excel: How to work with missing values →
Appending data sources is a common data cleaning task in Excel. And while Power Query offers robust methods for doing this, the immediacy and hands-on feel of Excel formulas can be unbeatable. The …
Continue Reading about How to understand the VSTACK() and HSTACK() functions in Excel →
As analysts, the ability to summarize and aggregate data on the fly is an essential skill. Traditionally, PivotTables have been a popular method for this purpose. However, a new, function-driven …
Continue Reading about How to understand the GROUPBY() function in Excel →
Dynamic array functions represent one of the most exciting new features in Excel. Although generally as straightforward in syntax to use as other Excel functions, their underlying mechanism for …
Continue Reading about How to understand the # spill operator in Excel →
The RANDARRAY() function is one of the newer additions to Excel's function library, providing a dynamic and versatile way to generate random numbers. Unlike the legacy RANDBETWEEN() and RAND() …
Continue Reading about How to understand the RANDARRAY() function in Excel →
The XMATCH() function, introduced in Excel in September 2019, is a powerful tool designed to replace and enhance the traditional MATCH() function. This post will explore a few detailed examples that …
Continue Reading about How to understand the XMATCH() function in Excel →
