The tilde isn't the only sign you need to understand to truly get your head around Excel's inner workings. For example, the ...

The Alt+Enter shortcut isn't limited to new formulas you write—you can go back and clean up any messy formulas at any time.

Julia Kagan is a financial/consumer journalist and former senior editor, personal finance, of Investopedia. Erika Rasure is globally-recognized as a leading consumer economics subject matter expert, ...