How to Use Quick Analysis in Excel

Step-by-Step Guide

1. 1

   Step 1: Open the Excel 2013 file that contains data you want to analyze.

   As you hover over the button, a dialog box should open showing the title Quick Analysis (Ctrl+Q) with a description of quick analysis below that title. ,,, Note that an arrow pointing left and/or right will indicate if more options can be seen. , In this instance, %Total with the calculations showing at the bottom was the tool chosen. ,
2. 2

   Step 2: Select the cell range that contains the data to be analyzed.

3. 3

   Step 3: Hover over a small button in the bottom-right corner of the selected cell range.

4. 4

   Step 4: Use the mouse to left click the button to activate it so that it shows the gallery of tools available to you for analyzing the selected data.

5. 5

   Step 5: Choose the topic header tab that fits your data analysis needs by clicking it with the mouse.

6. 6

   Step 6: Hover over each tool option listed under your selected header to display a preview of the results that will be posted to your data if selected.

7. 7

   Step 7: Choose the appropriate tool for your data analysis needs by clicking it with the mouse.

8. 8

   Step 8: Save the file so as not to lose your work thus far.

Detailed Guide

About the Author