Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. We'll show you how to use tables, named ranges, formulas, data validation, and table styles.

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.

Figure B How to use the UNIQUE () function in Excel If you’re using Microsoft 365 or one of the 2019 standalone versions of Excel, you can quickly create a dynamic list using the UNIQUE () function.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting.

A check mark box in an Excel spreadsheet is handy for ticking off items, but it can go much further. Excel check boxes can trigger calculations and provide visual indicators. For example, in ...

Are you still putting your data in plain, old spreadsheets? Excel 2013 makes it easy to link tables, create reports and more.