Home > Sample chapters > Microsoft Office > Excel

Analyzing Your Excel 2013 Data

Performing common calculations

Excel 2013 knows that you’ll use some calculations more than others, and for this reason, on the Home tab you have a tool within reach to help you perform some common calculations. Specifically, the Sum tool in the Editing group gives you access to functions you might use often: Sum, Average, Count Numbers, Max, and Min. You can also display additional functions by choosing More Functions in the Sum tool list and use the Subtotal tool on the Data tab to subtotal values on your worksheet.

Do a basic calculation

  1. Click the cell in which you want to create the formula.

  2. Type the equation you want Excel to perform, starting with the equal sign (=).

  3. Press the Enter key.

    Excel carries out the math and displays the answer in the cell.

    httpatomoreillycomsourcemspimages1532025.jpg

Use the Sum tool for common calculations

  1. Click the cell below the column that you want to summarize.

  2. Click the Home tab.

  3. Click the down arrow adjacent to the Sum button.

    The Sum tool list offers the Sum, Average, Count Numbers, Max, and Min functions. You can also open the Insert Function dialog box by choosing More Functions.

  4. Click the function that you want to use.

  5. Press the Enter key or tap outside the cell to accept the suggested formula.