Many people are afraid of Excel because they imagine it is only for accountants and engineers. In reality, a small set of formulas covers most of what students, shop owners, office workers and freelancers need. If you learn the ten things below, you can track expenses, make marks sheets, prepare simple reports and save hours of manual work.
Quick answer: start every formula with an equals sign, learn SUM, AVERAGE, MIN, MAX, COUNT, IF, COUNTIF, SUMIF, VLOOKUP (or XLOOKUP) and ROUND, and practise them on a small real sheet from your own life. Everything below works in Excel and also in Google Sheets.
The basics first
A spreadsheet is made of cells. Each cell has an address, such as B3 (column B, row 3). A formula always begins with =. For example, typing =B2+B3 adds those two cells. When you change a number, the result updates automatically, and that is the real power of Excel.
1. SUM: add numbers
=SUM(B2:B10) adds every number from B2 to B10. This is the formula you will use most. You can also select a column of numbers and click the AutoSum button.
2. AVERAGE: find the mean
=AVERAGE(B2:B10) gives the average. Useful for marks, daily sales or monthly bills.
3. MIN and MAX: lowest and highest
=MIN(B2:B10) and =MAX(B2:B10) show the smallest and largest value. For example, your best and worst sales day.
4. COUNT and COUNTA: how many
=COUNT(B2:B10) counts cells that contain numbers. =COUNTA(A2:A10) counts cells that are not empty, including text. This is helpful for counting students, orders or entries.
5. IF: make decisions
=IF(B2>=50,"Pass","Fail") checks whether the mark in B2 is 50 or more. If yes, it shows Pass, otherwise Fail. IF is the foundation of many other formulas.
6. COUNTIF: count with a condition
=COUNTIF(C2:C20,"Pass") counts how many cells in the range say Pass. You could count how many orders are “Delivered” or how many bills are “Unpaid”.
7. SUMIF: add with a condition
=SUMIF(A2:A20,"Food",B2:B20) adds the amounts in column B only where column A says Food. A very handy way to see how much you spent in each category. Pair it with our monthly budget guide.
8. VLOOKUP or XLOOKUP: find a value in a table
Imagine a price list in one sheet and an order list in another. =VLOOKUP(A2,Prices!A:B,2,FALSE) looks for the item in A2 in the first column of the price table and returns the value from the second column. The final FALSE means exact match. In newer versions of Excel and in Google Sheets, XLOOKUP is easier: =XLOOKUP(A2,Prices!A:A,Prices!B:B).
9. ROUND: tidy up decimals
=ROUND(B2,0) rounds to the nearest whole number, and =ROUND(B2,2) keeps two decimal places. Use it for prices and percentages.
10. Text and date helpers
=TODAY() shows today’s date. To join text, you can use =A2&" "&B2 to combine a first and last name, or CONCAT in newer versions. These small tricks save a lot of typing.
Four habits that make you look like a pro
- Use $ to lock a cell.
$B$1stays fixed when you copy a formula. Press F4 after clicking a cell to add the dollar signs. - Turn on filters. Select your header row and press Ctrl + Shift + L to sort and filter data.
- Freeze the top row. View > Freeze Panes keeps your headings visible as you scroll.
- Format as a table. Ctrl + T makes a neat table that expands automatically.
Common errors
- #DIV/0! means you divided by zero or an empty cell.
- #NAME? usually means a typing mistake in the function name.
- #N/A in a lookup means the value was not found. Check for extra spaces.
How to practise
Do not just read formulas. Make a small sheet about something real: your monthly expenses, a class marks list, or the sales of a small shop. Use at least five of the formulas above. Keep your files organised using the tips in Google Drive and Docs. Spreadsheet skills are also valued by employers and clients, so add them to your CV, as in how to write a CV that gets read.