Image optimizing tool

Many of us would be sending picture files to your friends,family, relatives etc., but the major problem is size. Yes, there are many softwares available in www to reduce the size of the image but we the resolution changes. It looks bad sometimes.

Radical Image Optimization Tool (RIOT for short) is a free image optimizer that will let you to visually adjust compression parameters while keeping minimum filesize.

Click here to download

Demolition call - Funny gal

Listen to this !!! Very funny.. a gal calls to a demolition company and ask to destroy her school....

YouTube - Demolition call (Legendada em Portugues)

Drag and Drop attachments in your Gmail

Google Google Google!!! Yes it’s Gmail that gives this feature as like outlook. While composing just we can drag and drop the documents to our compose box instead of browsing and locating the path. Google saves your time!!!

Note: Currently this feature is supported in chrome and Firefox, expected in other browsers soon.

Excel tip: Date, time insertion

Many people often use excel for various purpose. In any professional life in average 98% people use excel on daily basis.

Inserting current date and time is most often used functions. Let’s see the shortcuts to insert date and time in 3 different scenarios.

1.     Inserting Date: (Ctrl + ;)

To add the current date to a cell, begin by clicking on the cell where you want to date to be in your worksheet. Hold down the Ctrl key and hit the ; (semicolon) key. That will place the current date into any active cell.

Eg: 4/15/2010

2.     Inserting Time: (Ctrl + Shift + ;)

To insert the current time, click on the cell where you want to store the current time. Hold down both the Ctrl and Shift keys and press the ; (semicolon) key. That will place the current time into the cell.

Eg: 11:22 AM

3.     Inserting Date and Time:

To insert both the current date and the current time into the same cell, click on the cell where you want the date and time to be in your worksheet. Hold down the Ctrl key and press the ; key. Now, hit the space bar and hold down the Ctrl and Shift keys and press the ; key.

Eg: 4/15/2010  11:23:00 AM

Also,

·        To insert a dynamic date stamp into Excel, enter the following formula into any cell: =TODAY()

·         To insert a dynamic date and time stamp into Excel, enter the following formula into any cell: =NOW()

Depending on your need you can use any of the above options. 

10 Ways to protect your information in public PC

1.     PC Setup: Don’t install any software’s in public PC’s, normally it should not allow you. Installing software’s by entering your personal information and the key which you bought makes you to lose your authentication.

2.     Keyloggers: Either physical or any key logger software would do a better job. Data’s are stolen in the way that we enter details thru our keyboard only. So encryption of key would help in preventing your data’s.

3.     Avoid Certain Tasks: Unless until it’s emergency don’t login for Banking/shopping activities.

4.     Clear Cache: Always clear cache when you are about to exit from any browser.

5.     Delete Files: If you download any documents for editing or copying, make sure you Shift+Delete the file before you exit.

6.     Empty Trash/Recycle Bin: This is self explanatory.

7.     Use Flash Drives Carefully: If you save your files to a flash drive, be careful because you may end up giving all of your files on the drive to a would-be thief. The thief may have loaded software on the public computer to grab any files on a drive that is inserted into the computer. Clever thief may also have software installed to transmit virus to your flash drive.

8.     Uncheck Save Info Options: Avoid “Stay Signed in” Options for any email account login.

9.     Watch for Prying Eyes: Don’t think that you are not followed thru camera. Thief’s can have hidden camera’s hence use your body as a shield if you must type in personal information at a public PC.

10.                        Trust you’re Instincts: If you feel like public PC’s request for your personal information, stop giving it. Your profile may be stored for any spam purpose. If at any time you feel uncomfortable sharing information, don’t hesitate to leave so you don’t risk giving away your private information.

Removing Duplicate Rows in xls 2007

Today I feel like giving a tip. Today’s Tip is how to remove duplicate rows in Microsoft excel 2007.

Let’s take an example I have the below name and address

Name	Address
John	143 washington blvd
Smith	150 tonne ave
Sergio	34 van reipen ave
Smith	45 summit ave

In the above table there is two Smit. Now click on DataàRemove duplicates

Now you will be prompted to select columns for removing duplicate entries. (We should select name as we are going to remove the name alone)

Once you click ok, your data will look as below.

Name	Address
John	143 washington blvd
Smith	150 tonne ave
Sergio	34 van reipen ave

Now consider the below data.

First Name	Last Name	Address
William	John	143 washington blvd
Robert	Smith	150 tonne ave
Isper	Sergio	34 van reipen ave
Jing	Smith	45 summit ave
Robert	Smith	22 winkle ave

