Sunday, 24 February 2013

Define names and use them in Microsoft Excel

Define names and use them in Microsoft Excel


Microsoft Excel allows any cell to to have a defined name, which makes creating and pointing to that cell a lot easier. For example, in a traditional formula you may subtract the value in cell A1 from B1 by using the formula =sum(A1-B1) in cell C1. However refrencing these cells and using them in a formula could be made easier by defining the name of cells C1 and B1. For example, cell A1 could be named "total" and cell B1 could be named "tax", which means the same formula in C1 could be =sum(total-tax) to get the total.

To create a defined name for any cell right click the cell and choose Define Name, once clicked a New Name window, like the one shown below should appear. Fill out the name you want to use and click Ok.



Top 10 Google Chrome tips


Know your keyboard shortcuts


Like any good browser, Google Chrome has several dozen different keyboard shortcuts that can help improve your productivity. Below is just a few of our top favorites.

Ctrl + 1-8 = Pressing Ctrl and any number 1 through 8 will move to the corresponding tab in your tab bar.
Ctrl + 9 = Switch to the last tab.
Ctrl + H = Show history
Ctrl + J = Open Downloads window
Ctrl + K = Move the cursor to the Omnibox (address bar)
Ctrl + T = Open a new tab

Full listing of Google Chrome shortcut keys

Top 10 unknown Google tricks

Below is a list of our top ten Google tricks many people who use Google don't know about.


Definitions
Pull up the definition of the word by typing define followed by the word you want the definition for. For example, typing: define bravura would display the definition of that word.

Local search

Visit Google Local enter the area you want to search and the keyword of the place you want to find. For example, typing: restaurant at the above link would display local restaurants.

Phone number lookup

Saturday, 23 February 2013

Click and earn

Interested in earning some extra money ,you can earn simply by viewing all the advertisements.This is simple just click on following link 
It gives you .

- Effortless income
- Earn from home
- Guaranteed ads daily
- Detailed statistics
- Upgrading opportunities
- A dedicated community

Thursday, 9 August 2012

How to open search results in new tabs in Firefox or Chrome


You'd think setting up Firefox or Chrome to open search queries in a new tab would be a simple settings tweak. You'd be wrong.



If you use the Google search box in firefox or the address bar in Chrome, which doubles as a Google search box, for Web searches, you will notice that the results page opens in the tab you are currently viewing. If you are conducting some extensive online research, you might find it easier to keep track of your search results if each time you searched the results opened in a new tab. For Firefox, you will need to get into the inner working of your browser, while Chrome requires an extension.
For Firefox, open the browser and type about:config in the address bar and hit enter.
Next, click the button promising to be careful when greeted by the warning message.
 
On the next page, find the line browser.search.openintab. On the right most column titled Value, you will see "false" listed. Double click it to turn it to "true."
 
Now, when you search for a term using the Google search bar in Firefox, your search results will open in a new tab.

For Chrome, you will need to install the Chrome Toolbox extension. And unfortunately for Mac users, this extension is severely limited and doesn't include the setting that allows you to open search queries made in Chrome's address bar in a new tab. PC users, keep reading.
After the extension installs, you will see that a small button (complete with a flaming gear icon) gets added to the right of the address bar. Click on the button and choose Options.
 
On the General tab of the Options window, find the last item listed under the Tab header. Check the box for "When pressing enter in address bar with a URL in it, open the URL in a new tab."
Now, a URL -- or any word -- typed into Chrome's address bar will open in a new tab.