Cant believe it!...:)

Hide your Ip and Location IP MASKING

IP masking is hiding your Original(Dynamic/Static) IP address so that you can not be traced. IP masking is using Fake IP address for your machine.

For Example, Let us assume your ip address is 173.23.22.212 and your location is xxxx.
...
Using IP masking, you can make your IP address is 202.102.12.123(fake IP Address) and your location becomes yyyy.

Using Proxy IP Address , you can hide your IP.

This can be achieved by the following methods:
Set Proxy IP Address in your Browser
Use IP hiding Tools
Web proxy(Eg: Flyproxy)

So won't i be traced now? The Answer is yes and No. It is depending on your anonymity level of your Proxy IP address.

Different Types of Anonymity Levels:
Transparent Proxy

This type of proxy server identifies itself as a proxy server and also makes the original IP address available through the http headers. These are generally used for their ability to cache websites and do not effectively provide any anonymity to those who use them. However, the use of a transparent proxy will get you around simple IP bans. They are transparent in the terms that your IP address is exposed, not transparent in the terms that you do not know that you are using it (your system is not specifically configured to use it.)

Anonymous Proxy
This type of proxy server indentifies itself as a proxy server, but does not make the original IP address available. This type of proxy server is detectable, but provides reasonable anonymity for most users.

Distorting Proxy
This type of proxy server identifies itself as a proxy server, but make an incorrect original IP address available through the http headers.

High Anonymity Proxy
This type of proxy server does not identify itself as a proxy server and does not make available the original IP address.

Want to see Ur Name After Time (no AM Or PM) On The Taskbar:

Windows XP

&; Go to Control Panel

&; Open Regional and Language Options

&; Click on Customize

&; Click on the time

&; Instead of AM & PM Enter ur desired name

&; Apply

&; Ok


In Windows 7

&; Go to control panel

&; Open Regional and Language option

&; Click on the additional

&; Even as is done in Windows XP (above)

U got it.Thanks

Stop Or Restart Your PC Remotely From Any Computer Or Mobile Phone:

Sometimes you want to leave or emergency restart your computer when you are away. There are many commercial remote controls allows you to manipulate your computer remotely. Some of them require installation on the client computer, some have a web interface, but works as ActiveX controls usually off by the security policy in many organizations and could not be used in most mobile phones. Airytec off switch allows you to shutdown or restart your PC remotely from any computer on your mobile phone with web browser installed right.

Follow these steps to enable the remote shutdown or restart your computer:

1. Home Airytec Off (if not already)

Second Enable Web Interface

** Right-click the Disable icon in the notification Airytec

** Options

** Click on the Remote

** Enable the web interface

** Change port number (optional)

** Enter the password (optional but highly recommended)

** Click on OK

3. Make sure that the web interface is available, start your browser and enter the address: http://localhost:8000/. If you changed the port number, when you enable the web interface should be replaced with 8000 of your own.

4. Now if your PC is connected to the Internet, you can stop any other computer or mobile phone with web browser installed.

Note 1: When connected to your PC from other computers or mobile phones, change localhost to the above address to the external IP address so it seems: http://49.136.8.183: 8000 /

Note 2: The Internet service provider (ISP) would probably change the external IP address from time to time. If so you may want to configure a static name of the computer DynDNS or similar service.

Note 3: Do not forget to open the input port on the router, if you have one.

Windows Password Cracking

This is very easy to change a system password without knowing the old password using DOS.

as follows.

Step 1: Click Start, click Run

Step 2, type cmd and press enter.

Now you are on a black command prompt window ...

Step 3-.Suppose want to change the password of the administrator's account

Type this command

* Net user admin

then press ENTER.

Now ask the new password. Enter your new password. Be aware that the password is not displayed to you while typing.then retype your password in the next step.

managed to change the system password.

This is a simple trick using cmd. But to get access to your computer, you can use it in different ways are ways.Some -

Tip 1 - Change the system password of someone using the above trick every time the opportunity to work on his / her system, and it is not there at the time

Trick 2 -. Try opening the computer in Safe Mode. If the administrator account is not password-protected login admin account and use the above command to change their password.

Third Trick This trick is very powerful. You can access the system at any time.You can change the admin password as well. Try to get some time to work on your system and follow these steps.

