How-to extend the time limited views of online tv

There are many websites that provide viewing of TV channels online. However, when you are in office and have limited access to all websites, and want to see cricket match online, there are very few channels that provide such a service but with limited time only. This technique will help you extend the time.

How-to create Chrome App and Extension for your Blog or website

Finally, after giving much thought, I published a Chrome app and an extension for this blog on the Google Chrome store. It has been an amazing experience, to know that it is nothing more than a small tweak from what Google has already provided. Even a beginner can write a basic Chrome app and publish it on the Chrome store in less than five minutes.

Many-to-may relationship in Excel

I have been working on a particular job of consolidating cost center wise data of products procured in the past. The problem is that the data is continuous array, separated by commas. The resolution is to first segregate the data first and then show it component wise.

Two ways to reset Windows 7 password

After my popular post on resetting Windows XP password earlier (read it here), this is a post on resetting password for Windows 7. There maybe many other ways to do this, but i am listing down here two methods that are typically easier.

Note: Even though there are no known issues, try it at your own risk

Candy Crush Hack for rooted users

Hack method: 3

How could i forget the hack of the most popular games of all times !! This however, is only for rooted users. For non-root users, you can download and use the modded Candy Crush. To know, how to root an Android phone, read my earlier post here.

Note: I won't be responsible, if you brick your phone, while trying to root. Try at your own risk.

Demo of my application in Android - Gadget Buzz

I have been quite updating on all social medias, to try out my app. I thought a little demo or walk-through would help those who does not have Android or have not installed them.

How to fill blank cells in Excel

Ok heres a quick tip on how to fill blank cells in Excel with zero or NA. Its simple find and replace function in Excel.

Copy the exact formula without shifting range

So you have just entered the SUM formula on 24th row on Excel, and wish to put an AVERAGE formula just below it. If you copy the formula for SUM (fig 1) which is just above it, the range will change automatically (fig 2.)

Sum of visible cells only in Excel

The SUM function in Excel provides the total SUM of all the cells mentioned in the range, be it hidden or not. Now, lets assume that it is the nth version of Excel working and you have hidden many rows, which you found to be irrelevant at that point in time. How will you find the sum of the visible cells only?

Resize your images before upload

I thought I had shared this tip earlier, seems i have missed out a lot of small little tips. I shall be covering them in the days to come. This tip is to reduce the size of bulky images without losing much on the quality, before making an upload to save your bandwidth.