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.
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-membersTo read the complete article, join the IT Faculty, Excel Community or subscribe to Faculties Online.