Teaching analytics with modern Excel
Waffle charts are a great way to visualize data as a grid of squares where each square represents a portion of the whole. Unlike pie charts, which can be hard to interpret with many categories, waffle …
Continue Reading about How to create a wafflechart in Excel →
Among all of the amazing enhancements in Excel, one that really resonates with the core of Excel is dynamic arrays. Spreadsheets became popular primarily because of their tactile ability to visually …
Continue Reading about How to create interactive visualizations in Excel using dynamic arrays →
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() →
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 →
