Select a range of cells and click the Quick Analysis button. Assuming that you have some data prepared that you’d like to analyze, you can open the tool quite easily. Select a spreadsheet, head to the Home tab, and click “Analyze Data” toward the right side of the ribbon. Where is the data analysis button in Excel Click the File tab, click Options, and then click the Add-Ins category.This will open a nifty task pane on the right side with visuals, options, and other ways to analyze. You literally only need 5 clicks to load the Analysis ToolPak. In the Manage box, select Excel Add-ins and then click Go. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. Kasper Langmann, Co-founder of Spreadsheeto. You can use the Quick Analysis tool to quickly calculate totals.

To start, click ‘File’ from the tab list. Choose the appropriate options for your data range. In this example, the Sum option totals the numbers in each column. To enable the Excel Quick analysis tool, go to the File menu and click on Options.

Click the quick analysis button after selecting the data that the sparklines should be added. Open ‘Excel Options’ by clicking ‘Options’ on the left-hand sidebar. Choose the type of sparkline you want to insert by going to the sparklines tab. Quick Analysis allows you to do so as well.

Sparklines for the selected data will appear right away in the cells you selected. Step 1: Follow the same step we did in example 1 and 2. Select the data and navigate to Quick Analysis Tool. There, selct Totals option there you’ll see different sub-options like sum, average, etc. Step 2: Click on Average button inside the Totals option to calculate the average sales based on the. Then, click ‘Add-ins’ (second to the last) on the left sidebar of the window.

The quick analysis button data