Guides

The Most Important Excel Functions to Learn (In the Right Order)

Which Excel functions are worth learning? A simple order to follow, from SUM and IF to SUMIFS, lookups, text and date functions.

By ExcelPanda Team · Published · 5 min read

The order to learn them

Excel has hundreds of functions, and nobody uses them all. The sensible way to learn is to add one layer at a time, using each one on real data before moving on.

Level 1: The basics

Level 1 functions

FunctionUse it toExample
SUMAdd numbers=SUM(B2:B20)
AVERAGEFind the mean=AVERAGE(B2:B20)
COUNT / COUNTACount numbers / non-empty cells=COUNTA(A2:A20)
MIN, MAXFind the smallest and largest=MAX(B2:B20)
ROUNDRound to a set number of decimals=ROUND(B2,2)

New to formulas? Start with Excel formulas for beginners.

Level 2: Logic and conditions

IF is the first function that lets Excel make a decision, and SUMIFS and COUNTIFS add or count only the rows that match your conditions. Together they cover a huge share of reporting work. See the IF guide and the SUMIF and COUNTIF guide.

Level 3: Lookups

Lookups find a value in one table and bring it into another, such as pulling a price from a product list. Learn XLOOKUP if you have Excel 2021 or Microsoft 365, and VLOOKUP so you can read older files. Some people prefer INDEX with MATCH, which works in every version. Our XLOOKUP vs VLOOKUP post helps you choose.

Level 4: Text and dates

Handy text and date functions

FunctionUse it toExample
TRIMRemove extra spaces=TRIM(A2)
LEFT, RIGHT, MIDPull part of a text value=LEFT(A2,3)
TEXTJOINJoin text with a separator=TEXTJOIN(" ",TRUE,A2,B2)
TODAYShow the current date=TODAY()
EDATEMove a date by whole months=EDATE(A2,3)
IFERRORReplace an error with something friendlier=IFERROR(B2/C2,0)

Newer functions worth knowing

If you have Microsoft 365, FILTER pulls out the rows that match a condition and UNIQUE lists distinct values. They save a lot of manual work, but they will not work in older versions, so check who else will open your file.

Frequently asked questions

How many Excel functions do I need to know?

Excel has hundreds, but most people rely on a few dozen at most. Ten to fifteen well-chosen functions cover the bulk of everyday work.

Should I learn VLOOKUP or XLOOKUP?

If you have a recent version of Excel, learn XLOOKUP first because it is simpler and more flexible. Learn VLOOKUP too, because you will meet it in older files. See XLOOKUP vs VLOOKUP.

What is the hardest function for beginners?

Lookups and nested IFs tend to cause the most trouble. Practise them with small tables before using them on real data.

Are the newer functions available in every version?

No. FILTER, XLOOKUP and UNIQUE need Excel 2021 or Microsoft 365. Older versions will show a #NAME? error.

Sources and disclaimers

ExcelPanda is not affiliated with or endorsed by Microsoft. Microsoft and Excel are trademarks of the Microsoft group of companies.