Teaching analytics with modern Excel
As Excel users, we often prefer to do all our work within Excel. However, there are times when we need to transfer data in and out of Excel for tasks like sending emails or tracking projects. In the …
Continue Reading about Power Automate for Excel: How to understand the different flow types →
As an Excel user, you're probably already familiar with the power and versatility of Excel in managing data, performing calculations, and generating reports. But imagine if you could take your …
Whether you're a seasoned financial analyst or a data-proficient professional, understanding the calculation of investment returns can help assess the profitability and risks of various assets. This …
Continue Reading about Python in Excel: How to calculate investment returns →
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() →
