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…
Annoying Excel Problems: Trailing Zeros
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 should adapt so each figure is outputted appropriately. If I…
How to Use Goal Seek in Excel
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 dictates it. In the ribbon, it is found in Data…
