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

Find out more about how ICAEW's provision of information on technology is changing.

Chartech magazine

Chartech was the bi-monthly news magazine from the Tech Faculty. Its articles and news summaries aimed to keep members up to date with changes in technology. The last edition was published in December 2021.

November/December 2021

Listing
03 Dec 2021

In this final edition of Chartech: tech news round-up; how will the profession look in 2051; highlights from the former Tech Faculty; practice tips; accounting for the environment; Digitalisation of tax; Cybercrime week; cloud apps; smartphones; and Excel tips reflections.

September/October 2021

Listing
30 Sep 2021

In this issue: Tech Faculty is changing; topical tech news; public trust in data; cryptoassets; benefits of RPA; cyber crime insurance; hybrid working; Power Query; spyware; and data strategy

July/August 2021

Listing
30 Jul 2021

In this issue: Change management; topical tech news from around the world; how and why deepfakes work; project failures; artificial intelligence; formatted accounts; cyber attack on the US's Colonial Pipeline; and technology and the BEIS White Paper on audit reform.

May/June 2021

Listing
24 May 2021

In this issue: climate change and technology; successful accounting systems; keeping ahead of HMRC deadlines; fourth industrial revolution; protection from cyber attacks, the dark web; COVId-19 passports; and Excel Tips.

March/April 2021

Listing
30 Mar 2021

In this issue: Operational efficiency; topical tech news from around the world; agility is gaining popularity; surveillance of employees; big tech regulation; lessons from the FRC's consultation; pursuit of ethical AI; app stacks; and flaws in tech.

January/February 2021

Listing
25 Feb 2021

In this issue: Tech implications in the wake of the pandemic, holistic approach to tech, digital currency, future of remote auditing, forecasting, Python, and spreadsheet automation.

Excel news

News from our Excel community.

Exclusive Excel Tip of the Week #429 - Revisiting cross-sheet formulas

Article
18 Jan 2022

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 fresh look at how to write and work with formulas that reference cells on other worksheets. This was first discussed in TOTW #275.

The 2021 Excel Community pantomime – the answers part 2

Article
17 Jan 2022

We have split the answers to the 2021 Christmas pantomime function name hunt across two articles to make the list of functions more manageable and to extend the suspense.

The 2021 Excel Community pantomime – the answers, part 1

Article
13 Jan 2022

Answers to the first half of the 2021 Christmas pantomime function name hunt. We have included a list of the functions with brief descriptions of their purpose and, where applicable, links to Excel Community articles that cover the use of the function.

Exclusive Excel Tip of the Week #428 - Converting between statistical measures

Article
11 Jan 2022

Hello all and welcome back to the Excel Tip of the Week! This week we have a General User post in which we’re going to dive into some statistics, and in particular examine how to convert between various different common statistical measures.

Technology news from Insights

The latest news and features on all things technological and data related from our Insights section.

A year of transition: 5 major trends for 2022

Article
23 Dec 2021

ICAEW Chief Executive Michael Izza and subject matter experts from around the organisation discuss the major trends we should see in 2022.

EY: 76% of companies back globally consistent ESG standards

Article
14 Dec 2021

Finance professionals believe the COVID-19 pandemic has accelerated non-financial reporting efforts, but there is still an urgent need for them to do more according to new research.

Non-financial reporting: Addressing the challenges of the future with technology

Article
14 Dec 2021

How can technology be better utilised in company reporting? The FRC Lab examines why this is increasingly as important for non-financial information as it is for financial data.

How Eurobank got to grips with data analytics in internal audit

Article
07 Dec 2021

During the worst of the pandemic, Eurobank’s internal audit team took the opportunity to develop its data literacy as pressures to perform increased.

Countries looking to ban cryptocurrencies may play into the hands of Bitcoin

Article
06 Dec 2021

Fintech academic and chartered accountant Gavin Brown examines nation states’ love-hate relationship with cryptocurrencies and outlines how attempts to control them may drive citizens into the arms of such decentralised currencies.

Black Friday or Fraud Friday?

Article
25 Nov 2021

As we approach Black Friday and Cyber Monday, chartered accountants should take a moment to consider whether the offers they are seeing are really a good deal or whether they could be a scam.

Webinar archive

Stay up-to-date with the fast moving technology world by viewing the Tech Faculty's archive of events and webinars. You can also browse 2021's programme of events.

Practical Excel tips 2021

Webinar
07 Dec 2021

Learn fundamental skills to save you time dealing with the most common problems faced when using Excel.

Digitalisation: new service line opportunities

Webinar
07 Oct 2021

Increased use of cloud-based digital solutions is proving hugely beneficial to firms in running their own businesses as well as their client’s.

What's your data strategy?

Webinar
05 Jul 2021

Demystifying data. Before organisations can gain any value from data it is critical to have a clear data strategy that ties into an organisation's overall strategy.

Cyber security and data protection for hybrid working

Webinar
24 May 2021

While many people are keen to return to the office after a year of home working, most employees want the option to work part of the week remotely.

Exclusive The lesser-known Microsoft 365 apps

Webinar
20 Apr 2021

We are all familiar with Excel, Outlook, PowerPoint & Word but Microsoft 365 subscribers get access to many other apps which most don’t know exist.

Exclusive Practical applications of AI

