Here we discuss the top 5 tips to use quick analysis tools in excel with examples and downloadable excel template. This has been a guide to Quick Analysis Tools in Excel. Use the Quick Analysis Button Select the cell range you want to summarize. Like this making use of the “Quick Analysis” tool in excel, we can make a quick analysis of our data without breaking any sweat. I have selected Column sparkling, as shown below. They are tiny visual representations of the data's trend, whether it is increasing or decreasing read more 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. We can insert Sparklines Insert Sparklines Sparklines in Excel are similar to a chart within a cell. Tip #5 – Quickly Analysis through Sparklines However, if you want to insert a new worksheet into the workbook, the shortcut key is Shift + F11. If you click on Blank, it will insert a pivot table in the new sheet in excel The New Sheet In Excel When we open a new workbook, there are three worksheets available by default. We can insert SUM, AVERAGE, COUNT, % Total, Running Total, SUM to the Right, Average to the Right, count to the right, running total to the right. Under this, we have a various variety of formulas. We can also insert totals to the data by choosing TOTALS under quick analysis. Like this, we can make use of various charts which suits our data structure. Right click the command, and then click Add to Quick Access Toolbar. To add a command to the Quick Access Toolbar, execute the following steps. By default, the Quick Access Toolbar contains four commands: AutoSave, Save, Undo and Redo. Select the required chart here I have selected a clustered column chart your quick analysis is ready to use. If you use an Excel command frequently, you can add it to the Quick Access Toolbar. Once the data is selected, click on “Charts.” We can also insert a chart to the selected data by using the Quick Analysis tool. Tip #2 – Quickly Analysis Inserting Chart to the Data

Click on OK we will have mentioned formatting for all the values, which are >140.

Mention the value as 140 and choose the formatting color.

If you want to highlight all the values which are greater than 140, then click on the Greater option you will see below the window.

Click on Icon Set to get icons for your numbers.

Click on Color set to insert different colors.

Similarly, we can make use of Color Set, Icon Set in excel, Greater Than, Top Value, and more importantly, we can clear the excel formatting with the “Clear” option. 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 Sparklines”.

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.

Using quick analysis tool in excel