The Essential Guide to GDPR
Getting to grips with the General Data Protection Regulation
Data
Resources covering data analytics and big data, data handling, data protection and GDPR, and data presentation.
Featured items
In this section
Data analytics and big data
Shaping the public’s trust in data and information
Ed Humpherson holds the UK government to account for the data that it publishes. He argues that chartered accountants have a key role to play.
Community project – rescuing the lost archive – part 4
In October 2020, the web platform used for Tech News and the Excel Community was changed. Although there are many clear advantages of the new platform, one downside is the splitting of the content for both communities between current articles and the very extensive archive of articles built up over many years. The faculty team have sought to alleviate the problems by providing a tabular index to over 2,000 archive articles.
When data meets society: managing data ethically
Writing for the Institute and Faculty of Actuaries, ICAEW’s Head of Financial Services Philippa Kelly explores how the COVID-19 pandemic and Black Lives Matter movement have brought issues with our relationships to financial services and data into sharp relief.
Exploring charts (graphs) in Excel - Part 6: enhancing bar charts – creating funnel and tornado charts
In Blog 5 we explored how to create Column and Bar charts, in this Blog we will continue using these to create Funnel and Tornado charts. From 2016 onwards there is a Funnel chart option within Excel, but this only displays one set of data with bars that are of equal length either side of the centre (equivalent to centring the bars on a chart rather than left justifying them). For two sets of data with differing sized bars either side of the centre we must use the traditional method of a stacked bar chart.
Data protection and privacy
Draft decision deems UK data laws ‘adequate’
24 February 2021: The UK government has welcomed the European Commission’s recent draft data adequacy decision, which paves the way for the continued free flow of data from the EU and the UK.
Data Protection now the UK has left the EU: February 2021 Update
The EU Commission has issued a draft decision that the UK will be granted a full adequacy decision which will enable data flows from the EU/EEA to continue as they did when the UK was in the EU. However the European Data Protection Board still has to formalise this and will not do this before it has consulted with member states.
Data protection now the UK has left the EU: January 2021 update
Following the UK’s departure from the European Union, ICAEW Insights has the latest on how this affects GDPR and the sensitive issue of data protection.
Data protection and Brexit - October 2020 update
October 2020 update on data protection and Brexit – what you need to know and how to prepare your business.
Excel update – Power Query can now use Dynamic Arrays as a data source
Up to a week or so ago, the Data Ribbon tab, Get & Transform Data group included a From Table/Range command that would create a new Power Query query from an Excel Table, a named Range or from a selected block of cells that would be turned into an Excel Table as part of the process. In the Insider, Beta Channel edition of Office 365, this option has now been renamed as From Sheet. This change in name is a result of the expansion of the available data sources within an Excel worksheet to include Dynamic Arrays.
Excel Community round up - April 2021
Here are all the new Excel articles and webinars from the Excel Community in April 2021. Posts marked as public can be accessed by anyone; other articles are accessible to Excel Community & Tech Faculty subscribers and can be accessed by logging in to your ICAEW account.
Excel Tip of the Week #392 - Text to Columns redux
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 definitive revisit to the handy data transformation tool, Text to Columns. This was last covered back in TOTW #105
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.