Excel 2013: New functions

Partner
The Knowledge Base
Share this content
5

Continuing his exploration of the latest version of Excel, Simon Hurst delves into some of the new functions that may be useful for accountants.

Amongst all the other changes and new features in Excel 2013 there are many new functions scattered through the different categories. We’ll look at some of them here:

  • IFNA()
  • XOR() – exclusive OR()
  • NUMBERVALUE()
  • ISOWEEKNUM()
  • FORMULATEXT()
  • SHEET(), SHEETS()
  • Other new functions - There are about 50 new functions in total – many in the Engineering, Maths and Trig and Statistical categories. There is also a whole new category of Web functions for working with XML and webservices.

Please Login or Register to read the full article

Replies

Please login or register to join the discussion.

avatar
22nd Feb 2013 15:24

Looks worth waiting for....

I am so envious - these look useful but my (large) employer hasn't yet moved us forward to 2010 let alone 2013. And even when it does, I bet we have to restrict ourselves to lowest common denominator so we can share with parts of the organisation that are still to upgrade.

Thanks (0)
avatar
By dhockin
22nd Feb 2013 15:58

Sheet()

I see no value in this at all. A better use would to return the sheet name in the function, or the book name . This would replace the formula we tend to use to extract the sheetname or bookname from using search or find within cell ("filename")

 

Dave

Thanks (0)
avatar
22nd Feb 2013 18:38

Sheet()

dhockin wrote:

I see no value in this at all. A better use would to return the sheet name in the function, or the book name . This would replace the formula we tend to use to extract the sheetname or bookname from using search or find within cell ("filename")

 

Dave

 

 

Hi Dave

This is interesting in terms of sheets within a collection but that would be using VBA in which case you can already refer to a sheet by its name (what you see), class instance name or index in a collection. 

 

Sheets("name").Activate

wksInstanceName.Activate

Sheets(1).Activate

 

I can possibly see that you may want to know where the data comes from if using table names or defined ranges but I think I'm lost as you as I can already do that.

 

Anyone got any practical ideas?

 

Rich

Thanks (0)
avatar
24th Feb 2013 14:03

Excel Functions - formulae auditing

On an older version (I think XP?) it was possible to click on a cell containing a formula and use a function in the formulae tool bar to print the complete formula to paper.  Since then I have found that the only way to do this is to either increase the column size so that the complete formula is visible and then print it (this means that the whole operation has to be reversed in order to bring the spreadsheet back to original display) or to copy it to another worksheet and print it from there.

 

Has anthing changed in 2013 in order to address this problem?

Thanks (0)
By shurst
24th Feb 2013 21:26

Perhaps not the only way

I haven't come across that feature in XP, but Excel 2013 (at least the Professional Plus version) has the Inquire add in that offers a very comprehensive range of auditing and documentation tools, including the ability to export a listing of all formulas used to a separate workbook.

 

Thanks (0)