Get answers instantly from chatbot Google Talk Guru

If you are using Gtalk, a new chat bot named “Google Talk Guru“  will help you find your answers quickly and instantly. To use this feature you will require to add guru@googlelabs.com to friends list.  Gtalk Guru will be able to answer many of the frequently used queries instantly for ex. Currency Conversion or any Sports Score or Definition of a particular word.

Some of the sample queries which Google Bot can understand are :

1. Sport scores: “score arsenal”
2. Weather: “weather Nairobi”
3. Calculate: “123 * 45″
4. Currency: “120 KES to USD”
5. Definition: “define laptop”
6. Translation: “translate earth to French”
7. Web result: “web Mount Kenya”
8. Help: “help translate”

Currently “Google Talk Guru“ is an experimental service, hopefully it will be enhanced in near future can be enhanced to answer more complex queries for you.  You can find more details about this service from below “Google Talk Guru” webpage.

Screen Capture Extension for Google Chrome

There are several “Screen Capture” extensions available in Google Chrome extension’s gallery but most of them lacks even basic features or a Screen Capture tool. “Screen Capture (by Google)”  seems be a good one which is easy to use and does what it says. You can capture visible content of a tab, a region of a web page, or the whole page as a PNG image. It also supports horizontal and vertical scroll when capturing whole page, with an all new auto-save capability.

This extension works  on Windows, Linux and Mac as well. You can install this extension from below link

Download Screen Capture extension for Google Chrome

Excel 2007 convert columns to rows

I am going to share another timesaving tip for Excel. Many time we need to present our data in different way. As a developer I find Excel very convenient to create sample data for my projects and then insert it into the Database. What if we want to re arrange the data which is coming in columns to rows?. Yes, you can easily change data representation row-wise. To do this, copy the data after highlighting it.  After this, right click on the cell where you want to show it.

 

From the shortcut menu select Paste Special , this will show you a dialog box  similar to below image :

Select  Transpose  and press ok button. You will find you column data is arranged row-wise.

You can follow similar steps to convert row data into column layout. This trick should also work with Excel 2010 version.