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

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.

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

Finance in a digital world

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.