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 ...

Adding a drop-down list in Excel is a quick and efficient way to choose predefined data. Here's how to create a drop-down list in Microsoft Excel.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

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