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 #416 - PivotTable layouts
This week, we have Creator post in which we’re taking a look at some options for how to lay out your PivotTables.
Microsoft forms: analysis automation on surveys created in minutes
Whether its employee feedback, customer satisfaction, post meeting surveys, Forms are very handy.
Exploring Charts (Graphs) in Excel - 9: Colours, shadows and graphics (adding clarity not unnecessary use of options). Adding backgrounds.
With the plethora of chart options available it is all too easy to get ‘carried away’ and as mentioned in blog 5 there is a balance between medium and message. We also mentioned that in a pole of FDs that were asked to vote on their least favourite Excel feature, it was 3-D charts that topped the list. In the words of A.S.C. Ehrenberg “a Chart is a means of making results clear and memorable” and thus clarity is the primary objective
Chartech magazine
September/October 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
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
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.
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
Digitalisation: new service line opportunities
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?
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.
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
Unravelling seemingly “good ideas” in the IT
What seemed like a “good idea” at the time does not always turn out to be so and unravelling these can be time consuming.
How many information islands exist in your practice?
Is all data available to everyone….or is it secretive?
Accounting errors and anomalies
Over recent weeks, with the aid of review software, a significant number of problems have come to light.
Preparing accounts
My friend has prepared my accounts in the past ….he isn’t an accountant though……
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.