EuSpRIG 2020 – Comparing options for building an audit sampling template in Excel скачать в хорошем качестве

EuSpRIG 2020 – Comparing options for building an audit sampling template in Excel

This video is ICAEW’s contribution to the 2020 conference of the European Spreadsheet Risk Interest Group(http://eusprig.org/). In this presentation, we compare the strengths and weaknesses of three approaches to building templates for audit sampling – with traditional Excel formulas, with the new dynamic arrays, and with VBA. ICAEW’s Excel Community provides blogs, webinars, online training, and more to help finance professionals be on top of their spreadsheet game. Available to anybody interested in learning more about spreadsheet best practice and tricks for a low annual cost, you can find out more about the Excel Community here https://www.icaew.com/groups-and-netw... . You can download the current versions of the templates used in this video here https://cutt.ly/BsaP84g