You can use the AutoFill handle to quickly drag a series into existence. You can drag days of the week, months of the year, or a numerical series — you can even create your own custom series.

When working in Excel, you may wish to see the formulas in use on your worksheet to help you track down an error, or to see which cells are dependent upon other cells.

You can use data validation to restrict the type of information allowed in a given cell (or cells). In addition, you can use data validation to limit data to a predefined list of acceptable items and display the items as an in-cell dropdown list.

Use VLOOKUP to find corresponding information in a list of data.

Excel gives you the ability to combine text from multiple cells into a single destination cell.

In Excel, you can take a cell and split its text across columns in a number of ways. The easiest of these is to use the Text to Columns command under the Data menu in Excel.

After using a formula to change the way data appears you may want to extract the resulting value of a formula, but not the formula itself.

If you have data that contains additional spaces, there is a function you can use to trim them out. Select a destination cell for your formula. Type =trim([cell name]), then press Enter. Note: According to Excel’s Insert Function dialog box, “Trim removes all spaces from a text string except for a single space between words.”

Excel contains a vast array of functions you can use to perform various calculations. You can use Insert Function to become familiar with the functions available in Excel and to become familiar with what each of the functions does. Use Insert Function to insert a function you choose into an empty cell. You can search [...]