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

Tax: the bigger digital picture

As the UK implementation of Making Tax Digital comes closer, David Lyford-Smith reports on how other countries are handling digitalisation of the tax system, including Australia, Brazil, China, Estonia, Italy, USA and more

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.

The ICAEW Tax Faculty Conference 2018 – part two

The 2018 ICAEW Tax Faculty Conference was chaired by Mary Monfries and Frank Haskew. This article includes commentary from Nigel Holmes (Catax) on R&D tax relief and patent box; John Cassidy (Crowe Clark Whitehill) on HMRC enquiries; and practical points from the Tax Faculty team.

Ensuring cyber resilience

As cyber security risks continue to expand and evolve at an increasing pace, so cyber resilience becomes critical to an organisation’s ability to operate. George Quigley covers the best approach in four steps: business assessment, governance and oversight, risk management framework and incident response and recovery.

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.