Quickly create multiple defined names at once in Excel

In the earlier example of using natural language in Excel, where we use name ranges; one has to create multiple data names for each of the location and data type. Heres a quick way to do so.
Here is a quick shortcut to create multiple data range at once.

How to quickly find rank in a data table

You might have came across various data tables, where you wish to sort data or rank them as per the performance. There is a Function called RANK, which you can use to quickly find the performance ranking.

Simplify Excel with custom defined names

Excel has hundreds of formula's available, for varied subjects and requirements. Have you ever wondered if you could work a way where you could use user friendly language to derive what you want; kind of programming your way in Excel !! Heres a way how to...

Sum of same cell across multiple worksheets

Suppose you have 12 identical table across worksheets, for each month. And you want to take sum of each of the cells across all the worksheets. You would use mouse and keyboard to browse each of the sheets and select the cells to get this =Jan!E6+Feb!E6+Mar!E6+Apr!E6…Dec!E6
Todays post is to show you a shorter way.

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.