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

Opinion and news analysis

Blockchain and cryptoassets

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.

Automated data extraction - where do I start?

You may already be on the road to becoming fully automated. But if clients still bring you boxes of receipts and paper bank statements, which you manually enter into systems like Xero and QuickBooks, then it might be time to consider automated data extraction. The question is where do you begin?

Hybrid working: making the tech work for teams

The pandemic has ushered in a new model of working, with many businesses considering adopting more flexibility in the longer term. That’s certainly the case for the Oil and Gas Authority, which is set to adopt a hybrid working method for its post-pandemic way of working.

Spreadsheet review – can Power Query help? Part 3

In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. This time we are going to move on from the Profile table that we created in Part 2 to rearranging our Table and positioning it above our original data for ease of reference. We will be using a range of techniques that demonstrate the versatility of the Power Query tools.

Top 12 Excel Combinations: 11. IF ISERROR (Error Trapping)

It’s a new year and I thought I would use 2024 as an opportunity to count down a very subjective “Top 12” of Excel function combinations. You can tell I have thought of at least two for this theme.

Spreadsheet review – can Power Query help? Part 2

Legacy Excel supports a range of functions and techniques that can help identify potential errors and problems within a spreadsheet as part of a review process. In part 1 of this series, we looked at some of the advantages of adding Power Query to your review toolkit. In part 2 we are going to look in more detail at some of those tools and techniques.

Microsoft Loop: Edit things from multiple entry points

Collaborating between apps has always been one of the weakest points of Microsoft Office. Loop Components allows users to edit a bullet list whilst in an Outlook email, whilst others edit in Teams’ meeting notes and it will update simultaneously in all places.

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.

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.

Office Scripts vs VBA: What’s the difference?

Office Scripts are a new scripting language for automating Excel. In this article, Mark Proctor explores how Office Scripts differ to VBA and what we can or cannot do with each.

Prioritising power efficiency

Article looks at how an increase in computing power can be balanced with the need for greater energy efficiency.

Mastering mid-tier technology

In our first post-pandemic research focused on mid-tier practice technology, we’ve seen some substantial changes in the landscape. Responses have given us cause to be optimistic, but also highlight challenges in the digital transformation journey. Addressing these challenges presents opportunities for firms, software providers and ICAEW.

Digitalisation of tax: international perspectives

Digitalisation is transforming how tax is reported and paid, with significant innovation and investment occurring in countries of all kinds. There is no single pathway to digitalisation, as our case studies show, but there is something to be learned from all of them.

Based on the materials created by ICAEW’s Tech Faculty, these resources became available to the wider ICAEW membership in January 2022.

Opinion and news analysis

The latest opinion and news analysis on tech issues and developments, including artificial intelligence (AI), blockchain, big data, and cyber security.

Practice Tips

Practical advice, guidance and case studies written for faculty members working in practice. Aimed at helping you benefit from the capabilities and navigate the risks arising from new technology

Tech essentials guides

Providing updates on the latest technology issues affecting the accountancy profession. They aim to bring practical tips and expert insights on a range of topics, setting you up for any action you'll need to take.

Tech Talk

Technology is at the heart of all organisations today. The pace of change is growing ever faster. In the coming years, the finance profession will be profoundly altered by new and evolving technologies.