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

Cyber security

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

Is there anything that Power Query can't do?

There are many things that Power Query can't do but, in this occasional series, we will be looking at some of the less obvious techniques available. In this episode we look at automating the changing of column heading text.

Avoiding another Find mess

A seemingly simple question during a lecture reveals the benefits of delving beneath the surface of Excel’s user interface in order to help find what you are looking for.

OFFSET

In recent months, I have covered VLOOKUP, LOOKUP, INDEX MATCH and XLOOKUP – yet there are still others that can help us look up or find data. I now move on to one of my favourites – OFFSET – which it’s true to acknowledge is not admired universally. This is a function modellers either love or hate. It considers disposition or displacement and has the following syntax:

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.