Convert Text Numbers to Real
Numbers

If numbers don't add up correctly, they may be entered as Text, instead
of real numbers. Use this technique to fix them. For written instructions
for this Excel data entry tutorial see: Convert
Numbers

Excel Data Entry in Specific
Cells

Make it quick and easy to move through cells in a specific order,
by using a named range. For written instructions for this Excel data
entry tutorial, see the Contextures Blog article: Jump
to the Next Data Entry Cell in Excel

Fill Blank Cells From Above

If a worksheet contains cells that have been left blank, you can
fill in the blanks, by copying the value from the first filled cell
above the blank. By filling in the blanks, you'll be able to sort
or filter the list. The following technique makes it easy to fill
in the blanks.

Paste Values Mouse Shortcut

In this Excel video tutorial, you can see how to use
a mouse shortcut to copy cells that contain formulas, and then paste
those cells as values. This will lock in the values, so you can sort
or move the cells, without any problems.

This technique is the quickest way that I've found to
copy and paste the values.

If you prefer to use keyboard shortcuts in Excel, instead
of mouse shortcuts, you can find a long list of them on the Excel
Keyboard Shortcuts page.

Hyperlink - Create With an
Excel Mouse Shortcut

This video shows how you can use a quick and easy mouse
shortcut in Excel, to create a hyperlink to another cell in the workbook.
When the user click on the hyperlink, they'll be automatically taken
to the linked cell, without using any macros in your workbook.

You can use this Excel hyperlink technique to create
a table of contents in an Excel workbook, or to provide a quick link
from one worksheet to another worksheet. That will make it easier
for users to navigate through the workbooks that you create for them.

Paste Special to Increase Numbers
by Set Amount (Excel 2003)

In Excel 2003, you can increase or decrease all the numbers in a
range by a specific amount. For example, in a price list, all the
prices could be increased by $1.50, or the prices could be decreased
by 5%.

The technique shown in the following video makes it easy to increase
the prices on the worksheet, all at once, by using the Paste Special
command on the Excel menu bar. You'll type a value into a cell, then
copy that cell, and apply its value to other cells.

Paste Special to Increase Numbers
by Set Amount (Excel 2007)

In Excel 2007, you can increase or decrease all the numbers in a
range by a specific amount. For example, in a price list, all the
prices could be increased by $1.50, or the prices could be decreased
by 5%.

The technique shown in the following video makes it easy to increase
the prices on the worksheet, all at once, by using the Paste Special
command on the Excel Ribbon. The technique is similar to the steps
in the previous video, for Excel 2003, but the command is in a different
location. You'll type a value into a cell, then copy that cell, and
apply its value to other cells.