Excel 2003 Basics – Data Entry

A viewer wrote in to request a few videos that cover “The Basics” in Excel 2003. In this video lesson, I cover the basics of data entry.

Even if you have been using Excel for a number of years, I guarantee that you will pick up one or two tips in this video that will save you time and make you more productive.

Here are the steps to follow in this video lesson:

  1. Excel aligns “text” entries to the left-side of the cell. “Numeric” entries (including Dates & Times) are aligned to the right-side of the cell.
  2. All calculations in Excel MUST start with the =sign. This includes Formulas and Functions. Write formulas that refer to other cells. (Avoid writing formulas that only use constant values.)
  3. When we input data in a cell and press the ENTER key, Excel accepts the entry and makes the cell that is down one row in the column the “Active Cell.”
  4. To input data in the cells of the same row – and continue to use the ENTER key – first select the range of cells in the row.
  5. You can also select a range of cells in adjacent rows and columns. Excel goes down the cells in the column first and then moves automatically to the top row in the next column in your selection.

News! My DVD, “The 50 Best Tips for Excel 2007” is now availabe to purchase. I invite you to visit my online bookstore for more details.

Find the Excel Video Lesson that you want – Index to all Excel Topics