ICAEW.com works better with JavaScript enabled.

Data

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

In this section

Ensure that your trustee decisions are legal

This article provides a guide on how to navigate decision-making within charities. From understanding how the charity’s legal structure and governing document impact decision-making, to documenting decisions in compliance with charity regulation and law, this guide aims to equip you with the knowledge necessary to make informed and legally sound decisions.

Cyber security

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

Finding the missing link – Edit links enhanced

Links to cells in other workbooks are a frequent cause of confusion. It can be particularly difficult to track down some of the more elusive ways in which one spreadsheet can be linked to another. A Find Next command available as part of an enhancement to the previous Edit Links command might now be able to help.

IRR, XIRR & MIRR – What are they? When to use them?

IRR is commonly used to help make project investment decisions. In this article, Mark Proctor returns to explore the use of the IRR function in Excel and potential alternatives.

Simple but effective, part 2

In this series we are going to examine some of the capabilities of Excel Tables. In part 1 we considered different ways of turning a range of cells into an Excel Table and demonstrated the importance of Tables in helping to ensure that ranges in formulas adapt automatically to changes in the dimensions of the Table. This time, we will look in more detail at adding rows and columns to existing Tables and see how this can contribute to automating your spreadsheets.

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.