โ† Computer Fundamentals & MS Office learning path
Computer Fundamentals & MS Office ยท Module 6 of 10

MS Excel basics

Enter data and use simple formulas.

๐Ÿ“– Key ideas

  1. Excel is a grid of cells; each cell has an address like B3.
  2. Formulas start with =, for example =A1+B1.
  3. SUM, AVERAGE, MIN, MAX and COUNT are common functions.
  4. AutoFill copies a formula or series by dragging the fill handle.
  5. Format numbers as currency, percentage or date.
๐Ÿ’ก Real-life example: An Excel sheet is a smart notebook: change one number and every total updates itself.
CellOne box addressed like B3
FormulaCalculation starting with =
SUMAdds a range
Fill handleDrag to copy a formula