Why You Should Add a Table of Contents to Excel What would you do if you had hundreds of sheets in an Excel workbook and needed to find a specific one for updating or modifying data? Searching ...

Excel Tables offer a range of features for working with list-style data.

To take a snapshot of a range not formatted as an Excel table using the Linked Picture tool, select the data, press Ctrl+C to copy it, and click "Linked Picture" in the Paste drop-down menu.

Drop-down lists in an Excel sheet can greatly facilitate data entry. Here's a look at how to use Microsoft Excel's data validation feature to create handy lists within your worksheets.

Here's how to create a pivot table in Excel to slice and dice your data, letting you perform in-depth analyses and spot important trends.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.

The 2019 version of Excel contains a wide assortment of new and improved features and capabilities. Here's a look at 12 of those upgrades.