Teaching analytics with modern Excel
Upsampling time series data involves increasing the frequency of your data points by filling in gaps to transform a lower-frequency dataset into a higher-frequency one. This process is often necessary …
Continue Reading about Python in Excel: How to upsample and interpolate time series data →
In a previous post, we explored the GROUPBY() function as a formula-driven alternative to PivotTables in Excel: Although the GROUPBY() function is useful, it lacks a key feature: the ability to …
Continue Reading about How to understand the PIVOTBY() function in Excel →
Download a PDF version of this post below: A two-way or two-dimensional lookup in Excel allows users to search for a value at the intersection of a specific row and column within a table. This …
Continue Reading about How to do a two-way lookup in Excel with XLOOKUP() →
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 →
