The tilde isn't the only sign you need to understand to truly get your head around Excel's inner workings. For example, the at (@) sign returns a single row value instead of spilling an array, the ...

Don't listen to anyone who tells you that the VALUE function in Microsoft Excel is obsolete. You'll probably seldom need to use it on its own, but when combined with other functions, it's still as ...