Quick Analysis Is One of the Best Excel Features You Aren’t Using
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.
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:
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!