Press Ctrl + Shift + A after a function to display all its arguments. Then put a leading single quote to signify text. I often find this useful if I need to retrieve the arguments of a function I’m explaining….
Whilst most of the world has adopted the metric measurement system, three countries officially prefer imperial units: USA, Liberia, and Myanmar. The UK, however, is caught between the two — and an imperial ‘hangover’ still exists in other Commonwealth nations…
Filtering and sorting a dataset allows you to analyse it more effectively by hiding the surplus and putting column data in ascending or descending order. An Excel Table provides the tools to do this; however, clearing the filter and sort…
Extracting and splitting text is about to get a lot easier. Whilst Excel has functions like LEFT, MID, RIGHT, LEN, and SEARCH, unless you have a simple scenario, you’ll probably have to construct an unwieldy formula. Alternatively, you might use…
Combining tables has been notoriously difficult in Excel. In November 2020, I wrote an article called ‘Combining Multiple Excel Tables into One’, which demonstrated several methods that were clunky, cumbersome, and inflexible. There was no alternative. Thankfully, 17 months on…
Excel Tables has a Banded Rows option that highlights rows in alternating colours. This enhances readability by making it easier to differentiate between them. What if you wanted to highlight blocks of rows though? A conditional formatting rule combining the…
End of content
End of content