Webinar
17 Nov 2020

There is a lot of hype about AI at the moment, but to what extent are accountants really making use of AI?

The opinions expressed by external guest speakers in interviews or other publications included on this website are, by their nature, those of the speaker. They are not necessarily fully endorsed by the ICAEW or purport to reflect the official policies and views of the ICAEW or its members.

TECHtalk videos

Watch our series of brief videos that describe some of the core transformational technologies that will help shape the future of accountancy.

Blockchain, bitcoin and the future of the accountancy profession

Webinar
13 Mar 2019

Join Mark Taylor and David Lyford-Smith of ICAEW, and Aynsley Damery of the Clarity Project, for the second in our series of IT Faculty ‘Tech Talks’, this time on the subject of blockchain, cryptocurrencies, and how these will affect the future of the accountancy profession.

Cyber security: addressing a key business risk

Webinar
31 May 2019

A short film about cyber threats and how to mitigate the risk

Data – a world of opportunities

Webinar
18 Jun 2019

Join Mark Taylor and Kirstin Gillon of ICAEW, and Anthony Sayce FCA of EY, for the fourth in our series of Tech Faculty ‘Tech Talks’, this time on the subject of data and the opportunities it presents for practice and business.

Practice tips

Practical advice, guidance and case studies written for members working in practice.

Exclusive Time for a rest over Christmas... or does the “tax returns outstanding list” spoil it?

Article
20 Dec 2021

Whilst offices tend to ostensibly close as far as the public are concerned, it does not mean that everyone is not actually working.

Exclusive Real world IT problems... wasted time when the IT doesn’t work

Article
13 Dec 2021

When everything works as expected and anticipated, there are no grumbles or complaints (well may be a few!).

Exclusive Alternative methods can save you time

Article
30 Nov 2021

I was on a product support call recently with a practitioner. We had tried talking through the issue he was having by telephone, but this was not getting very far.

Tech Essentials

The tech essentials guides update members on the latest technology issues affecting the accountancy profession, mixing practical tips and expert insight.

Exclusive The essential guide to data protection when outsourcing

eBook
25 Nov 2019
PDF (318kb)

It is often said that data is the new oil – the raw material that drives industry in so many ways. Like all resources, data needs to be used wisely and protected. This guide looks at protecting data when using outsourced services.

Exclusive The essential guide to data analytics for smaller firms

Helpsheets and support
29 Jul 2019
PDF (508kb)

Data – how you get it and what you do with it – has been an important part of the accountant’s role since the beginning; but it is only now, with data exploding in volume, variety and velocity, that accountants can start to add serious value to their business and that of their clients. As the guide says, ‘data analytics can broadly be defined as the use of data to support business decisions’.

Exclusive The essential guide to the virtual FD

Report
23 May 2019
PDF (274kb)

The Essential Guide to the Virtual Financial Director provides examples of how practitioners are providing this valuable service to a range of clients today. By reading the guide you will become familiar with the key concepts and be able to start exploring new services to your clients.

Exclusive The essential guide to cryptocurrency

Helpsheets and support
04 Apr 2019
PDF (277kb)

How do you account for cryptocurrencies? What tax is payable on crypto-transactions? What is the difference between a cryptoasset and a cryptocurrency? What is an ICO? This tech essentials publication provides guidance to help answer some of those questions.

Thought leadership

Read the latest thinking from ICAEW on how to ensure information services are working effectively and accountants are making the most of new technologies.

New technologies, ethics and accountability

Thought leadership report
03 Jul 2019

This thought leadership report delves into the ethics of new technology and the seismic developments currently taking place in AI and algorithms, which are both exciting and morally concerning.

Improve your financial modelling practice

Thought leadership report
12 Nov 2018

ICAEW’s Excel Community has worked with a broad swathe of modelling organisations and experts, taking a half dozen methodologies and paring down to the commonly held, widely accepted beliefs about what constitutes good modelling.

Hybrid working and the future of work

Hub page
18 Aug 2021

What opportunities and challenges will come with moving to a more digital workplace?

Automation in finance functions: lessons from India and the UK

Thought leadership report
15 Sep 2020

Drawing on real-life experiences, this collaborative thought leadership report by ICAEW and the Institute of Chartered Accountants of India (ICAI) considers how finance functions can harness automation to deliver greater value to business and the skills needed by accountants in the future.

Other tech publications and webinars

Exclusive Accelerate your evolution

Article
12 Jul 2019

Decisions on investment in technology today will shape how well you can exploit it tomorrow – inside and outside your practice.

Coronavirus (COVID-19): tech considerations around home working

Helpsheets and support
26 Mar 2020

26 March 2020: coronavirus is forcing many people to work from home to reduce social contact and minimise the associated risk of transmitting the disease. Technology is key to helping people work at home, so what are some of the things to consider when setting up and managing home working for your staff over the coming weeks and months? 

Join the Excel community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with the Excel resources provided by the Excel Community.

Membership is open to everyone - non ICAEW members are also welcome to join. Group membership for organisations is also available.

Find out more

More resources

Explore some of the other resources ICAEW produces on technology and data analytics.

Data Analytics Community

Join the community

Develop the advanced data analytics and visualisation skills needed to succeed in this insight-driven era.

Join now

Resources

Technology

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

Webinars and publications on technology and data