Thinkabara

📗 Excel for Beginners · Lesson 1 of 10

Typing in cells

Google Classroom

Your first Excel lesson: what a cell is, how to type text and numbers, and how to fix and delete them.

The tasks in this lesson

1. Shopping list

  1. Click cell A2, type Milk and press Enter
  2. Click B2 and type 2
  3. In row 3: Bread, amount 1

💡 Enter moves down one cell. Tab moves to the next column.

2. Fix and delete

  1. 30 eggs is a mistake: click B4 and type 12 (typing replaces what was there)
  2. Click A6 and press Delete

💡 F2 or a double-click opens the cell for editing without erasing what is inside.

All lessons

  1. ✍️ 1. Typing in cellsCells, typing, fixing and deleting
  2. 🎨 2. Format a tableSelect a range, bold and dollar format
  3. 🧮 3. Your first formulaMultiply, add and subtract between cells
  4. ➕ 4. SUM and AVERAGEThe total and the average of a column
  5. ⬇️ 5. Drag and fillThe fill handle, and $ to lock a cell
  6. 🔢 6. MAX, MIN and COUNTThe most, the least, and how many filled in
  7. 🔀 7. IF: if... then...Pass or fail, and COUNTIF
  8. ↕️ 8. Sort a tableHigh to low, and alphabetical
  9. 📊 9. Your first chartA bar chart and a pie chart
  10. 🏠 10. Project: a family budgetEverything we learned in one sheet