STEP1-go to C: \ WINDOWS \ system32

STEP2 copy cmd.exe on your desktop and rename it sethc.exe

Step 3-move this new sethc.exe in C: \ WINDOWS \ system32 replaces the previous file with this new file

After this when you want to enter the system, press the Shift key 5 times in the login screen. Now you're in cmd. Change the password of any account using the cmd above.

What if I can not access these steps to copy and move?

You can create a batch file for this copy, rename, and move step and convert exe using BAT to exe file converter. Rename this file to an EXE name of the game and give the user whose computer you want to hack.

Now you can change its system login window and login to become a new password.

*******Happy Hacking *******

To Be An Administrator In Windows Vista:

When you install or uninstall the software on Windows Vista or delete some files from Windows disk displays a dialog box asking for permission. You can remove this by the two solutions

1. Disabling UAC (User Account Control)

2. Use the administrator account

1. Disable User Account Control (UAC) - To turn off User Account Control, follow these steps

User Account Control Panel ---> ---> Enable or Disable UAC

Just pick off and reboot the system. Now you will have no problems.

2. Use an administrator account: Vista is too hidden administrator account, such as Windows XP. To activate it,

Just follow these steps:

Start ---> Programs ---> Accessories ---> Command Prompt (right click on Command Prompt and select Run as administrator)

Prompt window will open. Now, use the following command to enable the administrator account.

user administrator / active: yes

To disable the administrator account, use the following command:

net user administrator / active: no

AVG PC TuneUp 2011

Hey guys to Fix registry problems that cause freezing and crashing. Fix cluttered and corrupted registries that consume memory, slow down your applications, and cause overall stability problems.
Improve your connection with an Internet optimizer that automatically tunes your settings to speed up your online life. AVG PC Tuneup comes fully equipped with a file recovery tool so that you can recover ...files that have been damaged or accidentally deleted within Windows. Permanently delete files and wipe disks. Protect your privacy with Track Eraser. Improve your disk speed with a disk and Windows registry defragmenterthat optimizes your file system to get the most out of your hard drive. Enjoy a faster hard disk and a more stable and smooth running computer. Monitor your hard drive health and space usage.

 Download click here:
http://download.cnet.com/AVG-PC-TuneUp-2011/3000-18512_4-75449095.html

To make it full version download patch from here:
http://manishmandal.weebly.com/patch-files.html

For any softwares and patch files please comment below

Internet and Computer World: Make Backlinks For free

Internet and Computer World: Make Backlinks For free: Make Backlinks For free Hello! In this post I'm gonna show you how to make backlinks just by commenting on a site... Y...

Activation collection for windows 7

Activation Collection for Windows 7 (02.10.2011) | 281.76 MB

Complete collection of ways to activate Windows 7 - a collection of programs and ways to activate Windows 7 by DG Win & Soft. All methods and programs are checked personally by the authors build a lot of time and they can safely recommend them to you. All methods of activation in the hand being tested after the "anti-piracy" KB971033 update and activate SP1.

Download link :

http://www.filesonic.com/file/2315361421
OR
http://www.wupload.com/file/301383738
OR

https://www.rapidshare.com/files/2313246066/W.A.2.10.2011.rar

Don't forget to say thanks... :)

Enjoy..

How do you get Kaspersky Antivirus 2012 with a 90 day FREE LICENSE ?

