ICAEW.com works better with JavaScript enabled.

Data

Resources covering data analytics and big data, data handling, data protection and GDPR, and data presentation.

Contents
Back to top
SMEs must wise up to cyber security risks
the 21st-century evolution of cyber security
Iain Murray, Director of Public Financial Management, CIPFA
Person sat at a table using a tablet computer.
Data Protection and Privacy

Data protection and privacy

All organisations that collect, store or process personal information on living and identifiable people must comply with the Data Protection Act 2018. Additional resources can be found on the GDPR (now the Data Protection Act 2018 in the UK).
Read more
Data Analytics Community

Data Analytics Community

As data analytics plays an increasingly pivotal role in supporting audit, assurance and business decision-making, this ICAEW community will help finance professionals develop the advanced data analytics and visualisation skills needed to succeed in this insight-driven era.
Join now
Insights

Leading data-led decision making in local government

Finance professionals are pivotal in ensuring local authority decisions on service delivery are grounded in robust data analysis. CIPFA’s Iain Murray outlines the role of finance teams in ensuring data-led decision-making and the skills required for success.
Read the article
Insights

In the nick of time: EU grants UK data protection adequacy decision

With the 30 June deadline approaching, the EU has agreed an adequacy decision for the UK, allowing the free flow of personal data from the EU to the UK to continue.
Read more

Data analytics

Get advanced data analysis, from number crunching and spreadsheets to decision-support and strategy, including access to useful and practical Excel guidance. Plus, find out how big data is used and can benefit the accountancy profession.


How to secure vital AI skills and an engaged workforce
  • Article
  • 21 Mar 2025
How should the UK nurture the skill sets that will underpin the AI-driven future of enterprise and accountancy? Members voiced their ideas for action in a round table.
CAW and Ipsos Research - AI and the future of the global chartered accountancy profession
  • Event
  • 12 Mar 2025
Data analytics for auditors: five essentials
  • Article
  • 07 Mar 2025
Data analytics is often overlooked in favour of flashier technologies, but it is a critical skill set for the modern auditor.
How to navigate software platform migration
  • Article
  • 25 Feb 2025
Whether driven by cost, functionality, security or compliance, software migration is a complex process that requires careful planning. ICAEW highlights key considerations for practices and businesses looking to migrate.
15 October 2025 virtual classroom Ransomware readiness
  • Event
  • 17 Feb 2025
Five in-demand skills for accountants in 2025
  • Article
  • 14 Feb 2025
We speak to recruitment experts to reveal the key skills and attributes accountants need to stand out in a competitive job market.
ICAEW Pakistan The impact of AI on the accountancy profession
  • Event
  • 11 Feb 2025
Expert QA capture maintain and handle quality data
  • Event
  • 31 Jan 2025
More

Data protection and privacy

Cyber round-up: March 2024
  • Article
  • 27 Mar 2024
This month we look at what can be learned from state-sponsored cyber attacks, how to avoid falling victim to increasingly sophisticated account takeover scams, and the ICO guidance on levels of fines for data breaches.
Accountability: building trust and ethics in the digital age
  • Article
  • 05 Mar 2024
New technologies are a force for good – they fuel innovation, improve efficiencies, enhance communication, and increase productivity – but they also raise new challenges that can be harmful. We’ve witnessed in recent years how technology has had undesirable consequences, with data breaches and online surveillance resulting in widespread concerns over privacy, security, and the spread of disinformation. This has eroded trust in businesses and institutions, while simultaneously knocking the confidence of businesses to fully embrace technological change.
More

Join the Excel Community

Do you use Excel in your organisation? Are you using it to its maximum potential? Develop your skills and minimise spreadsheet risk with our Excel resources. Membership is free to ICAEW members. Non-ICAEW members are also welcome to join. 

Find out more Already a member? login here
Excel polaroid

Excel community

The Excel Community provides a 'one-stop shop' for accountants who want to use Excel.
Exclusive Demystifying eta reduction in Excel
  • Article
  • 30 May 2025
In this article, Mark Proctor looks at the concept of eta reduced lambdas. They may have a complex sounding name, but you don’t have to be an advanced user to apply them.
Exclusive Calculating Dividends with MAX and MIN
  • Article
  • 30 May 2025
MAX (and MIN) may be familiar to many Excel users, but it is still probably worth performing a recap (I haven’t discussed these functions for nine years!). As a model auditor, I do see errors made regularly due to misunderstandings made with how these two similar functions actually work.
Exclusive Excel Tips and Tricks #500
  • Article
  • 21 May 2025
Welcome back to Excel Tips and Tricks! Over the last 10 years, we have covered a range of tips and tricks to help our community members make better use of Excel. In this special 500th tip, we cover how to master the learning process to get better at Excel.
Exclusive Excel, what’s occurrin’ 9 – The wrong trousers
  • Article
  • 16 May 2025
This series looks at some of the things that can go wrong in an Excel spreadsheet and at what we can do to avoid or resolve the issue. The first six parts dealt with issues that cause numbers to appear not to add up correctly. This time, we move on from Data Validation to lookup functions.
Exclusive Comparing SUMIF, SUMIFS and SUMPRODUCT
  • Article
  • 12 May 2025
Liam Bastick explains the use of three Excel functions commonly used for aggregating values based on conditions: SUMIF, SUMIFS and SUMPRODUCT.
Exclusive Is Canva Sheets the new green?
  • Article
  • 08 May 2025
The Canva Suite has become a force of nature with 1 billion designs being produced monthly, and now it finally launched Canva Sheets, but how does that compare to Excel or Google Sheets.
Exclusive Excel Tips and Tricks #499 – Excel’s new focus cell
  • Article
  • 01 May 2025
Welcome back to Excel Tips and Tricks! This time, we have a Basic User level post exploring the new focus cell functionality in Excel.
Excel Community round up - April 2025
  • Article
  • 01 May 2025
Here are all the new Excel blogs and webinars from the Excel Community in April 2025.
More

Complete the FDW eLearning course

ICAEW is collaborating with Deloitte to ensure its members and students have the knowledge and skills to take advantage of the opportunities offered by the fourth industrial revolution and to meet its challenges head on.
Start now
Finance in a digital world