We can insert Sparklines to the right of the data under the SPARKLINES option.īased on the selection we make, it will display the Sparkline to the left of the data. If you click on Pivot Table, it will insert the pivot table in a new sheet. The table will convert the range of data to table format data. Click on TABLES and choose the option you want to use. We can also insert the table format and pivot table to the data under Tables. Mention the value as 140 and choose the formatting color. If you want to highlight all the values greater than 140, click on the Greater option you will see below the window. Similarly, we can make use of “Color Set, Icon Set, Greater Than, Top Value and more importantly, we can clear the formatting with the “Clear” option.Ĭlick on the Color set to insert different colors.Ĭlick on Icon Set to get icons for your numbers. I have placed a cursor on “Data Bars” it has inserted data bars according to the size of the numbers. Just place a cursor on the required formatting option we can see the immediate impact in our data.

We have “Formatting, Charts, Totals, Tables, and Sparkline’s”. Click on this icon to explore all the possible options. Once you select the data, we can see the Quick Analysis tool icon at the bottom of the selection.

We will show what the various kinds of analysis tools it has are. Unfortunately, not many of excel users make use of this wonderful tool. I know you have seen this icon before, but you have not worried about this.

Once we select the data, we can see a small icon to the bottom right of the selection. This tool appears when we select the data range in excel.

Now all important question where is this tool. You can download this Excel Quick Analysis Template here – Excel Quick Analysis Template Where is Quick Analysis Tools in Excel? TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).Excel Conditional Formatting in Pivot Table.

Quick analysis button quizlet