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

Leap of faith

Small and medium-sized firms considering the potential of audit data analytics will learn a lot from Kreston UK members’ experiences, as Alex Peal and Lisa Leighton outline.

Excel - cumulative totals

There are many situations where you might want to calculate a cumulative total in an Excel spreadsheet, from a straightforward running total for a list of bank transactions to cumulative values for use with an Excel chart that is animated over time.

GDPR update

Whatever stage of GDPR-readiness your organisation has reached, ICAEW has resources that can help you to consolidate and go further, writes Lesley Meall.

Power BI Desktop - Part two

Simon Hurst continues his guide to data display with some tips on how to keep up to date with changes and enhancements to customise your content.

Power BI Desktop - Part one

Power BI Desktop offers new ways to visualise and present data. In part one of his guide, Simon Hurst uses Facebook posts to demonstrate some of its capabilities.

Excel emojis

Although it's generally a good idea to keep reports as simple and clear as possible, the sparing use of unusual graphics can sometimes add to impact.