Enjoyed your extra hour in bed today? 🛌 😴 That’s right. Across Europe, the clocks went back 60 minutes at 01:00 UTC (Coordinated Universal Time). In the UK, it was a second after 01:59:59 BST (British Summer Time). Another five…
Excel allows you to easily sum a column of numerical values via the ‘Total Row’ option in the Table Design tab. This generates a SUBTOTAL formula with numerous options including SUM (ignores hidden and unfiltered values) and COUNTA (counts non-empty cells). Awareness of these functions’ behaviour is crucial, as they handle hidden rows differently.
It’s probably not something you give much thought about, but awareness of the different Excel file types is important, so you can avoid limitations and data loss. Before Excel 2007, the default file format was XLS (.xls); this was then…
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….
End of content
End of content
