Select Descriptive Statistics and click OK. Sparklines are added to the adjacent cells.Go to the Data tab > Analysis group > Data analysis.

Then choose one of three options (in this example, Line).

Sparklines are great for representing trends within a cell, and you can easily add them by using the Quick Analysis tool. Now, your data is formatted as a table and has all the functionality of an Excel table.

In the menu (1) click on Tables and (2) choose one from the list (in this example, Table).

To do that (1) select the data range and (2) press the Quick Analysis button. Using the Quick Analysis tool, you can make tables to sort and filter data.

In this example, the Sum option totals the numbers in each column. Choose the appropriate options for your data range.Then click on the Quick Analysis button.You can use the Quick Analysis tool to quickly calculate totals. This opens the Insert Chart window and in it, you can find the list of all charts. If the charts from the list don’t fit your needs, you can find more options by clicking on the More button.Choose the chart that best represents your data (in this example, Cluster chart).Īfter clicking on it, the chart is added to your sheet.With the Quick Analysis tool, you can also make charts. When you decide on a particular option, click on it. You can hover over each option to see how it will affect your data. It’s easy to try out a few options if you’re not sure what fits. In this example, the best solution was Color Scales.

Then choose the best visual option for the given data set.

In the menu that appears, click on Formatting.

Click on the Quick Analysis tool button.

To quickly do that with the Quick Analysis Tool, just follow these steps: You can easily visualize values in the range of cells by using color scales, data bars, icon sets, and others. There are five main categories: Formatting, Charts, Totals, Tables, and Sparklines. These options are available through the Ribbon, but Quick Analysis lets you see them all in one place, and you can preview each transformation by hovering over it. The Quick Analysis tool in Excel gives you options to help understand your data, right from a range selection. This tutorial will demonstrate how to use the Quick Analysis tool in Excel.

Quick analysis button on excel