Quick Analysis Tool is used to apply the quick conditional formatting, Quick Charts, add Totals, Quick Pivot Tables and to add quick Sparklines in selected data.
Quick Analysis Tool in Microsoft Excel
After selecting the data, you can press Ctrl+Q Shortcut key to open this tool.
Note: This feature is available in Excel 2013 and above version only.
Visit our YouTube channel to learn step-by-step video tutorials