ICAEW.com works better with JavaScript enabled.

Sound FX

Excel’s functions can boost your processing power, but all too often their use causes significant errors. Simon Hurst guides you through the pitfalls

Almost all Excel users will have used at least one Excel function, even if it is only a SUM() function created by the AutoSum command on the Home or Formulas Ribbon tab. Functions significantly extend Excel’s capabilities and a good knowledge of the range of functions available, and what can be done with them, is essential to the efficient and effective use of Excel. However, as useful as functions can be, they can also be the cause of significant errors in Excel workbooks.

Find out more

Members of the IT Faculty, Excel Community and Subscribers to Faculties Online

Full article only available to IT Faculty members, Excel Community members and subscribers to Faculties Online.

Non-members

To read the complete article, join the IT FacultyExcel Community or subscribe to Faculties Online.