Home » Ch 10 - decision support with spreadsheet software » Spreadsheet news – There are 6 new functions in Excel 2016!

Spreadsheet news – There are 6 new functions in Excel 2016!

With the fairly new cloud-delivery model, many subscribers of Office 2016 will have received news and updates of their selected products over the last couple of months. One that captured my immediate attention announced 6 new, quite useful functions in Excel 2016. They are:

  • TEXTJOIN: joins text strings in a simpler way than the CONCATENATE-function; very useful for address or email lists;
  • CONCAT: this replaces the old CONCATENATE function, and works in a similar fashion than its predecessor;
  • IFS: this is a great new function, as it helps avoid the need for nested IF-statements that can become quite lenghty;
  • SWITCH: provides a similar use to IFS, but works to a different logic. An expression is evaluated against a list of values, and specifies return values specific to each value;
  • MAXIFS/MINIFS: the newest additions to the family of COUNTIFS, AVERAGEIFS, and SUMIFS functions; these work similar to MIN and MAX, but can be tied to conditions to be met.

This Office blog post here provides more detail on the new functions, as well as further links to the individual functions.

At the same time, this is a very good example how SaaS models can help update software on an ongoing basis without the need to roll out fully new versions. Of course, this requires a stronger attention by accountants to new developments in their area of expertise.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: