

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 Customer Service ProfessionalsĪ 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:.
