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

Audit technology upskilling

Can you make the most of data without specialist data analytics tools? Do all auditors need coding skills? This article considers some possible answers – and what is behind them.

Cyber security

This resource centre provides a focal point for ICAEW members looking for support in managing cyber risks.

Archive portal – quickly see recent Excel Community posts

If you’ve come across a problem with your spreadsheet or just want to investigate a particular feature in some detail, then the answer could be the Excel Community article archive. Here we look at recent developments in the archive portal.

How to review a spreadsheet

This series of six blogs will explore the Excel Community 2021 publication ‘How to Review a Spreadsheet – Reduce the risk that your spreadsheet gives you the wrong answer’.

Working with Power Query – solving even more business problems

A great deal can be achieved in Power Query just by using the editor interface and allowing Power Query to create each formula line for us. However, understanding how to make simple edits in the formula bar can extend what Power Query is capable of. We will use the example of entering a value in a cell in an Excel worksheet to filter a transaction table by date. The example also shows how to make a value from a single worksheet cell available in the editor.

Excel Tips and Tricks #443 - Next level FILTERing (The FILTER Function)

Hello all and welcome back to Excel Tips and Tricks! For today’s Creator post we’re looking at the FILTER function, which remains a relatively recent and underutilised addition to Excel. Given it opens up more sophisticated filter options than the standard drop-down filters, it’s time to change that.

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.