There is no sample file accompanying this post.

So, I am going to show one quick tip of using Quick Analysis (provided that you are using Excel 2013 or later) to add a column ofĪ picture (especially an animated one) tells thousand words, so let’s look at the screencast below: Needless to say, many people have never clicked the tiny icon that showed up automatically when a range of data is selected. The response I got was mostly: “What are these?” and some of them unconsciously showed an attitude of “I don’t care…” (not yet to mention about the new FUNCTIONS). What is even more surprising (or ironic): when I met someone who uses Excel 2013 or later, I looked at them with my “hearty” smiles and told them how lucky they are with all those new features like Flash Fill, Quick Analysis, etc…. However I am living in a city where most people I know (across different companies) are still using Excel 2010 or before. You may think that Excel 2013 is a product of 5 years ago… there is no way it can be called “latest”…. Of course, Excel 2016 and of course Excel 365 is getting even better. Well, what I meant “latest Excel” here are those versions since Excel 2013. Latest Excel makes things easier, just that you may not be aware of…

With Quick Analysis in Excel 2013 or later. This post is about showing you how to perform a common task of adding a column of

Use quick analysis tool in excel 2016