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:
- XOR() – exclusive OR()
- 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.