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.


The looming AI skills gap
  • 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 and concerns 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 Excel Tips and Tricks #497 –BYROW and BYCOL
  • Article
  • 28 Mar 2025
Welcome back to Excel Tips and Tricks! This time, we have a Creator level post exploring BYROW and BYCOL, functions that can help troubleshoot common issues when using Dynamic Arrays.
Exclusive Ranges vs. Arrays – What's the difference, and why you should care?
  • Article
  • 27 Mar 2025
In this article, we look at the differences between ranges and arrays. Compared to ranges, we will see that arrays give us total flexibility for making many Excel calculations easy to perform.
Exclusive Calculated fields and calculated items
  • Article
  • 24 Mar 2025
Liam Bastick looks at how calculated fields and calculated items can be used to solve problems in Excel, rather than resorting to more complicated functions.
New tech features for Dec 2024-Feb 2025: Excel, Teams, Power BI, Canva, Zoom, Google Sheets++
  • Article
  • 14 Mar 2025
Our digest of new features across Microsoft 365 & other business tech products in written, images & video format covering December 2024 to February 2025.
Exclusive Excel, what’s occurrin’ 5 – getting iffy with it
  • Article
  • 12 Mar 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. This time we are going to explore the use of the IF() function.
Your Questions Answered #13 - Mastering Copilot in Excel
  • Article
  • 10 Mar 2025
In a recent webinar, David Fortin, Microsoft MVP and founder of Piggy Bank Accountant, explored how to get started with Microsoft’s Copilot and the basics of Copilot’s functionality in Excel. In this article, David returns to answer your most asked questions.
Exclusive Using range functions in Excel
  • Article
  • 04 Mar 2025
In this article, Mark Proctor, explores a group of functions which can dynamically manipulate ranges in Excel for flexible calculations.
Excel Community round up - February 2025
  • Article
  • 03 Mar 2025
Here are all the new Excel blogs and webinars from the Excel Community in February 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