Excel-related articles.
Collaborating in an Excel workbook can be a disruptive experience. You’re working in the same worksheet as a colleague — they filter a table and suddenly it shrinks — interrupting the state you had it in and derailing your progress….
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…
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…
End of content
End of content
