How to Use the Quick Analysis Tool in Microsoft Excel

  • google plus

In Brief...

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

Related Video

Author: Dave Dunn

Dave Dunn joined Webucator as Chief Operating Officer in early 2009. He has served as a CFO and COO for numerous small and medium-sized companies, including Summit Software Company, Insight Research Group, Avalon Consulting, and HealthcareOne. He has expertise in business development, financial management, marketing and human resources and particularly enjoys working with rapidly growing companies.

Dave received his Bachelor of Arts from Hamilton College and his MBA from Syracuse University. He has served as Chairman of the Board of the Montessori School of Syracuse since 2001.