in excel where is the quick analysis button

The Quick Analysis Formatting tab is all about Conditional Formatting. xlsx file please ensure your browser doesn't change the file extension on download.

Quick Analysis was super useful in helping me understand the data, data that I’m not familiar with and don’t work with regularly.ĭownload the Excel Workbook. then Quick Analysis will do it all for you.įor this example we’re using data on the usual daily intake of fruit and vegetables for Australians aged 18 to 75+, sheesh, I didn’t realise we were such an unhealthy bunch. If you’re new to Excel or don’t know how to use Conditional Formatting, Charts, PivotTables etc.If you’re not familiar with the data, it allows you to use a range of tools quickly to see if anything pops out that you’d like to investigate further.If you’re not sure how to visualise your data, you can quickly experiment using Quick Analysis without actually applying any formatting or creating any charts.Excel Quick Analysis – What’s it good for? You could say I've EXCELled myself 😉īe sure to watch it in full screen HD for best results. I've even created a video so you can see it in action. Hovering over the icons in each tab gives you a preview of the different analysis options applied to your data. The Quick Analysis toolbar appears anytime you select two or more cells containing data:Ĭlicking on the icon (or CTRL+Q) reveals 5 menus (Formatting, Charts, Totals, Tables and Sparklines): Excel for Decision Making Under Uncertainty CourseĪ new feature in Excel 2013 is called Quick Analysis – it’s data analysis made easy, so easy my 6 year old could use it, you just point and click and Excel creates live previews and insights into your data using:.Excel for Customer Service Professionals.

In excel where is the quick analysis button