Here are three (3) ways to analyze data in Excel using the Quick Analysis icon:
1) Quick Analysis - Charts
2) Quick Analysis - Totals
3) Quick Analysis - Tables
Notice anything similar? Yes, the Quick Analysis icon allows you to format data in a few simple steps. There are actually many different options within each of the three. And, there are actually 5 different Quick Analysis options, but I am highlighting 3 that are typically used for analyzing data.
To use the Quick Analysis icon, simply highlight your data and use the Quick Analysis icon that appears in the lower right corner of the data. From there, you can easily select the option you need in order to view the data in the way you would like to showcase it.
To see how this works in detail, watch the video below.