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.
Simon Hurst
ICAEW
Article
30 May 2023
This week, we have a Creator level post in which we're dipping our toes back into the pool of customisation options available through Excel.
Jonelle Johnson Turner
ICAEW
Article
30 May 2023
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.
Simon Hurst
ICAEW
Article
26 May 2023
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:
Liam Bastick
ICAEW
Article
26 May 2023