In Excel, it’s common practice to store percentage values as numbers under the General number format; for example, 12, 6, and 16. By only including the percent symbol (%) in a column’s header, you can avoid repetition and extra clutter….
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…
Flash Fill is an Excel feature that intelligently spots patterns in your data to fill a range of cells. It can be used for things like: The process is: As an alternative to step 2, type a second entry for…
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
