Ever watched a cup draw on television? I’m sure you have. Arguably, the most famous one is football’s FA Cup. I’ve built the virtual equivalent in Excel. Of course, it cannot replicate the experience of picking balls out of a…
Analyze Data (formerly Ideas) enables you to understand and discover insights about your data using natural language queries. Select a cell in the data range you want analysed (preferably an Excel Table) and go to Home (tab) > Analyze Data…
Objects such as Form Controls, shapes and images can be grouped so they are treated as a single object. This is helpful for positioning and resizing them simultaneously. Holding Ctrl and selecting each one is one way, but if you…
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…
End of content
End of content
