Browse by category. Click any formula to see how it works and jump straight into practicing it.
⌨️ View all keyboard shortcuts →This is a searchable Excel formulas list for learners, job seekers and working analysts. Each Excel function has its syntax, a plain-English explanation and an example. Popular Excel functions include SUM, SUMIF, SUMIFS, SUMPRODUCT, AVERAGE, AVERAGEIF, COUNT, COUNTA, COUNTIF, COUNTIFS, IF, IFS, IFERROR, IFNA, AND, OR, NOT, VLOOKUP, HLOOKUP, XLOOKUP, INDEX, MATCH, XMATCH, LOOKUP, FILTER, SORT, SORTBY, UNIQUE, SEQUENCE, TEXTJOIN, and more.
Want to try a formula? Open Excel formula practice and solve a question live, or read an in-depth tutorial such as how to use VLOOKUP, XLOOKUP vs VLOOKUP or INDEX and MATCH. Browse all Excel tutorials.
