The same thing holds for all the options in the Quick Analysis tool.Ĭlick Formatting on the Quick Analysis toolbar. However, if you want to utilize all the features of Conditional Formatting, you rather go through the main menu on the Ribbon. The difference is that you can have a quick preview and select the option you want. You have learnt about formatting rules in the Conditional Formatting chapter in this tutorial. This lets you quickly visualize the values in your data. FormattingĬonditional Formatting allows you to highlight parts of your data by adding Data Bars, Colors, etc.

Quick Analysis tool is handy and quick to use as you can also have a preview of applying different options, before selecting the one you want. The Quick Analysis toolbar appears with the options FORMATTING, CHARTS, TOTALS, TABLES, SPARKLINES. The Quick Analysis tool button appears at the bottom right of your selected data.Ĭlick the Quick Analysis button. To access Quick Access tool, select the cells that contain the data you want to analyze. You can use Quick Analysis with a range or a table of data. In Microsoft Excel 2013, the Quick Analysis tool makes it possible to analyze your data quickly and easily using different Excel tools.

Quick analysis button in excel