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
Watch the step-by-step video tutorial:
Click here to download the practice file
Looking for ready-made Excel Chart Templates?
Browse finished, fully working templates you can use with your own data straight away.
Want to master these skills step by step? Join the video course Excel Pivot Tables & Dashboards: Basic to Advanced.



