how do i get the quick analysis button on excel

When you select the Chart tab you’re presented with some chart options that are suitable for your data. Within seconds of hovering my mouse over the Colour Scale I could see that 25-34 year olds consume the least fruit and vegetables overall and then we slowly improve as we get older, but not nearly enough with less than 10% of us consuming adequate fruit and veg.Īnyway, we’re not here to actually analyse the data, let’s press on and look at some other applications of Quick Analysis. 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.

How do i get the quick analysis button on excel