Resources covering data analytics and big data, data handling, data protection and GDPR, and data presentation.
As CEO of big data and analytics business mnAI, John Cushing has plenty of experience in building a successful tech venture, as he explains to Mark Mullen
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.
In this article we talk about Excel file types and explore the inner workings of an XLSX file.
For this final blog in the series, we sweep up a few of the more unknown charting features that can add significant value to the display of data.
With the 30 June deadline approaching, the EU has agreed an adequacy decision for the UK, allowing the free flow of personal data from the EU to the UK to continue.
Data protection and privacy are matters of professional concern to accountants in practice, industry or commerce.
This resource centre provides a focal point for ICAEW members looking for support in managing cyber risks.
ICAEW Data Analytics Certificate programme will help you combine your commercial acumen and business knowledge with data analytics expertise.
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.
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’.
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.
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.
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.