Teaching analytics with modern Excel
Creating a dynamic dropdown list that expands or contracts with your source data is a fantastic way to enhance user experience in an Excel workbook! In this post, we'll explore how to set up a dynamic …
Continue Reading about How to create a dynamic dropdown list in 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 →
