Continuing his exploration of the latest version of Excel, Simon Hurst delves into some of the new functions that may be useful for accountants.
In our latest trans-Atlantic Excel tip, David Ringstrom shows how the LARGE and SMALL functions can take some of the drudgery out of finding high/low values in your data.
Simon Hurst unearths and highlights some of the most commonly recurring themes from Excel Zone’s Any Answers.
Individual functions, such as sales marketing, operations and the supply chain, can contribute to the overall objective, explains Rod Newing.
Last month, David H Ringstrom discussed ways in which Excel formulae using SUM functions could be extended by using multiple criteria.
AccountingWEB.com contributor David H. Ringstrom CPA recently published a collection of useful tips on how popular formulae can be extended by using multiple criteria.
In another selection from his series of tutorials on AccountingWEB.com, David Ringstrom illuminates the uses of Excel’s FREQUENCY function.
Excel provides a handy fuction which calculates the number of working days (or weekdays such as Mon, Tue, Wed, Thu, Fri) between 2 dates. You can adapt it to take account of bank holidays.