"Deadline-Beating Blueprints Trusted by Intermediate and Advanced Excel Users"

According to this Office article, there are 477 functions in Excel 2016. They are distributed this way:

Category Amount
Statistical 112
Math and trigonometry 80
Financial 55
Engineering 54
Compatibility 38
Text 33
Date and time 25
Lookup and reference 24
Information 20
Database 12
Logical 11
Cube 7
Web 3
Add-in and Automation 3
Total 477

The new Excel 2016 functions are shown below:

Function name Category Description
IFS Logical Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition.
SWITCH Logical Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.
FORECAST.ETS Statistical Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm
FORECAST.ETS.CONFINT Statistical Returns a confidence interval for the forecast value at the specified target date
FORECAST.ETS.SEASONALITY Statistical Returns the length of the repetitive pattern Excel detects for the specified time series
FORECAST.ETS.STAT Statistical Returns a statistical value as a result of time series forecasting
FORECAST.LINEAR Statistical Returns a future value based on existing values
MAXIFS Statistical Returns the maximum value among cells specified by a given set of conditions or criteria
MINIFS Statistical Returns the minimum value among cells specified by a given set of conditions or criteria.
CONCAT Text Combines the text from multiple ranges and/or strings, but it doesn’t provide the delimiter or IgnoreEmpty arguments.
TEXTJOIN Text Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

The functions that were renamed and moved to a different category are shown below:

Function name Category Description Note
BETADIST Compatibility Returns the beta cumulative distribution function In Excel 2007, this is a Statistical function.
BETAINV Compatibility Returns the inverse of the cumulative distribution function for a specified beta distribution In Excel 2007, this is a Statistical function.
BINOMDIST Compatibility Returns the individual term binomial distribution probability In Excel 2007, this is a Statistical function.
CHIDIST Compatibility Returns the one-tailed probability of the chi-squared distribution  In Excel 2007, this is a Statistical function.
CHIINV Compatibility Returns the inverse of the one-tailed probability of the chi-squared distribution In Excel 2007, this is a Statistical function.
CHITEST Compatibility Returns the test for independence  In Excel 2007, this is a Statistical function.
CONFIDENCE Compatibility Returns the confidence interval for a population mean In Excel 2007, this is a Statistical function.
COVAR Compatibility Returns covariance, the average of the products of paired deviations In Excel 2007, this is a Statistical function.
CRITBINOM Compatibility Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value In Excel 2007, this is a Statistical function.
FDIST Compatibility Returns the F probability distribution In Excel 2007, this is a Statistical function.
FLOOR Compatibility Rounds a number down, toward zero In Excel 2007 and Excel 2010, this is a Math and trigonometry function.
FTEST Compatibility Returns the result of an F-test In Excel 2007, this is a Statistical function.
GAMMADIST Compatibility Returns the gamma distribution In Excel 2007, this is a Statistical function.
GAMMAINV Compatibility Returns the inverse of the gamma cumulative distribution In Excel 2007, this is a Statistical function.
HYPGEOMDIST Compatibility Returns the hypergeometric distribution In Excel 2007, this is a Statistical function.
MODE Compatibility Returns the most common value in a data set In Excel 2007, this is a Statistical function.
NEGBINOMDIST Compatibility Returns the negative binomial distribution In Excel 2007, this is a Statistical function.
NORM.INV Compatibility Returns the inverse of the normal cumulative distribution  In Excel 2007, this is a Statistical function.
NORMDIST Compatibility Returns the normal cumulative distribution In Excel 2007, this is a Statistical function.
NORMSDIST Compatibility Returns the standard normal cumulative distribution In Excel 2007, this is a Statistical function.
NORMSINV Compatibility Returns the inverse of the standard normal cumulative distribution In Excel 2007, this is a Statistical function.
PERCENTILE Compatibility Returns the k-th percentile of values in a range In Excel 2007, this is a Statistical function.
PERCENTRANK Compatibility Returns the percentage rank of a value in a data set In Excel 2007, this is a Statistical function.
POISSON Compatibility Returns the Poisson distribution In Excel 2007, this is a Statistical function.
QUARTILE Compatibility Returns the quartile of a data set In Excel 2007, this is a Statistical function.
RANK Compatibility Returns the rank of a number in a list of numbers In Excel 2007, this is a Statistical function.
STDEVP Compatibility Calculates standard deviation based on the entire population In Excel 2007, this is a Statistical function.
TTEST Compatibility Returns the probability associated with a Student’s t-test In Excel 2007, this is a Statistical function.
VAR Compatibility Estimates variance based on a sample In Excel 2007, this is a Statistical function.
VARP Compatibility Calculates variance based on the entire population In Excel 2007, this is a Statistical function.
WEIBULL Compatibility Calculates variance based on the entire population, including numbers, text, and logical values In Excel 2007, this is a Statistical function.
ZTEST Compatibility Returns the one-tailed probability-value of a z-test In Excel 2007, this is a Statistical function.
EXPON.DIST Statistical Returns the exponential distribution In Excel 2007, this is a Statistical function.
FORECAST Statistical Returns a value along a linear trend In Excel 2016, this function is replaced with FORECAST.LINEAR as part of the new Forecasting functions, but it’s still available for compatibility with earlier versions.

 

Dare to simplify your workflow, get more done with less, and be seen like an Excel Authority?

Download my report 'How to Think Like An Excel Guru'!

Works great for intermediate and advanced Excel users!

We promise to do our best to keep your email safe