Use the Quick Analysis tool to convert your data quickly and easily into a chart or table. This feature works the same in Microsoft Excel 2013 and 2016. Select the cells of data that you want to analyze. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. The QUICK ANALYSIS TOOL is a collection of some selected options that you can use to analyze the data quickly. It includes conditional formatting, charts, pivot table, and sparklines. It also takes care of what type of data (text, dates, or numbers) you have selected and show you the options based on that. Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Quick Analysis takes a range of data and helps you pick the perfect chart with just a few commands. Select a range of cells. Select the Quick Analysis button that appears at the bottom right corner of the selected data. Excel offers many tools for you to organize your data. The Quick Analysis tool to will quickly analyze and visualize data for you. With your data selected, open the Quick Analysis tool by pressing Ctrl + 'Q.' Select the tab you would like to use (sparklines, formatting, tables, etc.) and hover over the options to see a preview.
- Quick Analysis Tool In Excel 2010
- Quick Analysis Tool In Excel 2016 For Mac
- Quick Analysis Tool In Excel 2019
- Quick Analysis Tool In Excel 2013
- Quick Analysis Tool In Excel
Totals | Tables | Formatting | Charts | Sparklines
Use the Quick Analysis tool in Excel to quickly analyze your data. Quickly calculate totals, quickly insert tables, quickly apply conditional formatting and more.
Totals
Instead of displaying a total row at the end of an Excel table, use the Quick Analysis tool to quickly calculate totals.
1. Select a range of cells and click the Quick Analysis button.
2. For example, click Totals and click Sum to sum the numbers in each column.
Result:
3. Select the range A1:D7 and add a column with a running total.
Note: total rows are colored blue and total columns are colored yellow-orange.
Tables
Use tables in Excel to sort, filter and summarize data. A pivot table in Excel allows you to extract the significance from a large, detailed data set.
1. Select a range of cells and click the Quick Analysis button.
2. To quickly insert a table, click Tables and click Table.
Note: visit our page about Tables to learn more about this topic.
3. Download the Excel file (right side of this page) and open the second sheet.
4. Click any single cell inside the data set.
5. Press CTRL + q. This shortcut selects the entire data set and opens the Quick Analysis tool.
6. To quickly insert a pivot table, click Tables and click one of the pivot table examples.
Note: pivot tables are one of Excel's most powerful features. Visit our page about Pivot Tables to learn more about this topic.
Formatting
Data bars, color scales and icon sets in Excel make it very easy to visualize values in a range of cells.
1. Select a range of cells and click the Quick Analysis button.
![Tool Tool](https://www.excel-easy.com/examples/images/quick-analysis/quick-analysis-tool.png)
2. To quickly add data bars, click Data Bars.
Note: a longer bar represents a higher value. Visit our page about Data Bars to learn more about this topic.
3. To quickly add a color scale, click Color Scale.
Note: the shade of the color represents the value in the cell. Visit our page about Color Scales to learn more about this topic.
Quick Analysis Tool In Excel 2010
4. To quickly add an icon set, click Icon Set.
Note: each icon represents a range of values. Visit our page about Icon Sets to learn more about this topic.
5. To quickly highlight cells that are greater than a value, click Greater Than.
6. Enter the value 100 and select a formatting style. Minolta driver.
Quick Analysis Tool In Excel 2016 For Mac
7. Kashiwano soft driver download for windows. Click OK.
Result. Excel highlights the cells that are greater than 100. N-trig others driver download.
Note: visit our page about Conditional Formatting to learn much more about this topic.
![Quick Analysis Tool In Excel Quick Analysis Tool In Excel](https://i.ytimg.com/vi/6tCDAKpGm00/maxresdefault.jpg)
Charts
You can use the Quick Analysis tool to quickly create a chart. The Recommended Charts feature analyzes your data and suggests useful charts.
1. Select a range of cells and click the Quick Analysis button.
2. For example, click Charts and click Clustered Column to create a clustered column chart.
Note: click More to view more recommended charts. Visit our chapter about Charts to learn more about this topic.
Sparklines
Sparklines in Excel are graphs that fit in one cell. Sparklines are great for displaying trends.
1. Download the Excel file (right side of this page) and open the third sheet.
Quick Analysis Tool In Excel 2019
2. Select the range A1:F4 and click the Quick Analysis button.
Quick Analysis Tool In Excel 2013
![Excel Excel](https://d3n817fwly711g.cloudfront.net/uploads/2018/03/7-Visual-Brainstorming-Techniques-to-Generate.png)
2. To quickly add data bars, click Data Bars.
Note: a longer bar represents a higher value. Visit our page about Data Bars to learn more about this topic.
3. To quickly add a color scale, click Color Scale.
Note: the shade of the color represents the value in the cell. Visit our page about Color Scales to learn more about this topic.
Quick Analysis Tool In Excel 2010
4. To quickly add an icon set, click Icon Set.
Note: each icon represents a range of values. Visit our page about Icon Sets to learn more about this topic.
5. To quickly highlight cells that are greater than a value, click Greater Than.
6. Enter the value 100 and select a formatting style. Minolta driver.
Quick Analysis Tool In Excel 2016 For Mac
7. Kashiwano soft driver download for windows. Click OK.
Result. Excel highlights the cells that are greater than 100. N-trig others driver download.
Note: visit our page about Conditional Formatting to learn much more about this topic.
Charts
You can use the Quick Analysis tool to quickly create a chart. The Recommended Charts feature analyzes your data and suggests useful charts.
1. Select a range of cells and click the Quick Analysis button.
2. For example, click Charts and click Clustered Column to create a clustered column chart.
Note: click More to view more recommended charts. Visit our chapter about Charts to learn more about this topic.
Sparklines
Sparklines in Excel are graphs that fit in one cell. Sparklines are great for displaying trends.
1. Download the Excel file (right side of this page) and open the third sheet.
Quick Analysis Tool In Excel 2019
2. Select the range A1:F4 and click the Quick Analysis button.
Quick Analysis Tool In Excel 2013
3. For example, click Sparklines and click Line to insert sparklines.
Customized result:
Quick Analysis Tool In Excel
Note: visit our page about Sparklines to learn how to customize sparklines.