How to Use the Quick Analysis Tool in Microsoft Excel

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, Webucator’s CEO, joined Webucator in 2009 after serving as a CFO and COO for numerous small and medium-sized companies, including Summit Software Company, Insight Research Group, Avalon Consulting, and HealthcareOne. 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.

About Webucator

Webucator provides instructor-led training to students throughout the US and Canada. We have trained over 90,000 students from over 16,000 organizations on technologies such as Microsoft ASP.NET, Microsoft Office, Azure, Windows, Java, Adobe, Python, SQL, JavaScript, Angular and much more. Check out our complete course catalog.