ICAEW.com works better with JavaScript enabled.

Technology

Keep up-to-date with tech issues and developments, including artificial intelligence (AI), blockchain, big data, and cyber security.

In this section

Raising the bar on audit quality

As we take on the challenge of rebuilding a post-pandemic economy, it is also time to consider new ways to improve audit quality. Alex Russell takes a closer look at the key messages in a new faculty publication.

What is explainable AI?

The artificial intelligence and machine learning boom has led to concerns about ‘black box’ models and systemic bias. A solution to this is to build explainable AI. Technical Manager David Lyford-Smith explores what that means and how it can be done.

The role of technology in audit

The results of the FRC’s consultation on tech’s place in audit have been published. David Lyford-Smith takes a look at the lessons for the future.

The essential guide to blockchain

This guide from the ICAEW sets out the key features of blockchain, and the challenges it must face to reach widespread adoption. It includes case studies of real-life applications, as well as examining its impact on accountancy.

What is blockchain?

Blockchain technologies have the potential to disrupt the work of finance teams – particularly those focused on transactional tasks – by offering a system of universal entry bookkeeping, removing the need for independent verification. Here ICAEW’s Tech Faculty and Deloitte outline the basics of this complex and developing technology.

How to build an app stack

Not sure how to pick the right tools for your technology stack? Lesley Meall speaks to firms about their experiences and insights.

Excel update – Power Query can now use Dynamic Arrays as a data source

Up to a week or so ago, the Data Ribbon tab, Get & Transform Data group included a From Table/Range command that would create a new Power Query query from an Excel Table, a named Range or from a selected block of cells that would be turned into an Excel Table as part of the process. In the Insider, Beta Channel edition of Office 365, this option has now been renamed as From Sheet. This change in name is a result of the expansion of the available data sources within an Excel worksheet to include Dynamic Arrays.

Excel Community project – rescuing the lost archive – part 5

In October 2020, the web platform used for Tech News and the Excel Community was changed. Although there are many clear advantages of the new platform, one downside is the splitting of the content for both communities between current articles and the very extensive archive of articles built up over many years. The faculty team have sought to alleviate the problems by providing a tabular index to over 2,000 archive articles.

Excel Tip of the Week #393 - AND and OR

Hello all and welcome back to the Excel Tip of the Week! This week, we have a General User post in which we’re taking a review of the logical summary functions AND and OR. These were last covered in TOTW #127.

Finance in a Digital World

Digital transformation

ICAEW has brought together these resources to help you understand how digital technologies are transforming economies and workplaces. Learn what it means for businesses and accountancy practices.

AI for finance professionals

ICAEW has brought together these resources to help you understand artificial intelligence and what it means for finance functions. Here you'll find support on identifying how AI can benefit your organisation and how it to start implementing the technology.

RPA for finance professionals

ICAEW has brought together these resources to help you understand Robotic Process Automation (RPA), what it means for your organisation and how it to start implementing the technology.

The future of accountancy work

Digital technologies are set to have a revolutionary impact on the work of accountants, both in business and in practice. ICAEW has gathered together these resources to ensure its members understand how finance functions will change, the skills that will be needed and the role you will play.

Tax Faculty Budget Update 2021

In this webinar the Tax Faculty team will be reflecting on the announcements from the Budget

Tax news in brief

Highlights from the broader tax news week ending 3 February, which includes: a restrained Scottish Budget in light of the coronavirus pandemic and HMRC publishes a Brexit edition of its Agent Update with guidance on postponed VAT accounting.

Exam top tips

Nahla Betelmal, ICAEW Statistical Researcher, has compiled the following common mistakes students are making in their ICAEW CFAB and ACA Certificate Level exams.

Software

Data everyone

Some horror stories have arisen recently regarding the migration of data (or, to be more accurate, the inability to do so).

How to build an app stack

Not sure how to pick the right tools for your technology stack? Lesley Meall speaks to firms about their experiences and insights.

Risks and assurance of emerging technologies

Cognitive and automation technologies such as artificial intelligence (AI) have drawn a great deal of interest, but also concern about the potential for bias and misuse. ICAEW’s Tech Faculty examines the risks associated with the adoption of emerging technology and how these risks can be tackled through internal controls and assurance.