One quick and easy way to add values in Excel is to use AutoSum. Just select an empty cell directly below a column of data, then on the Formula tab, select AutoSum > Sum.

You have several options when you want to enter data manually in Excel. You can enter data in one cell, in several cells at the same time, or on more than one worksheet at once.

To quickly identify a data series in a chart, you can add data labels to the data points of the chart. By default, the data labels are linked to values on the worksheet, and they update …

You can combine data from multiple cells into a single cell using the Ampersand symbol (&) or the CONCAT function.

You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table.

Use data validation rules to control the type of data or the values that users enter into a cell. One example of validation is a drop-down list (also called a drop-down box or drop-down menu). …

To summarize and report results from separate worksheets, you can consolidate data from each into a master worksheet. The worksheets can be in the same workbook as the master …

After you create a drop-down list, you might want to add more items or delete items. In this article, we'll show you how to do that depending on how the list was created.

Get stock prices and geographic-based data using the Stocks and Geography data types. These two data types are new, and they are considered linked data types. This articles explains how …

Learn how to insert data from a picture with Excel - and you can use your smartphone or tablet to take the picture. Excel's powerful AI capabilities can convert your hand written or printed data …