Home > Articles > Home & Office Computing > Microsoft Applications

This chapter is from the book

This chapter is from the book

Calculating Totals with Quick Analysis

When you select a range of cells, you can use the Quick Analysis tool (New!) to calculate totals for the data. The tool allows you to calculate totals for Sum, Average, Count, % Total, and Running Total. The result of the totals can appear below the selected range or to the right of the selected range. You can point to a button option to display a live preview of the results before you commit to it. In addition to calculating totals, you can also use the Quick Analysis tool (New!) to format data and create charts and tables.

Calculate Totals with Quick Analysis Below Selection

  • yellow-01.jpg Select the range of cells you want to total.

    A Quick Analysis button appears in the lower right corner of the selection.

  • yellow-02.jpg Click the Quick Analysis button.

    A menu appears, displaying heading tabs along the top, and buttons below it.

  • yellow-03.jpg Click Totals.
  • yellow-04.jpg To preview the totals result, point to the button (select an icon with blue row) with the type of total calculation you want.
    • Scroll Arrows. Click a left or right scroll arrow to display buttons.
  • yellow-05.jpg To set the totals results result, click the button (select an icon with blue row) with the type of total calculation you want.

Calculate Totals with Quick Analysis Next to Selection

  • yellow-01.jpg Select the range of cells you want to total; make sure the column to the right is available to place the results.

    A Quick Analysis button appears in the lower right corner of the selection.

  • yellow-02.jpg Click the Quick Analysis button.

    A menu appears, displaying heading tabs along the top, and buttons below it.

  • yellow-03.jpg Click Totals.
  • yellow-04.jpg To preview the totals result, point to the button (select an icon with gold column) with the type of total calculation you want.
    • Scroll Arrows. Click a left or right scroll arrow to display buttons.
  • yellow-05.jpg To set the totals results result, click the button (select an icon with gold column) with the type of total calculation you want.
  • + Share This
  • 🔖 Save To Your Account