Excel Function List
Excel functions by category. Optional arguments in white. Click any function for a detailed description with formula examples. Also see 500 Formulas and 101 Functions.
Logical
Date and time
Lookup and reference
Text
Dynamic array
Lookup values in range or array
lookuplookup_arrayreturn_arraynot_foundmatch_modesearch_mode
Engineering
Financial
Information
Math
Trigonometry
Statistical
Predict value with a seasonal trend
target_datevaluestimelineseasonalitydata_completionaggregation
Get confidence interval for forecast value at given date
target_datevaluestimelineconfidence_levelseasonalitydata_completionaggregation
Get length of the seasonal pattern
valuestimelinedata_completionaggregation
Get statistical value related to forecasting
valuestimelinestatistic_typeseasonalitydata_completionaggregation
Web
Database
Download 200+ Excel Shortcuts
Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.