Quick Analysis is a new feature in Excel 2013 with which you can apply different analysis tools to the data you’ve selected on your worksheet. It’s easy to use and can show you at a glance what trends are appearing in the information you’re gathering.
In an open Excel workbook, drag to select the cell range that you want to analyze.
The Quick Analysis tool appears just below and to the right of the range you selected.
Click the Quick Analysis tool.
A palette of tools appears, showing you different options for analyzing the selected data. You can choose to apply conditional formatting tools, display the data as a chart, use Total functions, display the data in tables, or add ...