Quick Analysis Is One of the Best Excel Features You Aren’t Using
Pinterest Stumbleupon Whatsapp

If you haven’t already, you really ought to consider upgrading to the latest version of Microsoft Office. I know we argued before that Office 2016 wasn’t worth it, but Office 365 is still a valid option as it shares all of the same features and improvements.

Indeed there are so many reasons as to why upgrading is a good idea, including an abundance of new productivity features that will save you time. Among those new features is the Quick Analysis function — which I fell in love in the first time I used it.

Excel 2013 2016 Quick Analysis Feature Overview

Using the Quick Analysis function is dead simple. Open a spreadsheet that has data in it, select a group of cells, then click on the icon that shows at the bottom-right corner of your selection (this is the Quick Analysis button). Upon clicking, you’ll see several types of possible analyses.

The five main categories are:

  • Formatting
  • Charts
  • Totals
  • Tables
  • Sparklines

For example, in the Formatting category you can hover over Data Bars to preview all numeric cells filled proportionally by data value. In the Totals category you can hover over Sum to see the summed value of all columns in your selection. If you want the preview to become real, click instead of hover.

I first found out about Quick Analysis when I was tracking the nutritional information of everything I ate — and the Sum feature was so useful in quickly summing up and previewing a day’s worth of food without having to use permanent equations and functions.

You can also use Quick Analysis to preview and make charts and tables in the blink of an eye. It doesn’t get more productive than that! Along those lines, we also recommend checking out these other must-learn Excel tips.

Have you used the Quick Analysis feature before? If so, what do you use it for? If not, will you be using it now? How useful does it sound? Share your thoughts with us below!

Enjoyed this article? Stay informed by joining our newsletter!

Enter your Email

Leave a Reply

Your email address will not be published. Required fields are marked *

  1. Klaas Vaak
    September 15, 2016 at 1:04 pm

    Quick Analysis is available in Excel 2013 too. So you actually contradict yourself that this feature warrants upgrading to Excel 2016. Apart from that, QA ia a cool feature ;-)

    • Joel Lee
      September 20, 2016 at 12:42 am

      Whoops, it appears you're right. I never had Excel 2013 (jumped from 2010 to 2016) so that's my excuse, haha. Thanks for the tip, Klaas. :)