This shortcut has honestly made me twice as productive and it's as simple as can be. To quickly add a column of numbers, put your cursor in the cell where you want the answer to be and press ALT and + together.
It automatically puts in the SUM formula for the numbers above it. How quick and easy is that? No more long formula typing for me! What is your favorite Excel shortcut?