Tag Archives: Quick Analysis

Turn CSV data into insight like a pro with Excel 2016

Posted on March 3, 2019 by MF

Many people are not aware of how easy-to-use and powerful modern Excel is. I mean Excel 2016 or later. In this post, I will show you how to turn CSV data into insight in a just a couple of minutes like a pro. Techniques used: Flash Fill, Quick Analysis and two new chart types (Histogram and Pareto). Continue reading →

Rate this:

Posted in Excel in Action | Tagged , , , | 2 Comments

Creating % of Total, Running Total in a few clicks with #Excel Quick Analysis

Posted on July 5, 2018 by MF

This post is about showing you how to perform a common task of adding a column of % of Total Running Total with Quick Analysis in Excel 2013 or later. Latest Excel makes things easier, just that you may not be … Continue reading →

Rate this:

Posted in Excel Tips | Tagged | 1 Comment