(c) American Institute of Certified Public Accountants. Contact AICPA for permission to reproduce this article., Accounting

Excel unveils function that improves on VLOOKUP

The new XLOOKUP is not yet generally available, but it and the new XMATCH make an X-cellent set. By Liam Bastick, FCMA, CGMA Editor’s note: Microsoft announced 29 October 2019 that it has changed the order of arguments for XLOOKUP. For more details, visit techcommunity.microsoft.com. Ask any accountant and they will tell you two “truths”: They are… Read More Excel unveils function that improves on VLOOKUP

(c) Chartered Accountants Ireland. Contact Chartered Accountants Ireland for permission to reproduce this article., Accounting, Accounting Profession

The shape of things to come

By Cian Molloy What lies in store for the accountancy profession? Cian Molloy investigates how the profession might fare in the years ahead. Since the arrival of the first accountancy software packages more than three decades ago, there have been regular predictions that IT would lead, if not to the death of the accountancy profession,… Read More The shape of things to come

(c) Institute of Chartered Accountants of Scotland. Contact ICAS for permission to reproduce this article., Accounting, Insolvency

ICAS issues first insolvency partial authorisation

By David Menzies ICAS has issued its first insolvency practitioner authorisation under the new partial authorisation regime. The development is the latest in a number of positive advances made in the area of IP regulation. ICAS has become the first professional accountancy body in the UK to issue authorisation for an insolvency practitioner under the new… Read More ICAS issues first insolvency partial authorisation

(c) Institute of Chartered Accountants of Scotland. Contact ICAS for permission to reproduce this article., Accounting, Careers

CIPFA members offered pathway to ICAS status

A new ICAS initiative has been launched offering CIPFA public finance accountants the benefits of membership of the world’s first professional body of accountants, and opening up the potential for them to work in both the public and private sectors. The Pathways initiative, which will be launched on 1 June 2016, offers CIPFA members two… Read More CIPFA members offered pathway to ICAS status

(c) Chartered Accountants Australia and New Zealand. Contact Chartered Accountants Australia and New Zealand for permission to reproduce this article., Accounting

Australian rugby on the back foot

By Anthony O’Brien As throngs of fans gather to watch the eighth Rugby World Cup this year, it’s clear that the game played in heaven is behind its rivals in Australia. The 48 matches of the Rugby World Cup (RWC), being played in England and Wales in September and October, are expected to reach a… Read More Australian rugby on the back foot