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 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.
Exclusive Adding calculated fields to the GROUPBY function
  • Article
  • 24 Apr 2025
In this article, Mark Proctor explores the concept of PivotTable calculated fields and reimagining them with Excel’s new GROUPBY function. Discover how to build dynamic, formula-based summaries that can go beyond what PivotTables can do.
Exclusive Excel, what’s occurrin’ 8 – Data Validation
  • Article
  • 23 Apr 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 conditional formatting to look at Data Validation.
Exclusive Excel Tips and Tricks #498 – Introducing TRIMRANGE
  • Article
  • 15 Apr 2025
A Creator level post introducing one of Excel’s newer functions – TRIMRANGE. TRIMRANGE is a new function in Excel that allows users to easily exclude leading or trailing blank rows or columns in a range.
Exclusive Bringing financial reports alive in Excel with visualisation – building the report
  • Article
  • 11 Apr 2025
This article is part of a series that supports the lunch and learn webinars on how to bring financial reports alive in Excel with visualisation. This fifth and final article will cover bringing together the visualisations to build a financial report.
Exclusive Aligning data in PowerQuery
  • Article
  • 11 Apr 2025
In this article, Ben Ducker explores how to use PowerQuery to align data and fields from several sources and time periods into one report.
Excel Community round up - March 2025
  • Article
  • 01 Apr 2025
Here are all the new Excel blogs and webinars from the Excel Community in March 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