Here Smith is repeated three times where as Robert smith is repeated only two times. Now you should be caution in removing duplicates. You should select only first name to remove, incase if you select last name column to remove duplicate 3 Smith data will be removed (2 Robert Smith and 1 Jing Smith).

Though this is a cool feature, but see the address column, in the above example Robert smith is present in different address, they will be removed as the name is same. So this feature should be used wherever it’s applicable. 

Block programs executed by others

Dear All,


Yesterday my friend called me and said "Hi Abbu, i would like to block some applications in my PC so that it should not be executed by anyone else, do you have any idea?"


Guess my reply!!!


mmmm, i said "buddy, there should be some option which i m not sure let me give a try".  Then after i started my investigation which stopped me here.


A software named "Lockup", it manages the execution of applications in your computer. If you dont want some application to be executed by others in your PC (may be ur brother/sister/wife/friends) then this application would be a one stop solution for it.

Note: Make sure you have selected "Only the list below" else all the application including windows will be locked! :(

Open the application click on browse add the application whichever you want to block it. Now when someone tries to open then the user will get the below message

Click here to download.

Post frequency

Dear Readers,

I am receiving many emails to my inbox requesting to post many application tips other than software tips. First i would like to thanks everyone for reading my blogs.

I understand your points, as i couldn't reply to all emails i am publishing this reply as my post.

I promise you that my ultimate goal is to share my knowledge with read access to you all :)

I will keep updating tips other than software's.

Please share this blog with your friends and keep sharing what you learnt from my blog.

Yours

Abbu

Knowing the time of different zone

I would like to thank Google for adding day-to-day features for us.

TIP:

If you want to know what’s the current time in India, open Google and type “Time Indi” for London type “Time London”!!! Cool right J

Know the meaning without any link?

Google is everywhere. Every day Google gives some new features to users.  Now don’t ask me why they are still giving everything for free, Pray that they should not stop the service.

Let’s not deviate from our topic here. Have you ever noticed that we can find the meaning of a word without browsing into any dictionary/other web links?

If you want to know a meaning of any word it’s simpler now. Open Google, type “Define space and your word” (see the above screen).

Now it’s your turn,,,, Google it I say J

Dont thank me now!!! Thank to Google!!!!!!!!!

How to grand access to file for 1 day or for other time limit?

When you use some common PC @ home/office we will be in a position to share a folder or file to our friends or with colleagues.  After they use it we will forget to unshared, Ops!!! Human memory is not CPU J still we are humans.

Today let us see how to share a file or folder for 1 day or for some few hrs to others.

Yes, with no doubt this is freeware!!!

SecureShare is a freeware which allows you to add a password and expiration date to your files you would want to share to your friends or others, people can only view your files by entering the password you assigned before the expiration password arrives, Moreover your files cannot be copied, printed, saved, forwarded or printed. Mmmm….. You will love this when you start using it.

What you are waiting for??? Click here to download right now!

How to block access to websites in your own PC?

Dear readers,

You can’t stop thanking me if I tell you this tip!

This scenario may happen to everyone. I am having my notebook in my home and my parents/relatives/friends any one can access my PC. But I may think of blocking some websites to be accessed by others thru my PC. There are lot of parent control software’s available but still we shall see how we can do this by our own.

 For Eg., I would like to block youtube.com from my PC.

1.     Goto C:\WINNT\system32\drivers\etc or C:\Windows\system32\drivers\etc

2.     Open “hosts” file in notepad.

3.     At the end of that file you should be seeing

“127.0.0.1       localhost”.

4.     Now add 
127.0.0.2 www.youtube.com and 


127.0.0.3 www.anywebsitename.com

5.     Once you are done, reboot your PC. Now you won’t be able to access youtube or any other site name that you have specified.

Two Program Files Folders in my Windows folder!

Dear Readers,

Have you ever wondered why does windows folder has Program Files & Program Files (x86)? Mmmm, I know now you should have recalled why you don’t think thisJ.

Whatever it may be, let’s see why we have these two folders.

The first folder (Program files) is the default location for all of your 64-bit programs. It does not have an extra label at the end because as a 64-bit operating system, it is assumed that you will have only 64-bit applications installed on your computer.

The second folder labeled Program Files (x86) is the default location for all of your 32-bit applications. To be clearer, it is a folder designed for legacy software that is left over from the days of 32-bit operating systems.

Hope it’s clear now, It’s not that much easy for all the software and hardware company to switch from 32-bit to 64-bit as Microsoft doesL. They need to consider many parameters.

By the time all the software and hardware company reaches 64-bit, who knows Microsoft may release 128-bit architecture with one folder (Program files, Program files x86, Program files xx86) J

Meet you again!