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
The importance of Excel to the financial system
Excel is critically important to the whole financial system. The opportunities to improve the productivity and reliability of so many business processes mean that it really is worth investing the intellectual effort in becoming proficient in the use of Excel.
LAMBDA Formulaic Recursion: It’s All About ME!
LET was recently made Generally Available, followed by its sister function, LAMBDA, now released into the Office 365 Beta world. This function “completes” Excel and provides you with the ability to create your own reusable formulae.
Excel Tip of the Week #375 - Workbook viewing redux
In this General User post we’re revisiting and expanding on the topic of how to make the best possible view of your Excel workbook. Getting your view set up just right can do wonders for your workflow, so let’s dive in.
Chartech magazine
Chartech: 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.
Chartech: 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.
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.
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
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.
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
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
What does 2021 have in store for IT
There is no doubt 2020 saw some significant changes to working methods and practices and all the signs are that this will continue into 2021.
Open banking
A whole new way to view your financial information and interact with your money.
Exceptions - exceptions - exceptions!
Exception reports are a favourite tool. It is all very well having reports but is the underlying data in those reports a) correct and b) complete?
Checklists - an essential tool or filling forms for the sake of it?
Checklists are tools used to better organise your assignments and to verify, easily, your most important tasks. They are designed to reduce errors and ensure consistency and completeness.
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.