google docs spreadsheet tips

Get the difference between two dates:

In the following, G2 is a date (e.g. 12/31/2013), B2 (is a starting time [HH:MM:SS]), C2 (is a ending time [HH:MM:SS])

=(to_date(CONCATENATE(G2," ",C2))-to_date(CONCATENATE(G2," ",B2))) * 24

Truncating number of decimal places:

If cell H2 contains "0.016666666666667" then using =trunc(H3;3) will result in 0.016.

If cell H2 contains "0.016666666666667" then using =trunc(H3;2) will result in 0.01.

Rounding number of decimal places:

If cell H2 contains "0.016666666666667" then using =round(H3;3) will result in 0.017.

If cell H2 contains "0.016666666666667" then using =round(H3;2) will result in 0.02.

Read More..

Google Buzz Social Networking WebsiteGoogle Buzz –Social Networking Website

“
Google Buzz is an extension of the Google Mail service offered by Google which the Internet giants hope will lure users away from alternative services such as Facebook.
Google Mail initially created shockwaves when first introduced as they offered a huge 1GB of storage space for messages and attachments compared to most of its competitors who at the time offered a feeble 2 to 4MB.  Today they offer a huge 7GB as standard however times have moved on and alternative providers such as Yahoo Mail and Hotmail also now offer an almost unlimited amount of storage space free of charge.
Despite not having the advantage over the competition in this respect any longer,Google Gmail continues to be a popular service due to its ability to integrate well with other e-mail accounts and the way in which it allows you to manage your messages.  As an example,Gmail groups together messages that are of the same subject,making them part of a conversation file.  In this way you can manage large number of e-mails grouped into the same conversation quickly and easily so that deleting or achieving them doesn’t cause a headache.

Google Gmail is free to use and paid for by advertising however the adverts are very small,non-intrusive and are targeted so that they are more relevant to subject matter that you might find of interest.  There are no large graphic adverts and no pop-up or pop-under adverts to clutter your browser.
Google Buzz is a social networking application integrated into Gmail.  It aims to offer a better method to share photos,links,videos,and events with your Gmail contacts and personally I believe it is rather coincidental that this was developed after Facebook announced plans they were developing their own email system.
Buzz has all the basic features that you would expect from a social networking application including the ability to share status updates,photos,links and videos both privately and publically.  You can choose who you’d like to follow by simply entering their Gmail address at which point they can be added as a friend for you to see a steam of all their updates that have been shared either publically or privately with you.  As with Facebook,other users can comment on public posts and show their appreciation for an update or users status by clicking the ‘like’ button.
You can direct a comment into a fellow users Gmail inbox by simply putting @ the beginning of your comment and the user name of that person is then hidden to protect their privacy.  This feature can only be used with people that are in your Gmail contact list.  Also by clicking on the arrow to the right of any post,you can link content to the post,email the contact directly and mute the buzz that appears in your inbox.
Google Buzz also integrates with Picasa,Flickr,Google Reader,YouTube,Blogger,and Twitter meaning that you are able to share content from these applications directly.  This is a nice feature as it allows you to post files and albums you may have already created without having to go through the hardship of creating them twice.
The social networking market has the potential for huge rewards,especially for a company such as Google that makes such a large amount of its profits from revenue generated by advertising.   With news that Buzz will soon be available on the Android phone and iPhones platforms,it will almost certainly give the more established social networking sites a run for their money.
“

Read More..

AdSense optimization tips straight from Google

Do you use Google AdSense to monetize your site? Then check out these top 5 optimization tips straight from Google!

Top AdSense Optimization Tips

1. Maximize your AdSense coverage

In order to maximize your earnings, place three AdSense ad units and three link units on each of your pages. The more ads you display, the more opportunities you have for your users to engage with them.

Also, because some ads are paid on a cost-per-impression (CPM) basis, you will often be paid just for displaying the ads, regardless whether a user clicks on them.

2. Place your ads above the fold

Ads that appear higher on the page perform the best. Place your ads so users can see them without scrolling down the page. The more a user has to scroll before finding your ads, the less likely they are to see them and to click on them.

3. Use the best performing ad units

Our advertisers’ preferred ad units are the Leaderboard (728×90), the Medium Rectangle (300×250) and the Wide Skyscraper (160×600). By using these popular ad units, you’ll be tapping into a larger pool of competing ads. More ad inventory leads to more competition in the ad auction and ultimately results in higher RPMs for our publishers.

4. Show text and image ads

Check your ad units and make sure that you’ve opted-in to displaying text and image ads. By diversifying your ads, you’re able to increase the available inventory for your site. With most text ads paid on a cost-per-click (CPC) basis and most image ads paid on a cost-per-impression (CPM) ad, you can let AdSense determine which ads will maximize your earnings.

5. Complement your content with your ads

Your AdSense ads should fit seamlessly within your site to improve your users’ experience. Blend the color of your ads to match the rest of your site and remove the borders around your ad units to help your ads complement your content and enhance your site.

Bonus Tip: Opt-in to Placement Targeting

Set up Custom Channels in your AdSense account and opt-in to Placement Targeting. Placement targeting allows our advertisers to bid on a specific ad or group of ad placements on your site. Advertisers are usually willing to bid more for targeted units.

Have additional questions? Check out http://adsense.google.com/support

And that’s it. At the end of the day, its all about testing your ads and monitoring how they perform for you on your site. Good luck!

Read More..

Advanced Google Search

Google is clearly the best general-purpose search engine on the Web.But most people don’t use it to its best advantage or in an advanced way. Do you just plug in a keyword or two and hope for the best? That may be the quickest way to search, but with more than 3 billion pages in Google’s index, it’s still a struggle to pare results to a manageable number. There are some ways in which advanced Google search can be used to get the desired results.

But Google is an remarkably powerful tool that can ease and enhance your Internet exploration. Advanced Google search options go beyond simple keywords, the Web, and even its own programmers. Let’s look at some of the advanced Google search options.

Syntax Search Tricks
Using a special syntax is a way to tell Google that you want to restrict your searches to certain elements or characteristics of Web pages.Here are some advanced Google search operators that can help narrow down your search results.
1.Intitle: at the beginning of a query word or phrase restricts your search results to just the titles of Web pages.

2.Intext: does the opposite of intitle:, searching only the body text, ignoring titles, links, and so forth. Intext: is perfect when what you’re searching for might commonly appear in URLs. If you’re looking for the term HTML, for example, and you don’t want to get results such as
www.tipsz.blogspot.com/
you can enter intext:html

3.Link: lets you see which pages are linking to your Web page or to another page you’re interested in. For example, try typing in link:http://www.tipsz.blogspot.com/

3.site: (which restricts results to top-level domains) with intitle: to find certain types of pages. For example, get scholarly pages about Mark Twain by searching for intitle:”Mark Twain”site:edu. Experiment with mixing various elements; you’ll develop several strategies for finding the stuff you want more effectively. The site: command is very helpful as an alternative to the mediocre search engines built into many sites.

Swiss Army Google

