A spreadsheet is often a very handy tool for analysis and reporting. With MS Excel, there are loads of cool features and still newer ones being added on with newer versions of it. But imagine the plight of having to do an analysis and there is a data overload in that Excel workbook. Ok, you played with some of the possibilities in MS Excel, discovered few techniques of “doing that in a smarter way” and later on while making the presentation, someone (or you yourself) discovers some faulty data. First thing that comes to your mind is “Oh no, I’ve to do that again?”. Well with massive data crunching, there often comes situations like these.

Continue Reading »