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

Your Questions Answered #11 – Tips and Tricks Live extended

In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.

Simple but effective, part 7

In this series we are going to examine some of the capabilities of Excel Tables. We will be concentrating on the practical use of Tables to improve spreadsheet productivity.

Top 12 Excel Combinations: 6. MAP LAMBDA

In the latest instalment of his series counting down the "Top 12" of Excel function combinations, Liam Bastick considers MAP LAMBDA.

Your Questions Answered #11 – Tips and Tricks Live extended

In last month’s ‘Excel Tips and Tricks live – your questions answered’ webinar, David Benaim and Ian Pay tackled Excel questions and queries covering best practices when using Power Query, the use of formulas such as XLOOKUP, and a range of techniques for data handling and analysis in Excel. In this article, David returns to answer some of the unanswered questions from the webinar.

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.