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.
Video
For more information, visit this Hoonuit video.
| Author: karperc | Last Updated: 10/8/2018 10:17 AM | Page Views: 1295 |
helpdesk.etown.edu/helpconsole2012/kb/default.aspx?pageid=quick_analysis_tool
|