Tech Faculty Board and Committees
The Tech Faculty Board exists to provide oversight to the Faculty's activities and help guide staff.
Tech Faculty member resources
A comprehensive and accessible package of guidance and technical advice to help you stay ahead of the rest.
Popular resources
Featured items
Excel Tip of the Week #390 - Advanced uses of INDEX
Hello all and welcome back to the Excel Tip of the Week. This week we have a Creator level post in which we’re taking a deeper dive into the INDEX function, covering some of its lesser-known qualities, and examining how to use these for some common Excel tasks
Excel Tip of the Week #389 - Power Query Dropping Rows and Columns
Hello all and welcome back to the Excel Tip of the Week! This week, we have a Creator level post in which we’re looking at how to remove rows and/or columns from data imported into Power Query – either manually or automatically.
Digital skills at work – a neglected gap
For some time now, there has been a steady stream of reports and publications which discuss the impact of changes in technology on skills required in the workplace and identify a “digital skills gap” in some form.
Chartech magazine
March/April 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
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.
November/December 2020
In this issue: Christmas gift ideas; tech news from around the world; accountants should embrace the world of AI; AI and the future of accountancy; common data modelling, cyber security; finance automation, and Excel tips.
September/October 2020
In this issue: topical technology news from around the world; Fraud Advisory Panel reveals the COVID-19 tricks crooks use; the work to digitalise the EU; how IT has helped firms during the coronavirus crisis; and latest spreadsheet features.
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
The lesser-known Microsoft 365 apps
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.
Practical applications of AI
There is a lot of hype about AI at the moment, but to what extent are accountants really making use of AI?
Tech Faculty lecture - AI through the looking glass
The Tech Faculty Lecture, this year examines the advantages, opportunities and challenges bought the advancement of artificial intelligence.
How technology is transforming audit
Technology is transforming audit.
Disclaimer: 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.
Tech Essentials resources
The essential guide to robotic process automation
Robotic process automation (RPA) can save organisations' time, with tasks performed with higher speed and accuracy, as well as removing the risk of human error. However, it is not suitable for all processes and, in some cases, could act as a sticking plaster for a system that needs to be re-engineered.
The essential guide to audit tech
There has never been a more exciting time to explore the transformative potential of technology in relation to audit. Tech advances are helping to improve the performance of audit, making it more insightful and informing better conversations in audit teams and with clients.
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.
Practice tips
Changing telephone systems – get on with it!
Good old analogue telephone systems have been in place for many years in a two-office practice. This has not been without its challenges over that time.
How many silos of information exist... and why?
Information silos occur when different individuals or groups generate or record new data, but don’t integrate or share that information so that other parts of the business can view or use them.
Sharing files and information. Some winners and losers in this arena
Let’s start with HMRC. A VAT aspect investigation was started, and various information was requested be supplied.
How can you ensure that information is set up completely?
I have lost count of the number of times recently that I have had to send emails with screenshots asking people to ensure they tick the appropriate boxes.
Tech Talk videos
AI - what does it mean for the future of accountancy?
Join Artificial Intelligence expert Professor Moshe Vardi on 30 June for this live-streamed event to discuss the growth of AI and its impact on the accounting profession.
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.
Cyber security: addressing a key business risk
A short film about cyber threats and how to mitigate the risk
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.