Excel spreadsheets do so much, from making lists to crunching numbers to acting as sophisticated flat-file databases. We’re creating this guide to make sure you master all the essentials and more.

Something wrong with some numbers in that spreadsheet? Here's a shortcut that displays all the formulas in the sheet at once: Ctrl + ` (the acute accent key, found next to the number 1 on your ...

You may be good at Excel, but you’re spending way too much time clicking around.

Structured references use table columns instead of cell coordinates, making formulas easier to read, update, and trust.

Few things frustrate us more than the inability to crack an Excel task independently. We love formulas and conditional cells, but the best way to utilize these features isn’t always easy. Tap or click ...