Excel 2013: New functions

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.

Continued...

» Register now

The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.

Registration is FREE and allows you to view all content, ask questions, comment and much more.

Comments

Looks worth waiting for....

duncanphilpstate | | Permalink

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.

Sheet()

dhockin | | Permalink

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

RichardWhight's picture

Sheet()

RichardWhight | | Permalink

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

Excel Functions - formulae auditing

SouthEssex | | Permalink

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?

shurst's picture

Perhaps not the only way

shurst | | Permalink

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.