1. The SUM function is probably the most basic function you need in Excel. You type in =SUM( and then select an array of values. This will result in the sum of the values in the array you've selected.