What's new in Excel 2016 for Windows

Microsoft are adding new features to Excel, in part driven by user feedback via Excel UserVoice.

Recently added features are:

• Funnel charts. Show values across multiple stages in a process, typically resembling a funnel.
• Improved autocomplete. Searches all functions containing a partial name, rather than requiring an exact match.
• TEXTJOIN. Combines text from multiple ranges with each item separated by a delimiter that you specify.
• CONCAT. Like CONCATENATE, but supports range references in addition to cell references.
• IFS. Boolean conditions are tested in the order that you specify, including an else "catch all".
• SWITCH. Evaluates an expression against a list of values in order and returns the first matching result.
• MAXIFS. Returns the largest number in a range that meets a single or multiple criteria.
• MINIFS. Returns the smallest number in a range that meets a single or multiple criteria.