Skip to content
MyExcelExpert
Learn
Excel A to Z Foundations Pro Excel Compass
Full Catalog
Projects
Build a Dashboard Prepare Data for AI Automate a Monthly Report Build a Budget Tracker
All Projects
Business
For Teams
Finance Sales & Marketing HR Operations & Admin Freelancers & Small Business AI for Work
Reference
Skill Index
Excel Functions Formulas Shortcuts
Excel Arena Pricing
EnglishFrançaisItaliano
Reference

Excel Functions Reference

Browse every function by category, or search by name.

Lookup
  • HLOOKUP
  • INDEX
  • MATCH
  • VLOOKUP
  • XLOOKUP
  • XMATCH
Math & Stats
  • AVERAGE
  • COUNT
  • COUNTA
  • COUNTIF
  • COUNTIFS
  • MAX
  • MIN
  • ROUND
  • SUM
  • SUMIF
  • SUMIFS
Logical
  • AND
  • IF
  • IFERROR
  • IFS
  • OR
Text
  • CONCAT
  • LEFT
  • LEN
  • LOWER
  • MID
  • PROPER
  • RIGHT
  • TEXT
  • TEXTJOIN
  • TRIM
  • UPPER
Date & Time
  • DATE
  • DAY
  • EOMONTH
  • MONTH
  • NETWORKDAYS
  • NOW
  • TODAY
  • YEAR
Dynamic Arrays
  • FILTER
  • SORT
  • UNIQUE
Advanced
  • GROUPBY
  • LAMBDA
  • LET
  • PIVOTBY
No function matches.
A
  • AND
  • AVERAGE
C
  • CONCAT
  • COUNT
  • COUNTA
  • COUNTIF
  • COUNTIFS
D
  • DATE
  • DAY
E
  • EOMONTH
F
  • FILTER
G
  • GROUPBY
H
  • HLOOKUP
I
  • IF
  • IFERROR
  • IFS
  • INDEX
L
  • LAMBDA
  • LEFT
  • LEN
  • LET
  • LOWER
M
  • MATCH
  • MAX
  • MID
  • MIN
  • MONTH
N
  • NETWORKDAYS
  • NOW
O
  • OR
P
  • PIVOTBY
  • PROPER
R
  • RIGHT
  • ROUND
S
  • SORT
  • SUM
  • SUMIF
  • SUMIFS
T
  • TEXT
  • TEXTJOIN
  • TODAY
  • TRIM
U
  • UNIQUE
  • UPPER
V
  • VLOOKUP
X
  • XLOOKUP
  • XMATCH
Y
  • YEAR
No function matches.
MyExcelExpert
Master Excel. Fast.
Structured video courses, daily challenges and team training — in English, French and Italian.
Platform
  • Courses
  • Business
  • Excel Arena
  • Pricing
  • Blog
  • Reference
Account
  • Log in
  • Register
  • Dashboard
  • Settings
  • Contact
Language
EnglishEnglishFrançaisFrançaisItalianoItaliano
© 2026 MyExcelExpert. All rights reserved.
Privacy Policy Terms of Service Contact