Excel Community
£68 for ICAEW members £81.60 for non-members
Technology
Keep up-to-date with tech issues and developments, including artificial intelligence (AI), blockchain, big data, and cyber security.
Featured items
In this section
Opinion and news analysis
Staying visible when working from home
With hybrid working now a reality for millions of UK employees, how can you be sure that even if you’re far from sight, you’re not far from mind when it comes to career opportunities?
Hybrid working and employee monitoring: what to be aware of
Kirstin Gillon explores how to balance productivity and privacy with employee monitoring in the new hybrid workplace.
Hybrid working: making the tech work for teams
The pandemic has ushered in a new model of working, with many businesses considering adopting more flexibility in the longer term. That’s certainly the case for the Oil and Gas Authority, which is set to adopt a hybrid working method for its post-pandemic way of working.
What will the workplace of the future look like?
ICAEW Insights explores where the chartered accountant of the future might work, with recent trends including local co-working spaces and building communal office space into new housing developments.
Why finance teams need to upskill now
COVID-19 has accelerated digital adoption across all business sectors. The finance function needs to embrace tech and develop new skills to keep up.
Artificial intelligence
The technological revolution
Don’t forgot the human in the breakneck pace of change
Effective cyber crime insurance
Ransomware attacks on businesses and other cyber crimes are an ever-increasing threat across all industries, but is current cyber crime insurance worth it?
Helping people to trust data and information
Trust in information is declining. From data management and analysis, artificial intelligence and machine learning, to data storytelling and the influence of stakeholders.
Robotic process automation
Automation can help process increasing volumes of data, give an opportunity for upskilling to data science, computer programming and project management, and allow accountants to spend more time with clients.
Blockchain
The essential guide to blockchain
This guide from the ICAEW sets out the key features of blockchain, and the challenges it must face to reach widespread adoption. It includes case studies of real-life applications, as well as examining its impact on accountancy.
What is blockchain?
Blockchain technologies have the potential to disrupt the work of finance teams – particularly those focused on transactional tasks – by offering a system of universal entry bookkeeping, removing the need for independent verification. Here ICAEW’s Tech Faculty and Deloitte outline the basics of this complex and developing technology.
Cloud computing
Is Excel still fit for purpose?
And if not, what are the alternatives?
Building a data strategy
Kirstin Gillon summarises the key points from the Tech Faculty’s recent webinar on creating a data solution that works for your business.
Where does bookkeeping stop and accounting start?
A major change with cloud accounting is always on access to the data.
My system is down - what do I do now?
In the last couple of weeks, a significant number of accountants, their clients and businesses will have been affected by “major outages” with cloud accounting software.
Cryptocurrency
Cryptoassets and auditing
While cryptoassets are growing in popularity, there is a lack of specific guidance on dealing with the issues around them, including over-reliance on blockchains, ownership of cryptowallets and even criminal dealing.
Bitcoin the financial reporting challenge for investors
Why the accounting for cryptocurriencies isn't helping investors and is it time for standard-setters to act?
Tax year end, Bounce Back Loans and cryptocurrency
ICAEW’s Philippa Kelly and Lindsey Wicks and PwC’s Mike Jervis join host Tom Herbert to discuss the potential moving of tax year end, Bounce Back Loan repayment options, business restructuring and cryptocurrency.
Cyber security
Cyber crime: creating a 'no blame' culture
Your response to a breach matters – here’s how to ensure your conversations and investigations are productive.
Why you need cyber insurance (and how to pick a policy)
Cyber insurance is often overlooked by organisations but in the event of an attack or breach, it can give you the resources to rebuild.
Charity Fraud Awareness Week 2021
Charity Fraud Awareness Week is an annual event to raise awareness of fraud and cybercrime affecting the sector and to create a safe space for charities and their supporters to talk about fraud and share good practice.
A New audit Methodology for the Digital Era
Inflo’s Digital Audit methodology transforms the audit process. It takes a truly data-driven approach, while harnessing the power of digital workflow to achieve a more efficient and higher quality audit – yielding a vastly improved staff and client experience.
A New audit Methodology for the Digital Era: Audit Data Analytics
Inflo’s Digital Audit methodology transforms the audit process. It takes a truly data-driven approach, while harnessing the power of digital workflow to achieve a more efficient and higher quality audit – yielding a vastly improved staff and client experience.
Cybercrime: how to rebuild after suffering a breach
A cyber attack can be enormously costly for an organisation. Here’s how to respond and recover quickly.
Accounting errors and anomalies
Over recent weeks, with the aid of review software, a significant number of problems have come to light.
Excel Tip of the Week #417 - Custom data types
Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re going to look at expanding data types with our own custom ones. For a refresher on normal data types and how they work, check out TOTW #384.
How to review a spreadsheet
ICAEW’s Excel Community has launched a new guide setting out common sources of spreadsheet error, how to review them with confidence, and steps you can take to give the next user a helping hand.
Is Excel still fit for purpose?
And if not, what are the alternatives?
Finance in a Digital World
Digital transformation
ICAEW has brought together these resources to help you understand how digital technologies are transforming economies and workplaces. Learn what it means for businesses and accountancy practices.
AI for finance professionals
ICAEW has brought together these resources to help you understand artificial intelligence and what it means for finance functions. Here you'll find support on identifying how AI can benefit your organisation and how it to start implementing the technology.
RPA for finance professionals
ICAEW has brought together these resources to help you understand Robotic Process Automation (RPA), what it means for your organisation and how it to start implementing the technology.
The future of accountancy work
Digital technologies are set to have a revolutionary impact on the work of accountants, both in business and in practice. ICAEW has gathered together these resources to ensure its members understand how finance functions will change, the skills that will be needed and the role you will play.
IT management
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.
Building a data strategy
Kirstin Gillon summarises the key points from the Tech Faculty’s recent webinar on creating a data solution that works for your business.
Adapting technology and security for homeworking
Lesley Meall examines the questions that remain about the technology required to support post-pandemic hybrid working – and whether accountants can adapt to the changes.
Digital transformation will power your business
Key steps to successful cost-effective investment
Software
How many information islands exist in your practice?
Is all data available to everyone….or is it secretive?
Is Excel still fit for purpose?
And if not, what are the alternatives?
Microsoft forms: analysis automation on surveys created in minutes
Whether its employee feedback, customer satisfaction, post meeting surveys, Forms are very handy.
Technology and the profession
Automation in finance functions: lessons from India and the UK
Drawing on real-life experiences, this collaborative thought leadership report by ICAEW and the Institute of Chartered Accountants of India (ICAI) considers how finance functions can harness automation to deliver greater value to business and the skills needed by accountants in the future.
Ethics and technology - latest thinking from IESBA
As accountants increasingly innovate with data, AI and other technologies, is the profession’s ethics code fit for purpose in this new world?
Digital transformation of businesses during the Covid-19 crisis
Many businesses have had to adapt quickly in the last three months to deal with the impact of Covid-19 and lockdown, by making sure they are able to run their businesses remotely and mainly digitally by using and implementing the right kind of software.
Risks and assurance of emerging technologies
Cognitive and automation technologies such as artificial intelligence (AI) have drawn a great deal of interest, but also concern about the potential for bias and misuse. ICAEW’s Tech Faculty examines the risks associated with the adoption of emerging technology and how these risks can be tackled through internal controls and assurance.