The Box and Whisker Chart shows the distribution of data into quartiles. Learn how to create a Box and Whisker Chart in Excel properly.

Excel's PivotTable Fields pane, with Month in the Rows box, and Sum Of Sales in the Values box. A PivotTable in Excel, with 2023 divided into quarters and months.

In Excel, you can apply direct formatting to cells' values or backgrounds to make the spreadsheet easier to read. However, when an Excel formula returns a set of values—known as a spilled array ...

Populating a dropdown with a dynamic list is easy thanks to Microsoft Excel’s UNIQUE() dynamic array function.

Is your chart boring? Try Excel’s people chart to liven things up. Susan Harkins shows you how.