Home > Microsoft Office > Excel > Quick Analysis Tool - Excel
Quick Analysis Tool - Excel
Use the quick analysis tool to format and analyze a set of data. This article shows Excel 2016, but the process is the same in Excel 2013 .
Quick links to sections in this article:
Use Quick Analysis Tool
Step 1:Open your existing data in Excel..
Step 2:
Select the data you wish to format or analyze.
Step 3:
Look for the quick analysis tool in the lower right corner of the selected data.
Step 4:
Click the quick analysis tool to open it. The options will vary by the type of data selected, however the tool typically contains the following categories:
FormattingUse Formatting to display or highlight certain data. Hover over the options to display a live preview in your data.
Charts
Display your data in a chart, such as a column or line graph. Hover over the chart options to display a live preview of your data.
Totals
Use Totals to complete calculations from your data. These calculations may appear in a live preview below or to the right of your existing data.
Tables
Format your data as a table with filtering options. Hover on the table to see a live preview of your data.
Sparklines
Display trends in your data. Hover over the options for a live preview to the right of your data.

Turn Off Quick Analysis Tool
Step 1:In Excel, click the File tab.
Step 2:Select Options.
Step 3:
In the General menu, remove the check from Show Quick Analysis options on selection under User Interface Options.
Step 4:
Click OK in the Options window.

Author: karperc | Last Updated: 3/11/2020 10:27 AM | Page Views: 2729 |
helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=quick_analysis_tool
|