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…
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 may not want to if it interferes with something else….
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…
The TEXTJOIN function offers a convenient way of concatenating values whilst separating them according to a specific delimiter.
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 + ;…
Still got that old copy of Excel installed? Uninstall it, bin it (if it’s a CD-ROM), and get with the times. STOP being an Excel dinosaur! You’re Missing Out on the Updates You may not be aware, but unless you have…
End of content
End of content
