When you need to do a speedy analysis of your data in Excel 2016, consider using the Quick Analysis feature. Here are some points to keep in mind about Quick Analysis: When you select a range of cells, a small icon appears in the lower right corner of the selected area. This is the Quick Analysis. When you select a range of data, Excel displays a Quick Analysis button in the lower-right corner of the range. But this option can be turned off. But this option can be turned off. To turn on/off the Quick Analysis feature, follow next steps.

• When you select a range of cells, a small icon appears in the lower right corner of the selected area. This is the Quick Analysis icon, and clicking it opens a panel containing shortcuts to several types of common activities related to data analysis.

• Click on of the five headings to see the shortcuts available in that category. Then hover over one of the icons in that category to see the result previewed on your worksheet: • Formatting: These shortcuts point to conditional formatting options. For example, you could set up a range to make values under or over a certain amount appear in a different color or with a special icon adjacent. You can use Quick Analysis to add summary rows or columns. • Tables: You can convert the range to a table for greater ease of analysis. You can also generate several different types of PivotTables via the shortcuts here. A PivotTable is a special view of the data that summarizes it by adding various types of calculations to it.

The PivotTable icons aren’t well-differentiated, but you can point to one of the PivotTable icons to see a sample of how it will summarize the data in the selected range. If you choose one of the PivotTable views, it opens in its own separate sheet.