Excel Cell Errors Explained
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 chances are you will have seen most of them at…
Celebrating the Unsung Hero: The Spreadsheet
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 across many industries and professions, including financial, scientific, medical, and…
Custom Formatting
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….
Strikethrough Text
It’s well-known that the Excel, Word and PowerPoint ribbons vary because each program has a different use case. In Excel for desktop, however, one glaring omission is a Strikethrough button in the Home tab. Interestingly, Excel for the web does…
Add Comments to Formulas Using the N Function
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…
How to Calculate Multiple Values in the Same Cell
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. You might also copy content from a webpage, only to…
