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
Community Power BI project – rescuing the lost archive – they think it's all over
For details of what this project is all about and how to develop your own version, please look at the Excel archive file article listed below:
Data visualisation – small multiples
With the introduction of many new chart types in Excel 2016 and later versions, Excel now has over a dozen main charts with lots of sub-types available. Good as Excel's charting capabilities might be, using Power BI to present the data from your Excel workbook opens up a whole new set of possibilities
Top ten excel formulas: your questions answered
Answers to questions asked during the recent webinar, The Top 10 Excel Formulas
Chartech magazine
May/June 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
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.
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
We now offer a new and improved range of Excel online training which is available as part of your Excel Community membership subscription – this is a major benefit. Track your progress and improve your Excel capabilities and minimise spreadsheet risk.
Tech Faculty webinars
What's your data strategy?
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
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.
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?
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
Digital transformation – all change
Digital transformation can mean different things to different people; it is a catchall term describing the implementation of new technologies and processes to improve business operations.
Payroll issues - it never rains but it pours
Payroll software is very simple (theoretically) - put in the information and it works out everything for you and arrives at the net pay and how much to pay HMRC in relation to the deductions and employers NI etc. If only…..!!!
Time wasted with IT issues - is it getting worse?
When things work as they should, IT is a real boon. However, when it goes awry, so much time can be wasted trying to sort it.
Checklists - a ticking exercise or a useful reminder?
Whether it is accounts preparation, tax planning or compliance, payroll functions or, indeed, any other aspect of the busy professional office, how do you ensure all angles are covered?
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.