Guides

Excel for beginners: 10 formulas every parent and student should know

SUM, AVERAGE, ROUND, IF, COUNTIF, SUMIF, XLOOKUP and more, with what each one is for, plus free practice on real spreadsheets.

Updated November 20, 2026

The everyday five

SUM adds a range (=SUM(B2:B9)). AVERAGE, MIN and MAX describe a list of numbers. ROUND keeps money tidy (=ROUND(A2*B2,2)). These cover most budgets, grade lists and sales sheets.

Decisions and counting

IF makes a decision (=IF(B2>=60,"Pass","Fail")). COUNTIF and SUMIF count or add only the rows that match, like all the Food expenses. COUNTIFS and SUMIFS do the same with several conditions.

Looking things up

XLOOKUP finds a value in one column and returns the matching value from another, such as the price of an item code. Lock ranges with $ (like $B$2:$B$20) so the formula still works when you copy it down.

Practice on real sheets

Zero2Hero's Excel course has 20 topics where you type real formulas into a small spreadsheet and see the result as you type, including building reports and loan payments with PMT. French and Spanish function names work too. It's part of the subscription, and free until June 30, 2027. Zero2Hero isn't affiliated with Microsoft.

Open the Excel course →

More guides

Excel for beginners: 10 formulas every parent and student should know · Zero2Hero