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…
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 Web App has bridged the gap on its desktop counterpart,…
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…
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…
For all the great things about Excel, one of the most confusing things is how it stores and displays data. Every cell has a number format, which can be selected from the dropdown in the Home ribbon tab. However, it…
Extracting unique values from a range in Excel has always been possible, but not always easy. Only since the implementation of the new calculation engine has it become a doddle — thanks to the UNIQUE function. Having said that, for many years…
End of content
End of content
