Basic Data Entry in Excel

BM101.02

⌨️ Keyboard Shortcuts:

  • Tab: Move to next cell.
  • Ctrl + Enter: Stay in current cell.

⏰ Estimated Learning Time: 30 Minutes

Objective

  • Learn how to input data into cells efficiently.
  • Understand how to edit, delete, and use basic tools like AutoFill.
  • Practice using shortcuts and navigating across the worksheet.

Fun Fact 🧮

  • Did you know a single Excel worksheet can hold over 17 billion cells? That is enough space to organize data for the entire world and more. With smart data entry, handling even the biggest spreadsheets becomes simple.

Key Concepts

  • Data Types:
    • Text: For names, labels, and descriptions (e.g., "Product Name").
    • Numbers: For quantities, prices, and calculations (e.g., 1234 or 12.34).
    • Dates/Time: Excel recognizes specific formats like "12/12/2024" or "10:00 AM".
  • Navigation:
    • Use Arrow Keys to move between cells.
    • Press Tab to move to the right and Shift + Tab to move left.
    • Use Ctrl + Home to go to the first cell (A1) and Ctrl + End to navigate to the last used cell.
  • Editing Data:
    • Double-click a cell to edit its contents.
    • Use F2 to edit directly without double-clicking.
    • Press Delete to clear cell contents.
  • Using AutoFill:
    • Drag the fill handle (bottom-right corner of a selected cell) to copy data or continue a pattern.
    • Example: Enter "Monday" and drag to autofill the rest of the week.
  • Undo and Redo:
    • Undo an action with Ctrl + Z and redo it with Ctrl + Y.

Lesson Steps

  • Open a Blank Workbook:
    • Launch Excel and create a new workbook.
  • Navigate to cell A1:
    • Use the keyboard or mouse to reach cell A1.
  • Enter Text Data:
    • In cell A1, type "Product Name".
    • In cell B1, type "Price".
    • In cell C1, type "Quantity".
  • Enter Numeric Data:
    • Below "Price", enter numbers like 10, 15, 20.
    • Below "Quantity", enter values like 5, 8, 10.
  • Enter Dates:
    • In column D, type dates in the format "MM/DD/YYYY" (e.g., "12/12/2024").
  • Use AutoFill:
    • In column A, type "Product 1" and drag the fill handle down to autofill "Product 2", "Product 3", etc.
  • Edit Data:
    • Change a price by double-clicking the cell or pressing F2.
  • Delete Data:
    • Highlight a range of cells and press Delete to clear them.

Common Errors

  • AutoFill Not Working: Ensure your data has a clear pattern for AutoFill to recognize.
  • Dates Displaying Incorrectly: Verify the correct date format under cell formatting options.
  • Accidentally Deleted Data: Use Ctrl + Z to undo.

Exercise

Scenario: You are managing an inventory list. Complete the following:

  • In column A, enter product names: "Apples", "Oranges", "Bananas", "Grapes", "Pears".
  • In column B, enter prices: 2.50, 3.00, 1.80, 2.20, 2.75.
  • In column C, enter quantities: 10, 15, 20, 25, 30.
  • Use AutoFill to continue the sequence of product names in column A to 10 rows.
  • Correct a mistake in the price of "Bananas" (change from 1.80 to 1.90).

Quiz

Question 1: Which shortcut moves to the next cell?




Question 2: What is the shortcut to undo an action?




Question 3: Which feature copies patterns like days of the week?




Solutions

  • Question 1: The shortcut to move to the next cell is Tab.
  • Question 2: The shortcut to undo an action is Ctrl + Z.
  • Question 3: The feature to copy patterns like days of the week is AutoFill.
Video Block
Double-click here to add a video by URL or embed code. Learn more