AutoComplete

Prior to this the autocomplete only found functions that started with the characters you entered.
For example typing in DAY now returns the following:

Intellisense drop-down when you start typing a function name. This drop-down automatically includes user defined functions.

Functions Not Listed

The following functions do not appear in the cell AutoComplete or the Insert Function Wizard.

ASC	Returns the text string converted from double byte to single byte characters.
CALL	(Removed in 2003) Returns the specification for a function or command using a registration ID.
CEILING.PRECISE	(CEILING.MATH) Returns the number rounded to the nearest integer or multiple (renamed).
CRITBINOM	(BINOM.INV) Returns the inverse of the probability distribution function for a binomial distribution (renamed).
DATEDIF	Returns the number of days, months or years between two dates.
DBCS	Returns the text string converted from single byte to double byte characters.
ECMA.CEILING	(CEILING.MATH) Returns the number rounded up by default to a certain multiple (renamed).
FLOOR.RECISE	(FLOOR.MATH) Returns the number rounded to the nearest integer or multiple (renamed).
ISO.CEILING	(CEILING.MATH) Returns the number rounded up by default to a certain multiple (renamed).
JIS	(Removed in 2013) (DBCS) Returns the text string converted from single byte to double byte characters (renamed).
PHONETIC	Returns the phonetic characters from a text string.
REGISTER.ID	(Removed in 2003) Returns the result after running an Excel 4.0 Macro function.
SINGLE	(Removed in 365) Returns the value from a cell range which is the intersection of a row OR a column.
SQL.REQUEST	(Removed in 2003) Returns the result after connecting to a data source and executes a SQL query.

ASC Returns the text string converted from double byte to single byte characters.
CALL (Removed in 2003) Returns the specification for a function or command using a registration ID.
CEILING.PRECISE (CEILING.MATH) Returns the number rounded to the nearest integer or multiple (renamed).
CRITBINOM (BINOM.INV) Returns the inverse of the probability distribution function for a binomial distribution (renamed).
DATEDIF Returns the number of days, months or years between two dates.
DBCS Returns the text string converted from single byte to double byte characters.
ECMA.CEILING (CEILING.MATH) Returns the number rounded up by default to a certain multiple (renamed).
FLOOR.RECISE (FLOOR.MATH) Returns the number rounded to the nearest integer or multiple (renamed).
ISO.CEILING (CEILING.MATH) Returns the number rounded up by default to a certain multiple (renamed).
JIS (Removed in 2013) (DBCS) Returns the text string converted from single byte to double byte characters (renamed).
PHONETIC Returns the phonetic characters from a text string.
REGISTER.ID (Removed in 2003) Returns the result after running an Excel 4.0 Macro function.
SINGLE (Removed in 365) Returns the value from a cell range which is the intersection of a row OR a column.
SQL.REQUEST (Removed in 2003) Returns the result after connecting to a data source and executes a SQL query.