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….
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…
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 the TEXTJOIN Function in Excel
The TEXTJOIN function offers a convenient way of concatenating values whilst separating them according to a specific delimiter.
Datestamps and Timestamps
Perhaps you are carrying out an audit or keeping track of a project in Excel. Datestamps and timestamps are bound to come in handy. Instead of manually entering the current date and/or time, use the following: • Ctrl + ;…
End of content
End of content