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

Ethics and new technologies

Ethics is particularly important for the accountancy profession, with a code for professional ethics based on five basic principles – integrity, objectivity, competence and due care, confidentiality and professional behaviour. However, the emergence of new technologies raises some new challenges for the profession to address.

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.

When text into numbers wont go

Recently someone sent me a small spreadsheet that included a column of formatted numbers. Unfortunately, the numbers weren't numeric values that had been formatted as numbers but had been entered (or more probably pasted from elsewhere) as formatted text, complete with commas and pound signs.

What you can do now to prepare for GDPR

The General Data Protection Regulation comes into force on 25 May 2018 after a two-year transition period, but practitioners can take action now while waiting for specific guidance, warns South East London Area Society chair Vicky Andrew.

Get ready for new EU data security rules

With the deadline for implementation of the EU’s General Data Protection Regulation (GDPR), come along to an ICAEW seminar to hear about the implications for members, their businesses and their clients.

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.

Finance in a digital world

Finance in a Digital World

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 content, including: eLearning, webinars and bite-sized summaries on individual technologies and the broader impact of digital technologies on finance.