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 ...

Have you ever stared at an Excel spreadsheet, overwhelmed by its complexity, and thought, “There must be a better way to do this”? You’re not alone. Despite being one of the most widely used tools for ...