How to Use the Quick Analysis Tool in Microsoft Excel

See Microsoft Excel: Tips and Tricks for similar articles.

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.

  1. Select the cells of data that you want to analyze. Select Cells
  2. Notice the Quick Analysis Tool icon that is displayed at the bottom of the data. Click it. Quick Analysis Tool Icon
  3. Roll over each option in the Quick Analysis gallery to see a preview. Roll Over for Preview
  4. To select an option, click it. Click to Select Option