Table of Contents for Excel Functions and Formulas
4. Text Functions
- CONCATENATE (or CONCAT/TEXTJOIN)
- LEFT
- RIGHT
- MID
- LENGTH
- TRIM
- UPPER
- LOWER
- PROPER
- FIND
- SEARCH
- REPLACE
- SUBSTITUTE
- TEXT
- VALUE
5. Date and Time Functions
- TODAY
- NOW
- DATE
- DATEDIF
- DAY
- MONTH
- YEAR
- HOUR
- MINUTE
- SECOND
- WEEKDAY
- WORKDAY
- NETWORKDAYS
- WORKDAY.INTL
- NETWORKDAYS.INTL
7. Lookup and Reference Functions
- VLOOKUP
- HLOOKUP
- XLOOKUP
- LOOKUP
- INDEX
- MATCH
- OFFSET
- INDIRECT
- TRANSPOSE
8. Mathematical Functions
- ROUND
- ROUNDUP
- ROUNDDOWN
- ABS
- SQRT
- POWER
- EXP
- LOG
- LOG10
- PI
- CEILING
- FLOOR
- MOD
9. Statistical Analysis Functions
- GEOMEAN
- HARMEAN
- STDEV.P
- STDEV.S
- VAR.P
- VAR.S
- VARIANCE.P
- VARIANCE.S
- COVARIANCE.P
- COVARIANCE.S
- CORREL
- PEARSON
- KURT
- SKEW
12. Engineering Functions
- CONVERT
- BIN2DEC
- BIN2HEX
- DEC2BIN
- HEX2BIN
- BASE
- COMPLEX
- IMAGINARY
- IMREAL
- IMCONJUGATE
- IMABS
- IMARGUMENT
19. Statistical Probability Functions
- NORM.DIST
- NORM.S.DIST
- NORM.INV
- NORM.S.INV
- T.DIST
- T.INV
- CHISQ.DIST
- CHISQ.INV
- F.DIST
- F.INV
22. Forecasting Functions
- FORECAST
- FORECAST.LINEAR
- FORECAST.ETS
- FORECAST.ETS.SEASONALITY
- FORECAST.ETS.CONFINT
24. Time and Date Calculations
- DATE
- DATEDIF
- WORKDAY
- NETWORKDAYS
- EDATE
- MONTH
- YEAR
- WEEKDAY
- HOUR
- MINUTE
- SECOND
Tags:
Microsoft Excel
