Excel Tips: Using the Quick Analysis Tool

Lesson 11: Using the Quick Analysis Tool


Using the Quick Analysis tool

There are a lot of ways to visualize data in Excel, but sometimes it's hard to know where to start. Luckily, the Quick Analysis tool lets you browse through many different options even if you don't know exactly what you want.

This tool is only available in Excel 2013 or later versions.

Whenever you select a cell range, the Quick Analysis button will appear in the lower-right corner of the selection. 

To see how these options are tailored to your specific data, watch the video below.


  1. Select the data you want to visualize.
  2. Click on the Quick Analysis tool button in the lower-right corner of your selected cell range. 
  3. You’ll see a menu of various options, like Formatting, Charts, Totals, Tables, and Sparklines.
  4. Hover over the different chart options to see a preview of each one. If you see an option you like, you can click it in order to make it more permanent.

You can dive right in to see what the Quick Analysis tool can tell you about your data. Experiment with different chart styles, colors, and formatting options to further customize your visualizations.

Continue on to the next lesson to learn how to make charts auto update.