ICAEW.com works better with JavaScript enabled.

Tech Faculty member resources

A comprehensive and accessible package of guidance and technical advice to help you stay ahead of the rest.

Featured items

Excel Tip of the Week #357 - Removing duplicates redux

This week we have a General User level post in which we're making a definitive re-examination of how to remove duplicates in your data using Excel. This was most recently covered in TOTW #98.

Chartech magazine

July/August 2020

Topical tech news roundup, advisory services, technology in audit, five Excel top tips, digital transformation and tech-driven contact tracing measures.

May/June 2020

Topical tech news from around the world, increase your productivity, is broadband keeping society together, home is the new workspace, greener tech, and risk and assurance in emerging technologies.

March/April 2020

What makes digital-first banking products so popular; climate change then and now; Excel tips; staying safe online; stronger partnership with NCSC; machine learning and artificial intelligence; and 100 years of women in accountancy.

January/February 2020

Topical tech news from around the world; is more regulation the way to promote cyber best practice?; what should smaller practices consider when looking for an IT provider?; avoiding spreadsheet errors; and the recent DDoS attack on the Labour Party.

Excel articles

Read the latest articles. Includes advice and guidance and top tips to improve your Excel efficiency and minimise spreadsheet risk.

Excel community

The Excel Community provides a 'one-stop shop' for accountants who want to use Excel.

Webinar recordings

Archive of webinar recordings. Includes financial modelling, PivotTables, Power Query, Excel Tip of the Week Live and many more.

Excel online training

There are now eight different suites of Excel online training available as part of your membership subscription – this is a major benefit. Improve your Excel capabilities and minimise spreadsheet risk.

Tech Faculty webinars

Risk and assurance in emerging technologies

In this publication launch, we will go through the key lessons of the report, discuss AI and automation as an example, and go over how to consider the risks and responses for other new tech.

Tech Essentials resources

Essential guide to world of add-ons

This guidance will help to shape your thinking on what is possible with add-ons; formulate and clarify firm (and client) expectations; recognise limitations and set boundaries; identify potential benefits and hurdles.

The essential guide to data protection when outsourcing

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.

The essential guide to data analytics for smaller firms

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’.

The essential guide to the virtual FD

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.

Practice tips

The HMRC digital roadmap

Making Tax Digital is a key part of the government’s plans to make it easier for individuals and businesses to get their tax right and keep on top of their affairs.

Tech Talk videos

Blockchain, bitcoin and the future of the accountancy profession

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.

Data – a world of opportunities

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.