
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
| Function | Use it to | Example |
|---|---|---|
| SUM | Add numbers | =SUM(B2:B20) |
| AVERAGE | Find the mean | =AVERAGE(B2:B20) |
| COUNT / COUNTA | Count numbers / non-empty cells | =COUNTA(A2:A20) |
| MIN, MAX | Find the smallest and largest | =MAX(B2:B20) |
| ROUND | Round 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
| Function | Use it to | Example |
|---|---|---|
| TRIM | Remove extra spaces | =TRIM(A2) |
| LEFT, RIGHT, MID | Pull part of a text value | =LEFT(A2,3) |
| TEXTJOIN | Join text with a separator | =TEXTJOIN(" ",TRUE,A2,B2) |
| TODAY | Show the current date | =TODAY() |
| EDATE | Move a date by whole months | =EDATE(A2,3) |
| IFERROR | Replace 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.
.png)