Microsoft Excel 2010 can convert a worksheet to a data table to help you quickly analyze your related data in formatted rows and columns. When you need to expand the table layout, apply the Home ...

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

Excel automatically distributes these points along a uniform X axis. To add more data to the Y axis in a line chart, add additional numbers in cells below your existing data.

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.

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.