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
In the nick of time: EU grants UK data protection adequacy decision
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

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.
AI skills gap is a ticking time bomb
  • Article
  • 13 Nov 2024
Estimates predict that with the adoption of AI technology, 40% of the workforce will need to re-skill in the next three years. So what’s the risk of losing your competitive edge if you fail to upskill your staff?
ICAEW launches Financial Due Diligence guideline
  • Article
  • 12 Nov 2024
Although the use of technology has revolutionised the financial due diligence process, it also brings with it certain important risks and issues that members and firms working in the deal space need to manage very carefully, best practice guideline warns.
Understanding AI: what is – and isn’t – artificial intelligence?
  • Article
  • 05 Nov 2024
An in-depth awareness of AI is no longer the preserve of data science professionals or technology enthusiasts. In the first of two articles, BDO’s Paul Ekwere explains what AI actually is – and what it isn’t.
Payment scams, data hacks and Cyber Security Awareness Month
  • Article
  • 31 Oct 2024
Cyber round-up: the continuing payment scams and personal data attacks on individuals, key takeaways from ICAEW’s Cyber Security Awareness Month campaign, and how to safeguard your data and business from harm.
AI use cases: eight ways AI can help
  • Article
  • 29 Oct 2024
AI can be used for a variety of tasks to assist accountants in business and practice. Here are eight ways in which AI can help increase productivity and efficiency in finance and accounting teams.
Leading data-led decision making in local government
  • Article
  • 25 Oct 2024
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.
Exclusive RICS' International Valuations Standards Agenda Consultation response: implications for accountancy professionals
  • Article
  • 23 Oct 2024
The International Valuation Standards Council (IVSC) plays a crucial role in establishing global standards for real estate valuation. The IVSC has published its 2024 Agenda Consultation, aiming to shape the future of the International Valuation Standards (IVS). This triennial consultation invites stakeholders to provide their input on key valuation topics that are crucial for the ongoing development of IVS.
Cyber: your personal accounts could be arming cyber criminals
  • Article
  • 18 Oct 2024
Cyber Security Awareness Month: Attendees at ICAEW’s annual cyber lecture learned about the government’s moves to tackle cybercrime, and how personal digital footprints can leave businesses vulnerable.

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 Bringing financial reports alive in Excel with visualisation
  • Article
  • 26 Nov 2024
This is the first article of a series that supports the lunch and learn webinars that will show you how to bring the financial reports alive in Excel with visualization. This article will explore the journey from raw data to actionable insights.
Exclusive Top 12 Excel Combinations: 2. SUMPRODUCT OFFSET
  • Article
  • 25 Nov 2024
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers SUMPRODUCT OFFSET.
Exclusive Taking the new GROUPBY() and PIVOTBY() functions further
  • Article
  • 20 Nov 2024
The main capabilities of the recently introduced GROUPBY() and PIVOTBY() functions have already been covered in recent articles. Here we are going to look at one aspect of their use in a bit more detail: the ability to use functions and formulas within the individual arguments of each function.
Free CPD: Excel essentials
  • Article
  • 13 Nov 2024
Are you using Excel to its full potential? From the basics of good spreadsheet practice to time-saving tips, brush up on your Excel knowledge while gaining Continuous Professional Development (CPD) hours.
Exclusive Ticks, crosses and noughts
  • Article
  • 05 Nov 2024
Experimenting with an Excel tip in a recent LinkedIn post leads to an exploration of the use of conditional formatting for adding ticks and crosses to Excel cells, and the discovery of a surprising comparison capability.
Exclusive Top 12 Excel Combinations: 3. IFERROR FORMULATEXT
  • Article
  • 31 Oct 2024
In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers IFERROR FORMULATEXT.
Masterclass 5: Moving from Excel to Power BI formulas
  • Article
  • 30 Oct 2024
Jenny Blewett FCA, Head of Finance at Costello Medical explains how she used generative AI to help her move data from Excel to Power BI to give senior management a very different view of debt risk.
AI use cases: eight ways AI can help
  • Article
  • 29 Oct 2024
AI can be used for a variety of tasks to assist accountants in business and practice. Here are eight ways in which AI can help increase productivity and efficiency in finance and accounting teams.

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