We get a quick live preview and select the option you want. The key differences between QAT and regular methods: We strongly recommend our definitive guide if you want to learn all about conditional formatting. Now let us see how to apply conditional formatting using QAT. Formatting Ranges using Quick Analysis Tool You can choose from the following tools: Formatting, Charts, Totals, Tables, and sparklines. If you like using Excel shortcuts, apply the Ctrl + Q combination.Ĭlick the Quick Analysis button on the bottom-right corner of the range. From now the QAT toolbar will appear by default. Check Show Quick Analysis options on selection. You can choose two methods to activate the tool. How to turn on the Quick Analysis feature? Quick Analysis with TOTALS ( Sum, Average, Count, Running Total).Formatting Ranges using Quick Analysis Tool.How to turn on the Quick Analysis feature.

Today’s lesson will explain how to use this feature in Excel. Excel’s Quick Analysis Tool is the easiest way to analyze your data instantly using different tools (Formatting, Charts, Totals, Tables, or sparklines)

Quick analysis button excel