Andrew Moss
Excel Aficionado
Big data is a term used since the early 1990s to describe “huge, overwhelming, and uncontrollable amounts of information”. The rapid rise of the internet has meant the volume of…
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…
Staring at a worksheet with a plethora of errors is not sightly, but it can be your saving grace for diagnosing formula problems. Over a dozen error types exist, and…
Spreadsheet Day was celebrated this month—an occasion to mark 42 years of the tool that has enhanced the business world and our personal lives so dearly. Their use has spanned…
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…
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…
The standard way of storing data in Excel is to have one cell for one value. However, a value might be composed of multiple parts — making it harder to work with.…
Outlook Calendar is great for keeping track of forthcoming events. Using it effectively can lead to greater organisation and productivity in your everyday life. In recent years, the Outlook Calendar…
It’s amazing how many website login accounts you accumulate over time. I currently stand on 454, but I’m sure the true count is over 500. Inevitably there were sites I…
I wish there was a formatting option in Excel and Google Sheets to hide trailing zeros in decimal values. For example, a dynamic chart that displays whole and decimal numbers…
There’s bound to have been a time when you’ve entered text into a cell, only to find it doesn’t all fit. Widening the cell column would make sense, however, you…
Excel’s Goal Seek is a What-If Analysis feature that allows backsolving calculations. It’s useful in situations where you have a known output value but want to find the input that…