This is kind of a ready reckoner for myself and hopefully useful to anyone who visits this blog. There are so many tips and tricks to achieve some not so easy tasks in excel. Over a period of time one gains sufficient experience and learns how to get some stuff done.
I have been working on Excel since almost 8 years now and it still amazes me that there is so much more to the software. Every person will have his or her own little nugget about some hidden feature of Excel. Most of these stuff are available on the internet and you can find them pretty quickly with some intelligent searching. But often it takes up quite a while to find the exact solution and sometimes even stuff you have previously seen before is hard to find again. So I thought of coming up with a section on my blog to consolidate all these small stuff in a easy to find manner (hopefully).
To start with, this link contains stuff on how to crack an excel password and the same website also has stuff on how password protect an excel sheet. This is something I always keep needing whenever you find an excel sheet without a password sometimes created by ex-employees who have left the company but you need to access their stuff.
