The Analysis ToolPak is an Excel add-in program that provides data analysis tools for financial, statistical and engineering data analysis.

In this article we will see that how you can formatting your excel sheet using quick anaylsis tool that I can explined earleir. When you select a range of data in a Excel sheet, this feature popup a button that contains some buttons to format your sheet and you can pick from a set of recommended analytic actions on the data. In Excel 2013, the new Quick Analysis button allows you to instantly access and easily apply the most commonly used tools for analyzing your data, whether it be conditional formatting, inserting charts and totals, creating tables, etc.

To load the Analysis ToolPak add-in, execute the following steps.

1. On the File tab, click Options.

Quick Analysis In Excel 2010

In the Excel Options dialog box, on the General tab check or uncheck Show Quick Analysis options on selection: Note: You can also press Ctrl+Q on the keyboard to display the Quick Analysis options. The main lack I find is the absence of the statistical analysis tools (analysis toolpack, as I recall). These can be had through third-party add-ins or separate tools. They were good, usable, and quick but not great in regular Excel. Follow these steps to load the Analysis ToolPak in Excel 2016 for Mac: Click the Tools menu, and then click Excel Add-ins. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

How To Find Quick Analysis Tool Excel 2017

2. Under Add-ins, select Analysis ToolPak and click on the Go button.

3. Check Analysis ToolPak and click on OK.

4. On the Data tab, in the Analysis group, you can now click on Data Analysis.

The following dialog box below appears.

5. For example, select Histogram and click OK to create a Histogram in Excel.

You can use Excel 2007's data visualization feature to keep tabs on when the data in a worksheet attain a certain value. For example, to discover which regions have achieved above-average sales this quarter, follow these steps:

How To Get Quick Analysis Tool In Excel On Mac

1. Select the cells you want to analyze.
2. Click the Home tab.
3. In the Styles group, click Conditional Formatting, then select Top/Bottom Rules.
4. Click Above Average, then click OK.

Now all cells with above-average sales values will appear marked in red. To find out who the top 10% of your performers are, follow these steps:

Quick Analysis Button In Excel

1. Select the columns of cells you want to analyze.
2. Click the Home tab.
3. In the Styles group, click Conditional Formatting and then click Top 10%.
4. Click the drop-down arrow in the With box and select Custom Format.
5. Click the Fill tab and select Yellow under Background Color.
6. Click OK twice.

Now all values in the upper 10% of the range appear highlighted in yellow. You can set an entire spreadsheet with conditional formatting rules and watch the results change each time you enter new data.

Excel 2016 Quick Analysis Button

Quick Analysis Tool In Excel

Check out the Microsoft Excel archive, and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.