Bonus tip: With basic formulas, the AutoSum button is the top choice. It’s faster to click AutoSum>SUM (notice that Excel highlights the range for you) and press Enter.

It organizes all of Excel’s formulas into categories, such as Financial, Logical, Math & Trig, and so on, so they’re all within easy reach.

This download accompanies our Excel 2016 and 2019 cheat sheet. See that article for detailed information on how to get the most out of Excel 2016 and Excel 2019 for Windows. For the most part, the ...

Excel can serve as a powerful calculator, enabling you to perform basic math operations directly in a single cell. Hereâ s an example formula that includes addition, subtraction, multiplication ...