Excel 2013 New Functions

Excel is a mature product and the ability to use an expression language to calculate cell values in real time using a rich collection of functions is available for many years. Tens of millions of users are relaying on these functions for all sorts of applications and it is one of the well-known secrets of its success.

It is perhaps surprising that Microsoft continues to enhance the list of functions available in each release and Excel 2013 is no exception. It includes exactly 50 new functions. For a list of all new functions please see the following:

http://office.microsoft.com/en-us/excel-help/new-functions-in-excel-2013-HA103980604.aspx

Some of these new functions are very specific for particular audiences but there is at least one area that is a welcome new addition that overtime will surely become very useful. That is the area of using WebService calls to get additional information from external sources. The new functions include ENCODEURL, WEBSERVICE and FILTERXML to prepare, call and analyze the result of a WebService call. From an initial review it looks like a good start but probably will require additional improvement to better fit some of the modern API approaches. Few of my top wish list includes ability to make none GET based RESTful calls, sending large requests greater than 2048 bytes long and ability to extract values from JSON responses.

Excel 2013 complete list of functions by category:

http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HA102752955.aspx

If you have an older version of Excel please make sure to use the appropriate list of functions available for your version of Excel.

Excel 2010 complete list of functions by category:

http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspx

Excel 2003 complete list of functions by category:

http://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspx

Advertisements

Author: dave

Consider myself kid in soul and naive by choice. I am interested in people, technology and business and thrive when they all work together. My favorite quote and motto is that “You can fool some people some times but you cant fool all the people all the time” ― Bob Marley

One thought on “Excel 2013 New Functions”

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