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…
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…
25 Outlook Calendar Tips and Tricks
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,…
The Best Way to Store Your Login Details
It’s amazing how many website login accounts you accumulate over time. I currently stand on 454, but I’m sure the true count is over 500. Inevitably there were sites I signed up to a decade ago when I wasn’t so…
Why You Should Stop Using Merge & Center in Excel
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….
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…
End of content
End of content