Jump to content


Version 1601 - February 16, 2016 - 6 new functions, funnel charts, Black theme, annotations, improved AutoComplete and sharing

  • Please log in to reply
No replies to this topic

#1 Jonathan


    Forums Administrator

  • Administrators
  • 888 posts

Posted 10 May 2016 - 10:49 AM

Version 1601 (Build 16.0.6568.2025)

Released to Current Channel on February 16, 2016



Using these new features may cause your workbooks to become unusable by users who are not Excel 365 subscribers. Only Excel 2016 users who are Excel 365 subscribers will have access to these features.


Funnel charts


The Funnel Chart is a new chart type that is intended to work well with values that steadily increase or decrease over time, such as running totals. It can be accessed in the same way as all other chart types, as shown in the video lesson: Essential Skills Lesson 5-2 Create a simple chart with two clicks.


Improved Formula AutoComplete


Excel automatically displays a list of possible functions as you type a formula, as shown in Essential Skills Lesson 2-13 Create functions using Formula AutoComplete. For example, typing =SUM displays the possible functions SUM, SUMIF, SUMIFS, SUMPRODUCT, etc. This is known as Formula AutoComplete.


Prior to this update, Formula AutoComplete only displayed functions that began with the text that you entered. This update enables it to find the text you type in any part of a functions name, so now typing =SUM also displays the DSUM, IMSUM and SERIESSUM functions. This will make it easier to find the function you need even when you can't remember its exact name.


New Send As options


This update adds new sharing options, enabling you to choose to send your workbook as an attachment or as a PDF. Prior to this update, the sharing options only allowed you to save your workbook to the Cloud and send links to other users to enable them to access it online.


You can see how Excel 2016's online sharing works in the video lesson: Essential Skills Lesson 8-6 Share a link to a workbook.


CONCAT function


The CONCAT function is not really a new function; it's actually exactly just the CONCATENATE function renamed, presumably because CONCATENATE is a very long function name compared to most other Excel functions. CONCATENATE has not been removed so you can still use it to maintain compatibility with earlier versions.


You can see how to use the CONCATENATE function in the video lesson: Expert Skills Lesson 3-19 Use the TEXT function to format numerical values as strings.


Only Office 365 users will have access to the CONCAT function, so you should continue to use CONCATENATE instead if your workbook may need to be used by users of earlier versions or users who are not Office 365 subscribers.


TEXTJOIN function


The TEXTJOIN function is a brand new function that is designed to make it easy to create delimited text from a range of cells. For example, if cells A1:A3 contained the names Tom, Dick and Harry, you could convert them into the text Tom;Dick,Harry with the following formula: =TEXTJOIN(";",TRUE,A1:A3).


The TEXTJOIN function can be typed like any other function or accessed via the function library, as shown in: Expert Skills Lesson 3-3 Create an Excel PMT function using the Insert Function Dialog.


IFS function


The IFS function is a new function that is intended to make it easier to create IF functions that have multiple conditions without having to 'nest' them inside each other.


The IF function =IF(A1=1,"A",IF(A1=2,"B","C")) can be written more elegantly using the IFS function =IFS(A1=1,"A",A1=2,"B",A1>2,"C").


Aside from the more elegant syntax, IFS works identically to a set of nested IF functions, which you can learn about in the video tutorial: Expert Skills Lesson 3-5 Use the IF logic function.


SWITCH function


The SWITCH function is another way of simplifying complicated IF functions. Instead of allowing multiple completely different logical tests like the IFS function, the SWITCH function allows you to test a single cell for multiple different values.


For example =IF(A1=1,"A",IF(A1=2,"B","C")) can be written more elegantly using the SWITCH function =SWITCH(A1,1,"A",2,"B","C").


Everything that the SWITCH function can do can also be done using the IF function, as shown in: Expert Skills Lesson 3-5 Use the IF logic function.


MAXIFS and MINIFS functions


These new functions work in the same way as the existing SUMIFS and COUNTIFS functions, but return the maximum or minimum value instead of the sum or count.


SUMIFS and COUNTIFS are almost identical to SUMIF and COUNTIF, but they allow multiple logical conditions. You can see how to use SUMIF and COUNTIF in the video lesson: Expert Skills Lesson 3-6 Create an Excel SUMIF function and Excel COUNTIF function.


Black Office theme


Office Themes allow you to customize the color scheme used by Excel's interface. This update adds a new Black theme, which offers a darker color scheme with higher contrast, which may help to reduce eye strain.


Themes apply to all Office applications, not just Excel.


You can see how to select a theme in the video lesson: Essential Skills Lesson 1-3 Change the Theme in Office.


Ink annotations


This update adds a new Draw tab to the ribbon, which allows you to write and draw directly onto the screen when working with touchscreen devices or a stylus. This tab will not appear unless your computer has either a touchscreen or stylus available.


This feature extends to all of Office, not just Excel.


Sorting options in Open dialog


When browsing files using the File > Open dialog, you can now sort files by Name or Date modified. These features are also available in the Save As dialog.


This feature extends to all other Office applications except for Outlook.


Navigation options in Save As dialog


When saving a file using the File > Save As dialog, you can now navigate freely between folders without needing to use the Browse option.


This feature applies to Excel, Word and PowerPoint.

Jonathan is part of the professional team who answer Excel-related questions posted on the ExcelCentral.com forums.
Jonathan also tests our courses prior to publication and has worked on all of our ten world bestselling Excel books for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Jonathan has also worked on over 850 video lessons for or video courses covering Excel 2007, Excel 2010 and Excel 2013.
As well as extensive Excel knowledge, Jonathan has worked in the IT world for over thirteen years as a programmer, database designer and analyst for some of the world's largest companies.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users