![Quick analysis button not showing up in excel](https://cdn1.cdnme.se/5447227/9-3/22_64e61dfde087c31b3e70ff43.png)
![quick analysis button not showing up in excel quick analysis button not showing up in excel](https://www.dummies.com/wp-content/uploads/excel-quick-analysis.jpg)
![quick analysis button not showing up in excel quick analysis button not showing up in excel](https://www.excel-easy.com/examples/images/running-total/automatic-running-total.png)
The Quick Analysis feature gives you a variety of tools for analyzing your data instantly. For example, you can use the tool to highlight the cells with a value greater than a specific number, get the numerical average for the selected cells, or create a chart on the fly.
![quick analysis button not showing up in excel quick analysis button not showing up in excel](https://i2.wp.com/theexcelclub.com/wp-content/uploads/2019/03/2_switch-to-form-1024x550.gif)
Click it and you’ll get a variety of tools for performing instant analysis of your data. A small icon of a spreadsheet with a lightning bolt on it appears. Highlight the cells you want to analyze, then move your cursor to the lower right-hand corner of what you’ve highlighted. If you’re looking to analyze data in a spreadsheet, the new Quick Analysis tool will help. Spreadsheet pros will be pleased with four new features built into Excel 20 - Quick Analysis, Forecast Sheet, Get & Transform and 3D Maps.
![Quick analysis button not showing up in excel](https://cdn1.cdnme.se/5447227/9-3/22_64e61dfde087c31b3e70ff43.png)