Getting to grips with the General Data Protection Regulation
This guide is designed to help alleviate some of the fears that lie behind the inertia on data analytics. There is information about how to get started using the resources you already have or to find out about others, and case studies to show how using data analytics has helped some practices already.
As data analytics plays an increasingly pivotal role in supporting audit, assurance and business decision-making, this ICAEW community will help finance professionals develop the advanced data analytics and visualisation skills needed to succeed in this insight-driven era.
Data analytics and big data
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.
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.
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.
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
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.
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.
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.
October 2020 update on data protection and Brexit – what you need to know and how to prepare your business.
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.
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.
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.