The Doughnut Chart is a built-in chart type in Excel. Doughnut charts are meant to express a "part-to-whole" relationship, where all pieces together represent 100%. Doughnut charts work best to display data with a small number of categories (2-5). For example, you could use a doughnut chart to...Read more
To group a pivot table by day of week (e.g. Mon, Tue, Wed, etc.) you can add a helper column to the source data with a formula to extract the weekday name, then use the helper to group data in the pivot table. In the example shown, the pivot table is...Read more
In this example, the goal is to count the number of items sold and remaining, based on the data visible in columns B and C. The ID column holds unique ids, and the Sold column is used to record a sale. An "x" in the Sold column indicates the item has been sold. As is typical in Excel, there are...Read more
In the example shown, we want to mark or "flag" records where the color is red OR green. In other words, we want to check the color in column B, and then leave a marker (x) if we find the word "red" or "green". In D6, the formula is:
=IF(OR(B6="red",B6="
...Read more
The status bar is a name for the lower edge of the worksheet window, which displays various information about an Excel worksheet. The status bar can be configured to display things like sum, count, and average of the currently selected cells. It also displays information about the current status...Read more
A unary operation is an operation with only one operand (input). The double unary (also called a double negative) is an operation used to coerce TRUE FALSE values to ones and zeros in more advanced formulas, especially formulas that work with arrays.
For example, the screen above shows...Read more
The term "pairwise lifting" in Excel refers to a special case of "lifting" – a built in calculation behavior whereby functions that don't handle arrays natively are "lifted" and called once for each value in an array, returning in turn an array containing multiple results.
Pairwise...Read more
In this formula puzzle, we look at truck location GPS data, and ask: what formula will calculate the hours that each truck was stopped during the day?Read more
In this article, we take a short tour of some "unconventional" pivot tables you probably haven't seen before. These are interesting pivot tables created to analyze something other than sales data.Read more