Top Ten New Features in Excel 2013
Quick Analysis tool
The Quick Analysis tool appears at the lower-right corner of any selected table in an Excel 2013 worksheet. This tool contains options for applying conditional formats, creating a chart or pivot table, totaling values in rows or columns, or adding sparklines for the data in the selected table. And thanks to Excel’s Live Preview, you can see how your table data would appear using the various options before you apply any of them.