It used to take a bit of work to analyze your data, but now it only takes a few steps. You can instantly create different types of charts, including line and column charts, or add miniature graphs (called sparklines). You can also apply a table style, create PivotTables, quickly insert totals, and apply conditional formatting.
Select the cells that contain the data you want to analyze.
Click the Quick Analysis button that appears to the bottom right of your selected data (or press CRTL + Q).
In the Quick Analysis gallery, select a tab you want. For example, choose Charts to see your data in a chart.
Pick an option, or just point to each one to see a preview.
You might notice that the options you can choose aren’t always the same. That’s because the options change based on the type of data you have selected in your workbook.
Which analysis feature should I use?
If you’re not sure which analysis option to pick, here’s a quick overview.
Formatting lets you highlight parts of your data by adding things like data bars and colors. This lets you quickly see high and low values, among other things.
Charts Excel recommends different charts, based on the type of data you have selected. If you don’t see the chart you want, click More Charts.
Totals let you calculate the numbers in columns and rows. For example, Running Total inserts a total that grows as you add items to your data. Click the little black arrows on the right and left to see additional options.
Tables make it easy to filter and sort your data. If you don’t see the table style you want, click More.
Sparklines are like tiny graphs that you can show alongside your data. They provide a quick way to see trends.