Access the link below , download the Spanish version kit , but DON`T install it :
http://downloads-am.kasperskyamericas.com/files/90day/la/kav2012_12.0.0.374aES_2482.exe

Use 7-Zip to extract the content of the kit (kav2012_12.0.0.374aES_2482.exe) . The look for the file “setup.reg” and open it with Notepad .
Copy the registration code from there . It should be like XXXXX-XXXXX-XXXXX-XXXXX.

The download the English version kit from the link below and use the registration key previously obtained :
http://products.kaspersky-labs.com/english/homeuser/kav2012/kav12.0.0.374en.exe

How to enable registry Editor disabled by Admin ?

• What is Registry ?

        Windows registry is hierarchical database that stores configuration setting and option on microsoft windows operating system.It contains settings for low level operating system component as well as applications running on windows.

       Registry is also called as Brain of Windows which store all information in form of registry keys Technically known as DWORD or STRING or BINARY or MULTI_STRING values which stores data.

• How to enable Registry Editor disabled by Admin ?

1. 1. Open Notepad and copy below codes.

             REGEDIT4

             [HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersio

             n\Policies\System]

            "DisableRegistryTools"=dword:00000000  

         2. Now save the file as anything.reg (.reg is must)

         3. Double click the save file. 

         4. Done !!!

Transform window 7 to mac os X (THEME)

Many users wants there pc or laptop to look like mac because its look is very cool and interesting. To do this just download the file from the link given below and install it you are done .Now enjoy the experience of mac os X theme.

NOTE : Run the file as administrator. Right click on file and run as administrator.
NOTE : Password for the rar file is tricks4u

Download From Here

How To Block Facebook Applications

a. To disable these applications, select the Privacy Settings from the Account button located on the upper right corner.

b. At the bottom of the page there is Apps and Websites section and click on the Edit Your Settings link to customize the settings and select those apps from which you don’t wish to receive notifications.

c. Then you must select those apps and games from where you don’t wish any notifications from. You can select any particular apps or turn off all of them at once.

d. When you select some of them the following dialog will appear. Simply click on the Remove button to confirm your action.

You have successfully disabled your applications and you will not receive any notifications or request from these applications in future.

Tab Napping New Phishing Technique

As people were becoming more and more aware of these traditional phishing techniques and it was becoming difficult for the scammers to cheat people using these phishing techniques so they invented a new technique called “Tab Napping”.This is one of the most intelligent and wise methods of phishing and it not easily detected by a normal internet user until and unless he is aware of this phishing technique.

What is Tab Napping?

Tab napping is new type of phising scam that does not require you to click on any url to redirect you to the phishing site instead it relies on the fact that a lot of people used tabbed browsing(Opening multiple tabs while browsing).In tab napping one of your inactive tab is automatically replaced by with a new tab without your knowlege.For example one of your inactive tab in which you have opened your bank’s website will be automatically replaced with the phishing site of your bank and you will be asked to enter your username and password.You might think you have been signed out or never logged in but when you will enter the details again it will be sent to the scammer.

How To Detect And Protect Yourself From Tab Napping

Here are the simple and easy steps with which you can detect this new phishing technique “Tab Napping”.

Don’t open another tab when your are working with your banking site or any other secure businesswebsite instead open new windows using CTRL+N.
Always check the url address of the website if you return from another tab.(Fake page will have differentUrl)
Check that the url has secure address “https:// “ or a big green bar in front of the url in address bar which certifies that it is secure and certified website.
If you find anything suspicious close the tab and type and open the website in new Tab.

Make Free Calls to Any Number In World

Well this is not any hack of mobile services but instead a legitimate way of making a free call to any number in world.This can be a real helpful if you do not have any account balance in your mobile and you need to make a urgent call.This is the right time movibox can help you out.

You will get free calling time of 5 minutes and you can call with it anywhere in world to any mobile number.To make a call click on Direct call Button after you register a account with them.

Firesheep:Trick to Hack Facebook and Twitter Password on Wifi:

Do you access your Facebook or Twitter account while you are on a public network like your college’s or office’s unsecured wifi.Then this is the time that you should think about your account security.If you think that facebook or Twitter are secured websites then it’s the time to face the reality they are not secured.Whenever you login into your facebook or twiiter account check the address bar of your browser you will see something like http://www.facebook.com/home.php? Similar is the case with twitter.They use http protocol instead of secured https protocol.But if you login into your gmail account you will notice that it uses https protocol.

So, the trick I am telling you works only on websites like facebook,twiiter,flickr but not on secured websites like Gmail.So here is Trick to Hack Facebook and Twitter Password on Wifi and also the method of protection from this hack.This trick doesnot require any programming knowlege and everyone can use this trick easily.

- Download firesheep Firefox extension.This is a freeware extension for firefox browser.

- Once installed it will open a sidebar window into your firefox browser.

- Now it will show all the people who are connected to unsecured wifi network.Once they login into your facebook or twitter account you will get a notification and with a single click you can login into their account.

This whole thing work on the technique of cookie hijacking.Once your session cookie is hacked then anybody can login into your account.These cookies can be easily caputered on unsecured wifi network.

The best way to protect yourself from such a hacking trick is to avoid using your facebook or twitter accounts on unsecured wifi networks as it is a security lapse from the websites not on your side

Trick to Check Who Has Un-Friended You on Facebook:-

- First of all Enable Timeline Feature in your Facebook Account.

- Now open your profile and click on the year in which you want see the people who unfriended you.

- Scroll down the cursor till you find Friends column where you wil see list of new friends you made in that particular year. Like in this screenshot you can see I Made 32 New friends.

- Click on it and all your friends will be shown in a new pop-up window and if you find Add as Friend option next to any person it means he has un-friended you.

You can check all the years one by one to find out how many of your friends have un-friended you.

How to Burn a Data CD or Data DVD in Windows 7 Using Media Player?

You can burn a data CD or data DVD in Windows 7 using Media Player. An audio CD can contain just approximately eight minutes of music. On the other hand, if you burn a data CD or data DVD in Windows 7 using Media Player, it will be able to hold numerous hours of music. Video files and pictures can also be added to the data discs.

Advantages

 When you burn a data CD or data DVD in Windows 7, the Windows Media Player does not transform the selected files to a different format prior to saving them to a blank data disc, so the files stay in the compressed condition. This allows you to put much more items on a single disc.

 As the format of the files is not changed, the quality of the files remains the same. 

You can burn a data CD or data DVD in Windows 7 using Media Player as follows:

•  Click Start.
•  Click All Programs.
•  Select Windows Media Player.
•  Click the Burn tab in the Player Library.
• Click Burn options and select Data DVD or CD.
•  Insert a blank disc into the CD or DVD burner of your computer.
• Close the AutoPlay dialog box if it comes into sight.
•  Some people have more than one CD drive in their computer. If you have multiple CD drives in your computer too, select the one you would like to use in the navigation window.
•  Look for the songs you want to burn.
•  In order to make your burn list, drag the songs from the details pane in the center of the Player Library to the list pane which is on its right side.
•  You can also change the order of the items in the burn list by dragging them upward or downward in the list. 
•  To remove a song from your list, simply right-click on the item and click on Remove from list.
•  After you finish making your list, click upon Start burn.

It can take a while to burn a data disc. If your selected items cannot fit in one disc, you also have the choice of burning the rest of the items to a different disc. A data DVD is not the same as a DVD-Video disc e.g. the movie DVD you buy or rent from the store.

How to create a shortcut for locking the Computer Screen in Windows 7?

There are many ways in which you can lock the computer screen. The most popular as well as the fastest way to lock it is to use a keyboard shortcut. The keyboard shortcut used to lock the computer screen is Win+L. A few of us choose to utilize the mouse to lock it. And of course many people like to use both the options.

There is another method in which we can lock the computer screen. It is to create a shortcut for locking the computer screen in Windows 7. You can create a shortcut for locking the computer screen in Windows 7, XP and Vista too. Follow these steps in order to create a shortcut for locking the computer screen in Windows 7 as well as other editions:

Right-click on the desktop where you would like to create the shortcut.
Point to New.
Click on Shortcut from the menu.


Type in this text in the shortcut textbox. (This text will work for Windows XP as well even though the screen will be different)

rundll32.exe user32.dll, LockWorkStation



Click on the Next button.
Type in a name for your shortcut.
Click on the Finish button.  
You have successfully created a shortcut to lock your workstation. Just click on the shortcut whenever you want to lock the computer screen.

How to Access Hidden Themes in Windows 7?

Windows 7 offers a good assortment of themes to customize the feel as well as the look of your computer. Windows 7 features particular themes which are based on the location and the language you select while you install the Windows 7. You can look for the location-specific theme in the Personalize menu. You just have to right-click at any place upon your computer desktop. You will be able to get the couple of themes according to your location.


Other than the location specific themes which you get by default, you can access hidden themes in Windows 7 which are offered to other regions. So the default themes which you get according to your region are not the only themes you can use. It is possible to access hidden themes in Windows 7 very easily in your system. This is what you have to do:
 
Click Start.

 In the search box of the Start menu, type C:\Windows\Globalization\MCT.


Your Windows Explorer will show you a window with additional themes. These will be from Great Britain, South Africa, Australia and Canada.



You have the option to select the wallpaper only or you can install the whole theme if you want.



You will be able to install the entire brand-new theme by double clicking on the required file.



The new theme you add will show under “My Themes” within the “Personalization” pane.



You can also download many themes for Windows 7 from different website including the Microsoft official website. But you should first try to customize and access hidden themes in Windows 7 as you might not feel the need to download additional themes from elsewhere after that..

How to disable search history display in Windows 7?

Windows 7 automatically saves all the recent searches done by the users. Some people are annoyed by this feature as the last three searches become visible under the search box as you start typing in it. If the computer is shared by others, you might not want others to see your past searches. There is a way in which you can disable search history display in Windows 7. However, you cannot disable search history display in Windows 7 Home editions. This is due to the fact that you need to utilize the Group Policy Editor for achieving this goal and it is not available in the Home versions. Follow these steps to disable search history display in Windows 7:

Enter gpedit.msc in the search box of the Start menu. Press Enter. This will open the Local Group Policy Editor.

Scroll down to User Configuration \ Administrative Templates \ Windows Components \ Windows Explorer.

Double-click on Turn off display of recent search entries in the Windows Explorer search box on the right hand side of the dialog box.

Select Enabled and click on the Apply button.

Click on the OK button.

Close out of the Group Policy Editor.

From now on, you won't be bothered by the display of recent search history as you start typing into the search box.

View previously open Folders after Shutdown or Logoff

If you need to access lot of folders on your home computer or on the network regularly then you can set them re-open automatically, when you will login, shutdown or restart your computer next time. There is no need to open regularly used folders manually, just configure the simple sitting, your computer will automatically reload all the previously opened windows.

By default windows XP disables this option to reload automatically all the previously opened windows, when you login on, shutdown or restart your computer.

Follow the given steps to configure your computer to reload previously opened folders automatically after shutdown. 

• To edit this feature, you will need to be logged into your computer with administrative rights.
• First click on Start button then go to Control Panel. 
• Open the “Appearance and Themes” option in control panel then click on Folder Options. 
• A small windows dialog box will appear with the title “Folder options”, click on View tab.
• Under the Advanced setting section, scroll down to bottom and click the “Restore previous folder windows at logon” option and then click Ok button to save sitting.
• 
• Now when you log off, restart or shutdown, your computer will automatically open the previously opened folders from the same location as before.

How to find a lost file on your Computer?

Today tip will help you to enjoy the quick and easy way to find lost files on your computer. Here I recommends you, try to search a file with its file extensions (for example for word file, type *.doc, Excel *.xls, Acrobat *.pdf, *.ppt and *.exe for executable files. If you don't know the name of file but know that it contains a string of text then try to search for files containing specific text, type the text you want to find from any file or folder. This is time taking process but creates very precise result. In Look in, click the drive, folder, or network you want to search. To save time, always select the specified drive or location instead of whole computer.

Click Start Button, point to Search, and then click For File or Folders, a Search Results dialog box will appear. In Search for files or folders named, type the file name or folder name you want to find in containing text.

To specify additional search criteria, click Search Options, and then click one or more of the following options to narrow your search:

• Select Date to look for files that were created or modified on or between specific dates.
• Select Type to look for files of a specific type, such as a text or WordPad document.
• Select Size to look for files of a specific size.
• Select Advanced Options to specify additional search criteria.
• Click Search now.

How to login with multiple ID's at the same time in Yahoo messenger?

If you have multiple yahoo ID's and wants to login with more than one yahoo ID at the same time then don't worry, you can login with more than one yahoo ID at the same time using this tip. There is no need to install any other yahoo multi messenger version, you can easily covert your normal yahoo messenger into multi messenger and enjoy your many ID's at the same time.  

Follow the given steps to change the yahoo messenger registry value:

• Click Start button and type regedit in Run option then press Enter for next.
• 
• Here locate the location to:
• HKEY_CURRENT_USER/Software/Yahoo/Pager/Test
• 
• Here in right side panel, right click to create a new Dword value with name Plural and give it value 1.
• 
• Now close the registry editor and restart your computer after any changes to go into effect.
• For signing in with new YAHOO ID open another messenger open as many messengers you need.
• If you want to disable the multiple messenger option then again open registry editor and change Plural value 1 to 0.
• 

How to disable auto-start applications on windows startup?

Using this tip, you can minimize the startup time of windows XP and Vista also. You can disable some optional windows applications like windows messenger, Yahoo messenger, QuickTime and many others auto startup programs that run automatically when you start your computer.

Follow the given steps to disable the windows auto run applications: 

To use this feature, you will need to be logged into your computer with administrative rights.

Click Start button and type msconfig in Run option then press Enter for next.
A small System Configuration Utility dialog box will appear with many options like General, System.ini Win.ini, Boot.ini, Services, Startup and Tools.

Now select Startup tab and uncheck the applications that you want to disable from windows startup.

Now click on Apply button to implement the changes then click on Ok button to end the configuration process.

Again close the all program and restart your computer after any changes to go into effect.

How you can Change The Recycle Bin's Name?

You can change the name of Recycle Bin of your system if you wish. It is very easy and interesting but it require some changes in windows registry,  

• First click on Start button > click on Run option.
• Type here regedit.exe and press enter then you will find there regedit editor.
• In regedit editor you will open HKEY_CLASSES_ROOT folder, In this folder open the CLSID folder then open the {645FF040-5081-101B-9F08-00AA002F954E} folder >ShellFolder folder at last.
• Here simply change the data value from "40 01 00 20" to "70 01 00 20".
  After performing all above steps restart your computer then you will find option to rename Recycle name after right clicking on Recycle Bin Icon. Now you can change new name as you wish.

How to restore the windows XP to a previous working state?

Today tip is very useful to recover the windows XP problems and then restore it in previous working state.
You can recover the windows critical components and return your computer to earlier state without loss of
personal data using windows XP built-in system restore feature. With new programs being installed,
viruses infecting and spyware creates problem in your browsers it is not unusual for your computer to
suddenly stop behaving correctly. So you can perform the windows recovery process and return your
computer to earlier state within a minute. 

Follow the given steps to run System Restore wizard:

To use this feature, you will need to be logged into your computer with administrative rights.

First click on Start button> All programs> Accessories> System Tools then click on System Restore.

Now a "Welcome to System Restore" wizard will start, first read the detail instruction on left side of the page.

How to change the boot Time in window XP?

You can set the boot time in windows XP as your wish if you are install two operating systems on same computer, for example window 2000 with windows XP or more than two. Yow can do this with editing  Boot.ini file. Here you can also set  the sequence for operating system which operating system boot first.

First Right Click on My Computer option and then select its Properties. In next dialog box open Advanced tab button. Under Startup and Recovery, click on the Settings button. Use the spin box "Time to display list of operating systems" to set the number of seconds you want the system to wait before automatically starting the default operating system. Here you will set time in seconds and its range start from 0 and ends with 999 seconds.

After set the time, then click OK option to close the dialog box to save your change. The next
time you restart, the new time will take effect.

Main Functions and Formula used in Excel.

There are many pre-defined functions in Excel but the most important pre­defined functions are:

• SUM function.
• AVERAGE function
• MAX function
• MIN function
• PRODUCT function
• IF function

SUM Function

It is used to add numbers given as parameters. These may be numeric values or cell references. Its general syntax is:

 

SUM(numberl,number2, .,.) Where

 

numberl, number2,... :           specifies arguments which you want to add. 

                                               Example, = SUM (3, 2) returns 5. Similarly,
                                          to add values of cell range Al to A30,
                                             the function is written as:

=SUM (A1:A30)

AVERAGE Function
It is used to calculate the average of values given as parameters. These may be numeric values or cell references. Its general syntax is:

AVERAGE (numberI, number2, ...) Where

numberl, number2,... :                specifies  arguments   for   which   you   want   to
calculate average. For example. AVERAGI. (3, 2) returns 2.5. Similarly, to calculate average of values of cell range Al to A30. the function is written as:

=AVERAGE(A1:A30)

 MAX Function

It returns the largest or maximum value from a list of values. The parameters may be numeric values or cell references. Its general syntax is:

MAX (numberl, number2, ...) Where

numberl, number2,... :        specifies arguments from which you want to find  maximum, for example, =MAX(3. 2,45,23) returns 45.

MIN Function

It returns the lowest or minimum value From a list of values. The parameters may be numeric values or cell references, its general syntax is:

MIN(number 1, number2….) Where

numberl, number2,... :      specifies arguments from which you want to

find minimum. For example, =M1N(3, 2,45,23) returns 2.

PRODUCT Function

It is used to multiply numbers given as parameters. These may be numeric values or cell references. Its general syntax is:

PRODUCT (number1 ,number2, ...) where

numberl, number2,... :      specifies arguments which you want to multiply. For example, =PRODUCT (13, 2) returns 26. Similarly, to multiply values of cell range Al to A30, the function is written as:

=PRODUCT (A 1:A30).

How to convert older Office documents to Office 2007 format?

The Office 2007 applications such as Word and Excel can open a spreadsheet or a document which is in an older edition of Office.  They can open such older version documents in Compatibility Mode. However, if you need to make use of various newer features available in Office 2007, you will have to convert older Office documents to Office 2007 format. The feature to covert older Office documents to Office 2007 format is very useful. For example, you can now utilize 1.1 million rows in the 2007 version of Excel. In the older versions you could only use sixty-five thousand rows.  The method to convert older Office documents to Office 2007 format is the same for all applications. Here we are using the example of a Word document of previous version. If you open a Word or Excel document of an older version, you see [Compatibility Mode] as part of the title.

Follow these steps to convert older Office documents to Office 2007 format:
Open the Word document which you want to convert into Word 2007 format.

Click on the Microsoft Office button on the top left.
Click on Convert on the left hand side of the menu.

Click on the OK button on the Microsoft Word Office dialog box which appears.

By clicking on the OK button, the document will be automatically converted into the Word 2007 format. You will notice that now the window does not show [Compatibility Mode] as part of the title bar any longer.

How to quickly repair your Mobile Phone dropped in water?

Many of you get your mobile phone wet by one way or another. You worry as you mistakenly drop your mobile phone in water. It can also get wet if you are out in a heavy rain.  However, there is no need to panic. It is possible to save your wet mobile phone by quickly repairing it. In order to save your mobile phone from water damage, you can consider these easy and simple solutions:

Act rapidly :

The first thing you have to do in order to save your wet mobile phone is to act rapidly. Quickly remove all the detachable parts as well as covers possible such as the back cover, battery, the SIM card, memory card etc. Next, take a piece of cloth or a tissue paper to wipe the excess water you are able to notice within the mobile phone. Make sure that you dry it completely. If you don' t do this, the water inside the mobile phone will begin to evaporate and gather in places which will be difficult to reach.

This will save your wet mobile phone and it will start working if it was under water for just a little while.

Using a hairdryer :
Take a hairdryer and begin drying the mobile phone while giving more consideration to the place where the battery is located. The battery housing usually consists of tiny holes to let in air (so giving more space for water) inside the mobile phone.
Make sure that you are not holding the hairdryer very near to the mobile phone. Keeping it too close to the mobile phone may harm the electrical mechanism of the mobile phone. Keep on drying the mobile phone from a safe distance for about twenty to thirty minutes.

If solution number 1 and solution number 2 don't work, try solution number 3. 

Drying for a long time:
Take off the covers as well as battery from the mobile phone. Put the phone in a dry as well as warm place to let the water inside the phone evaporate gradually from the little holes in the mobile phone

Enjoy with Internet Explorer shortcut keys

Normally a computer user spending his maximum time daily with internet browsing different sites. But if you are familiar with internet explorer shortcuts keys, you can increase your browsing speed and can handle many online browsing restrictions very easily.

Here are some common internet explorer shortcut keys.

• Press F5 to refreshes the webpage.
• Press Backspace button back to the previous page.
• Press Alt+Home button same time to go home page of the website.
• Press any time Ctrl+N to open the new browser windows.
• Press F11 key to view any webpage in full-screen view and then again press for normal view.
• Press Ctrl+P keys to send the print command for current whole page.
• Press Ctrl+H keys to view your browsing history.
• Press Ctrl+w keys to close the current browser window.
• Press Esc button to stop any page browsing.
• Press Ctrl+Enter Windows will automatically add both "www" and ".com". For example, if we type

        computerfreetips 

        in an address bar and then press Ctrl-Enter, Windows will take us to the

Clear History and Temporary Internet Files

When you are browsing the internet, the Internet browser cached some file on the system as temp files for later use. Specially if your are viewing some private but your web browser will store all your information (visited websites) as a history and your co-workers, family members can trace your activates on the internet with clicking of toolbar history button or with simply press Ctrl+H. If your are using internet at any public place like internet cafe then you should clear your temp file history to safe yourself from cyber crimes.

• If your are using Internet Explorer and wants to delete the history, then first open your Internet Explorer.
• Click on Tools Menu then go to Internet Options. Here in General tab you will find the Delete Cookies and Delete files tab in the center of the screen.
• First click on Delete Cookies option to delete all the cookies in the temporary files folder and then click on Delete files option to delete all the offline temporary files.
• Now click on the Clear History button to clear your recently visited sites. You can set days to keep pages in history here. Be default it is 20 days, but you can change it from 0 to 99 days. If you set it 1 days, the system will clear your browser history automatically after one day.
• Click on Ok button to save your changes.

What is a Web Accelerator ?

Today a special tip for those who are still using any slow dial-up internet connection due to unavailability of any broadband connection in their area. The Web Accelerator application designed to provide the full acceleration for your routine web sites browsing. With the help of Web Accelerator you can browse your internet 4 to 6 times faster than normal dial-up connection. Basically this services compressing the website text data, images and heavy graphics to open or download this data with high speed. This technique is more useful for static websites and for email applications but don't accelerate with secure and downloading audio or video files. Some good web accelerator retains your system cache to reuse websites with faster speed and can also block windows pop-up. If you are using FTP sites and downloading any program using dial-up, then web accelerator is not for you. There are various web accelerator software are free available on internet, visit and download it to enjoy your connection.

Searching Information tips using Search Engine

If you want to get some information about any topic using search engine, the search engine will search the given information and will provide a list of links of websites along brief description about each website. You should use the right search terms for relevant results.
The following points must be noted to search the information on the internet.
You can type all word in lowercase and also in uppercase, search engine will return the same result.
But the best practice is type search keywords always in lowercase.

• Use + sign between words if you want to search the all words. For example, to search history of Football in Europe, type as:

        history+Football+Europe

• To search the exact match, write the words in double quotation marks. For example to search the map of Europe, then type as:

        "Map of Europe"

•     Always avoid to use "and", "or" with search keywords, because these words will affect the search result.

How to avoid fake Security Warnings or pop-up?

When you are browsing the internet and suddenly a window pop up with different messages for example" free update for your computer ","scan your computer with free antivirus". May be some pop-ups messages helpful for you but you should read first in detail before clicking it. Pop-ups basically an advertiser message or unwanted program and website that might be disturb your computer performance.

If you are working with Internet Explorer and want to block the pop-ups windows and unwanted messages. Open the Internet Explorer and click on Tools menu and go to Pop-up Blocker option, here you can Turn Off Pop-up Blocker to block pop-up from all websites. But you have option to allow some websites for pop-up. For this purpose open the Pop-up Blocker Setting. Here you can add some specific websites name to allow for pop-up and click Add. If you feel any problem to block any pop-up message due to some problem, simply click on the X at the right top of the pop-up windows.

Tips to Print the Whole Page

If you are browsing any website and want to print it in readable form without any extra graphics. There is a option on many websites " Print " to print a page in text format only, otherwise you can print out any webpage with its background colors and with out background colors using Internet Explorer setting. Generally Internet Explorer setting  "Print background colors and images" is disable, if you are printing webpage without background colors, then you can speed up your printing and save printer ink. But important thing to always preview WebPages before you print, in Internet Explorer go to File menu, then click on Print Preview option.

To enable or disable print background colors option, open your system Internet Explorer.
Click the Tools menu and then go to Internet Options and open it. Here click the Advanced tab then scroll down to find the option Printing section.
Now check the option "Print background colors and images" then Apply and ok.