ICAEW.com works better with JavaScript enabled.


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

In this section

The Charities Act 2022 – what are the practical implications for you?

In February, the Charities Bill received Royal Assent and passed into law as the Charities Act 2022. The recommendations from the Law Commission formed the basis for the provisions of the new legislation and the Act is designed to give trustees more flexibility to manage charities effectively. They will not have a big impact on charities’ daily operations but simplify certain areas of regulation.

Good Governance – why independent trustees are essential for the boards of Charitable Professional Membership Societies

While most charity boards are aiming to incorporate more service user perspectives in their governance structures, many charitable membership societies are relying on member perspectives alone. In this opinion piece, Baden-Fuller, Lawrey and Palmer explain why having independent trustees is a key element of good governance and adds depth to the skillset of the boards governing charitable professional membership societies.

Cyber security

This resource centre provides a focal point for ICAEW members looking for support in managing cyber risks.

Multiple Excel Tables in a single worksheet – avoiding Cell Clash

I have been working on a project recently for which I wanted to include a set of refreshable Excel Tables in a control worksheet to highlight exceptions in the underlying data. Generally, the best way to avoid Tables clashing with each other as they expand and contract is to keep them on their own, separate, worksheets. In this case, I wanted to create a single workbook that would highlight potential errors at a glance, and the Tables concerned were only likely to generate a few rows each. The following examples demonstrate some of the considerations involved.

Excel Tip of the Week #437 - Revisiting dynamic arrays

Hello all and welcome back to the Excel Tip of the Week! This week we have a Creator level post in which we’re taking a timely second look at the biggest change to Excel formulas in recent years, the nifty dynamic array formulas.

Finance in a digital world

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. Log-in to access exclusive eLearning content.