Use the Quick Analysis tool to calculate Totals

As an all-around partner, Microsoft Excel’s Quick Analysis tool has helped simplify the process of interpreting and presenting complex datasets with ease. We will observe two examples that will vividly demonstrate the mightiness of this tool. Picture steering through a maze of sales data with products changing monthly or moving across a financial landscape that shows expenses fluctuating across different categories.

The “Quick Analysis” tool in Excel is used to quickly analyze and visualize data in a selected range of cells. Here’s a step-by-step example:
Let’s say you have a table of sales data like this:


Now, you want to calculate the totals for each month using the “Quick Analysis” tool:
Select the range of cells you want to analyze (in this case, the sales data).

After selecting the cells, you will see a small icon at the bottom-right corner of the selected range. It looks like a small square with a lightning bolt. Click on it.


A menu will appear with various options for quick analysis. Choose “Totals” from the menu and click the Sum option.

Quick Analysis Tool

Excel will automatically add total values at the bottom of each column. In this example, it would sum up the values for January, February, and March for each product.


Remember, the steps might vary slightly depending on the version of Excel you’re using, but the general process should be similar.

Average in Excel With Quick Analysis Tool

Certainly! Let’s continue our exploration of the Quick Analysis tool in Microsoft Excel by delving into the “Average” option within the “Total” tab. Consider a scenario where you’re managing the performance scores of employees across different projects over several months:


Now, you want to analyze the average performance score for each employee over the months. Here’s how you can use the “Quick Analysis” tool:

Select the Data:

Highlight the entire range of your data, including the headers. In this case, select the cells from A1 to F4.


Open the Quick Analysis Tool:

Click on the small icon at the bottom-right corner of the selected range.

Choose “Totals” and then “Average”:

In the Quick Analysis menu, select “Totals,” and then choose “Average.” This will automatically add average values at the bottom of each column (for months) and at the right of each row (for employees).


Review and Confirm:

Review the changes made by the tool. If satisfied, confirm the changes.

Now, your spreadsheet will display the average performance scores for each employee at the right of their respective rows and the average scores for each month at the bottom of the respective columns. This quick and efficient analysis provides a clear snapshot of employee performance trends over the specified period.

Explore Other Options:

Beyond averages, you can explore additional options in the Quick Analysis tool, such as charts, formatting, and more, to enhance the visual representation of your data.