3D references provide a simplified way of aggregating data by referring to the same cell or range across multiple worksheets. Say you had monthly sales figures stored in separate worksheets and wanted to summarise them. You might be tempted to…
Press Shift + Ctrl + 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….
When a resource-intensive task is processing, such as a complex formula, macro or query, it can cause Excel to become unresponsive. This is particularly annoying if you have multiple workbooks open, as you are forced to wait because you cannot…
Excel’s FILTER function filters a set of data based on defined criteria. However, it doesn’t allow for partial matches that use wildcards. What are the wildcard characters? One workaround is to use FILTER in conjunction with ISNUMBER and SEARCH in…
In the late nineties when I was still at primary school, I remember us having a weekly spelling test. There were 10 words the teacher would say aloud, and we would have 30 seconds to write each of them down….
Do you wish you could write comments in formulas? Unfortunately, Excel doesn’t have an official way of including formula-based comments. I suspect this will change in the future, however, as we are writing increasingly more complex formulae. The workaround is…
End of content
End of content
