
Microsoft Excel helps people organize information, perform calculations, and present results. You do not need advanced formulas to begin using it productively.
1. Understand cells, rows, and columns
Every worksheet is a grid. Columns have letters, rows have numbers, and a cell address such as B3 identifies a particular position. Enter one kind of information per column to keep data organized.
2. Format a simple table
Create columns named Item, Quantity, Unit Price, and Total. Use clear headings and appropriate number formats. Avoid merging cells inside a data table because that can complicate sorting.
3. Write your first formula
If quantity is in B2 and unit price in C2, enter =B2*C2 in D2. Excel calculates the total. Copy the formula down for other rows and verify a few results manually.
4. Use SUM and AVERAGE
To add totals from D2 to D10, use =SUM(D2:D10). To calculate the average of values in B2 through B10, use =AVERAGE(B2:B10). Blank cells and text can affect how results are interpreted, so check your data.
5. Sort and filter records
Convert your range into a table or enable filters, then sort items alphabetically or show only records matching a condition. Make sure you select the whole dataset so rows remain intact.
Practice exercise
Build a small monthly expenses table with categories such as transport, stationery, and internet. Add amounts, calculate the total, and sort by category. Use invented practice data rather than sharing sensitive financial records.
Common beginner mistakes
- Typing totals manually instead of using formulas.
- Mixing dates, text, and numbers in the same column.
- Forgetting to save a backup copy.
- Sorting only one column and separating related data.
Next step: Learn relative and absolute cell references once these five skills feel comfortable.
Worked example: Build a classroom supplies budget
Enter the headings Item, Quantity, Unit price (TZS) and Total (TZS) in cells A1 through D1. Use these sample prices for practice.
| Item | Quantity | Unit price (TZS) | Expected total (TZS) |
|---|---|---|---|
| Exercise books | 12 | 1,500 | 18,000 |
| Pens | 8 | 500 | 4,000 |
| Rulers | 5 | 1,000 | 5,000 |
- Type
=B2*C2in D2 and copy it down to D4. - Type
=SUM(D2:D4)in D5. The grand total should be TZS 27,000. - Change the number of pens in B3 from 8 to 10. D3 should become 5,000 and D5 should become 28,000.
If a total is wrong, click the cell and inspect the formula bar. D3 should refer to B3 and C3. Enter prices as numbers, then apply number formatting so the cells remain usable in formulas.