Microsoft Excel formulas can be used to take the sum or average of a set of data by typing an equal sign into a cell, clicking on "Sum" or "Average," typing an open parenthesis, highlighting the data, and closing the parenthesis. Find out how to use different Microsoft Excel formulas with help from a computer programmer in this free video on Microsoft Excel.