Google has a number of services that can help you accomplish tasks you may never have thought to use Google for. For example, the new calculator feature
(www.google.com/help/features.html#calculator) lets you do both math and a variety of conversions from the search box. For extra fun, try the query “Answer to life the universe and everything.”

Suppose you want to contact someone and don’t have his phone number handy. Google can help you with that, too. Just enter a name, city, and state. (The city is optional, but you must enter a state.) If a phone number matches the listing, you’ll see it at the top of the search results along with a map link to the address. If you’d rather restrict your results, use rphonebook: for residential listings or bphonebook: for business listings. If you’d rather use a search form for business phone listings, try Yellow Search
(www.buzztoolbox.com/google/yellowsearch.shtml).
Let Google help you figure out whether you’ve got the right spelling—and the right word—for your search. Enter a misspelled word or phrase into the query box (try “thre blund mise”) and Google may suggest a proper spelling. This doesn’t always succeed; it works best when the word you’re searching for can be found in a dictionary. Once you search for a properly spelled word, look at the results page, which repeats your query. (If you’re searching for “three blind mice,” underneath the search window will appear a statement such as Searched the web for “three blind mice.”) You’ll discover that you can click on each word in your search phrase and get a definition from a dictionary.

Extended Googling
Google offers several advanced services that give you a head start in focusing your search. Google Groups (http://groups.google.com/)

indexes literally millions of messages from decades of discussion on Usenet. Google even helps you with your shopping via two tools: FroogleCODE(http://froogle.google.com/),

which indexes products from online stores, and Google CatalogsCODE(http://catalogs.google.com/),

which features products from more 6,000 paper catalogs in a searchable index. And this only scratches the surface. You can get a complete list of Google’s tools and services at
www.google.com/options/index.html

You’re probably used to using Google in your browser. But have you ever thought of using Google outside your browser?
Google Alert
(http://www.googlealert.com/)

monitors your search terms and e-mails you information about new additions to Google’s Web index. (Google Alert is not affiliated with Google; it uses Google’s Web services API to perform its searches.) If you’re more interested in news stories than general Web content, check out the beta version of Google News Alerts
(www.google.com/newsalerts).

This advanced Google service (which is affiliated with Google) will monitor up to 50 news queries per e-mail address and send you information about news stories that match your query. (Hint: Use the intitle: and source: syntax elements with Google News to limit the number of alerts you get.)
Google on the telephone? Yup. This service is brought to you by the folks at Google Labs
(http://labs.google.com/),

a place for experimental Google ideas and features (which may come and go, so what’s there at this writing might not be there when you decide to check it out).

With Google Voice Search
(http://labs1.google.com/gvs.html),

you dial the Voice Search phone number, speak your keywords, and then click on the indicated link. Every time you say a new search term, the results page will refresh with your new query (you must have JavaScript enabled for this to work). Remember, this service is still in an experimental phase, so don’t expect 100 percent success.
In 2002, Google released the Google API (application programming interface), a way for programmers to access Google’s search engine results without violating the Google Terms of Service. A lot of people have created useful (and occasionally not-so-useful but interesting) applications not available from Google itself, such as Google Alert. For many applications, you’ll need an API key, which is available free fromCODE www.google.com/apis

Read More..

How to increase Google adsense Profits From Your Website

Adsense is Really Making waves and Making its presence felt especially on the affiliate industry. The result of this is that most of the weak affiliate merchants have disappeared. Likewise ad networks are beginning to lose their customers due to Googles Adsense.

If you are a web site owner and youre losing more rather gaining using affiliate programs that you are advertising then I guess its high time that you consider shifting to adsense marketing and start earning which is what you should be doing in the first place.

The best thing about Google is that the adsense that they will put on your site are carefully chosen to match the content on your pages, which is good since your web visitors have a much better chance of clicking on them since they are related to the information that they have search on your site.

Another benefit that you derived from this is that it enhances further the usefulness of your site since other related information that are not found on your site is conveniently supplied by Google through its adsense. This is actually just one of adsense trick.

With Googles adsense you will no longer have to waste time and effort in choosing various types of ads for the different pages of your site. Google has made everything easy as well as convenient for you. There are no difficult codes to deal with all you get are ads that are carefully chosen to match every contents found on your site.

This will provide you with lots of time to do other important things like creating better and quality contents since most of the search engines considered contents as one of their basis in choosing the sites where they are to put their ads.

Another great thing about Google adsense is that even if you have already existing affiliate links on your site your site will still be allowed to add adsense ads. This means that you will be able to still earn from adsense ads. Plus you may even customize the adsense so that it will appear as part of your web page. You use Googles custom palette for such an endeavor.

The rationale behind matching the adsense to the theme of your site is that most of the web visitors today are used to clicking on a link that is blue. By having your Google adsense to match the theme of your web page will make it looks like a part or portion of your content. This adsense trick is ideal since it will make the web visitors to click on it thinking that its just a link to another page of the web site.

Aside from that you will also be able to filter out those URLs that do not meet your guidelines. You may also block your competitor from advertising on your site. Bear in mind that the fact still remains that adsense is somewhat competing for some space on web sites that all other revenue generating ads are sharing.

With adsense on your web page together with your content people will definitely flock on your site sicne yo have everything that they need. In the long run having an adsense on your site will both benefit you in terms of increase in revenue as well as increase in your web sites hits.

Read More..