Thursday, May 5, 2011

50 Fantastic Google Spreadsheet Shortcuts for Students

Hello Folks!!!
On May 4 2011, I got a mail from Jasmine Hall. And She asked me to post me "50 Fantastic Google Spreadsheet Shortcuts for Students".  She asked me "On a related note, we recently published an article that you might want to share it with your readers." I agreed to her and as a result I am posting the content that she referred. It not actually only a SEO or SMO resource. Its Google Spreadsheet Shortcuts for students. The original content is @ http://www.onlinecollege.org/2011/05/03/50-fantastic-google-spreadsheet-shortcuts-for-Students/ Here we go:-


If you're a busy college student, the more ways you have to accomplish things quickly, the better. That's where things like keyboard shortcuts can come in handy, especially when you're trying to enter data efficiently and professionally into a spreadsheet, like those offered on Google. Here are some shortcuts and tips you can use to improve your Google spreadsheets skills, get homework over with, and go back to having fun, just being a college student.
Features
Here are some amazing features that you might not have even known were offered through Google Spreadsheets.
  1. Fill themselves in. Using Google Forms, you can email questions and data to others and it will automatically fill in your spreadsheet, making it very easy to collect information.
  2. Revert to an earlier version. If you're sharing access to a document in Google spreadsheets, you might want to go back to an earlier version before someone made changes. The program makes that simple. Click on File and then revision history to make changes.
  3. Chat while editing. Because Google has many integrated features, you can chat with your classmates, research subjects or professors while you chart data.
  4. Insert a formula. Formulas can make you life a whole lot easier, allowing you to perform functions on a cell or a group of cells to better organize and analyze your data.
  5. Spice it up with gadgets. Why stick with a boring old spreadsheet when you can spice things up with some gadgets? Try out a few to make your data much more visually appealing.
  6. Track your finances. If your spreadsheet is related to the stock market, then Google makes things pretty simple by integrating Google Finance with Google Spreadsheets.
  7. Google search inside a spreadsheet. Think of a question while you're working on your spreadsheet? Get answers without ever leaving it with a feature that lets you use Google search right within your document.
  8. Color code it. If you want to better organize your data, colors can be a big help. With Google Spreadsheets, it's simple to color code and highlight just about anything you want. If you want to get fancy, you can have these colors automatically change within a given set of guidelines.
  9. Track changes. Whether you're working with a group or on your own, it can be useful to track your changes as you go. You can see them in a list or receive emails each time a change is made.
Basics
These keyboard shortcuts are essential to working with Google Spreadsheets.
  1. Ctrl+A: Hit these keys and you'll select all the data in your spreadsheet.
  2. Ctrl+S: While Google Spreadsheets has an autosave function, you'll still want to save using this shortcut as well.
  3. Ctrl+W: When you're done with your work, hit control and the W key to close the document.
  4. Ctrl+Shift+S: If you need more than one copy of your spreadsheet, this combination of keys will let you easily make a duplicate.
  5. Ctrl+O: To get started with work, use this shortcut to open an existing document.
  6. Ctrl+P: Sometimes you just need a hard copy to look at. Hit these keys to print one.
  7. Ctrl+N: Start a new project by using this shortcut which brings up a new document.
  8. Ctrl+Z: Made a mistake? No problem, simply undo the changes using these keys.
  9. Ctrl+Y: Want to undo that undo? Hit control and Y to redo any action again.
Alignment and Formatting
Want to make your data easier to read or more visually appealing? These keyboard shortcuts can help.
  1. Ctrl+B: Give your data intensity by putting it in bold with this shortcut.
  2. Ctrl+I: This combination of keys will help you italicize the proper words.
  3. Ctrl+U: Whether you want to draw emphasis or acknowledge a title, these keys will help you underline your work.
  4. Alt+Shift+&: If you need some borders around your data use this to add them. If you want to get rid of them, use Alt+Shift+_ to do the job.
  5. Alt+Shift+T: Say you only need a border around one side, however? This shortcut has you covered, adding borders to the top. For borders on the right, bottom and left, simply substitute R, B or L for the T.
  6. Alt+Shift+5: Want to negate data without removing it? This will let you strikethrough whatever you have in a particular cell.
  7. Ctrl+Enter: If you need a line break in your document, use this shortcut.
  8. Alt+Enter: Similarly, if you want a new line in the same cell, this shortcut will help.
Editing
Clean up and refine your spreadsheet data by using these great shortcuts for editing.
  1. Ctrl+C: To copy data, use this common keyboard combo.
  2. Ctrl+V: Use this to paste any information you've cut or copied.
  3. Ctrl+X: If you want to do away with some information or data, use this combo to cut it out.
  4. Ctrl+M: Make a comment about your spreadsheet using these keys.
  5. Esc: If you have a change of heart about entering data into a cell, simply click escape to cancel.
  6. Shift+Spacebar: To edit an entire row of data, use this keyboard shortcut. It will highlight an entire row at once.
  7. Ctrl+Spacebar: Similarly, these keys will highlight an entire column.
  8. F2: Make it simple to edit the active cell by hitting F2.
Getting Around
Move all around your spreadsheet and between different documents using these shortcuts.
  1. Ctrl+Home: Move to the top of your document using these keys.
  2. Ctrl+End: If you need to go all the way to the bottom, just hit these keys instead of scrolling.
  3. Arrow keys: With the arrow keys, you can move up or down, left or right one cell at a time.
  4. Tab: The tab key will help you move the active cell one to the right.
  5. Shift+Tab: Go back to the left one active cell by using these keys.
  6. End: With this shortcut, you'll move to the end of a row.
  7. Ctrl+Backspace: Hit this combo to scroll to the active cell when multiple cells are selected.
  8. Ctrl+Shift+PageUp/Down: If you've got multiple spreadsheets open, use these shortcuts to switch sheets.
  9. Ctrl+Arrow Keys: These keys will let you move to the top, bottom, left or right most cell in a given row or column.
Other
Still need more shortcuts? These will help you do everything from add the time to insert a hyperlink.
  1. Ctrl+K: Insert a hyperlink into your data using this handy shortcut.
  2. Ctrl+F: Can't find what you're looking for in your data? Use these keystrokes to open a search box.
  3. Ctrl+': If you're not sure what formulas you can use on Google Spreadsheets, use this shortcut to open up a list.
  4. Ctrl+;: Insert the current date with this shortcut.
  5. Ctrl+:: This will help you to insert the current time.
  6. Ctrl+/: Having trouble with the keyboard shortcuts? This will open a help window.
  7. Ctrl+Shift+Enter: Try out this combination to change a wrap formula to an array formula.

Saturday, April 23, 2011

Article Flood - Talking Everything That Matters - A New Blog Aticle Site For You

Yesterday I have launched another Blog named Article Flood. The Objectives of the blog are - "Article Flood is an initiative taken providing useful and informative articles and contents. Guest Bloggers and Authors are invited to add their articles on almost everything like science, Technology, Travel, Medicines, Health, SEO, Businesses, Beauty Care etc. Please try maintaining the quality here and get maximum exposure to their articles by being promoted. Looking forward for this."

Lets make this a beautiful Article Blog for us. This is just a start. After a few months we are planning to make it bigger. This will be a great site for sure to post your articles. Articles will be live after quality check by the Admin and will be allowed to post a Link in the post body and a link in the Author Bio.

After the recent Panda Update, we felt the need of this blog, to help you reach millions of people. We are promoting this Article Blog on a massive scale. Looking forward for your support.

Thanks & Regards 
In association with seo-trends-tricks.blogspot

Friday, April 22, 2011

Do You Know How Many Products & Services Does Google Have

Not every body knows that Google owns over 60 Products & Services. And not many of us use even half of these products together. According to Alexa - Google Search Engine, Google Mail (Gmail), You Tube and Google Image Search are the top Google products and they also dominates the privilege of being the on the top of Alexa ranking too. 90% of Googlers uses Google only as a Search Engine and of course as a free email service provider.   

Now lets list ll the Google products here. I have not tried and used even half of these products and services.

  1. Google Search & it’s features - Google search is the most popular search engine on the Web.
  2. Blogger - A free blog publishing tool for easily sharing your thoughts with the world.
  3. FeedBurner – Allows bloggers and podcasters to manage their RSS feeds.
  4. Google Ad Planner – A free media planning tool that can help you identify websites your audience is likely to visit so you can make better-informed advertising decisions.
  5. Google AdSense – Place contextual Google ads on your site – and earn money.
  6. Google AdWords - Advertise online and pay only when people click on your ad.
  7. Google Affiliate Network (DoubleClick) - Full-service online marketing company specializing in pay-for-performance media.
  8. Google Alerts - Google Alerts are email updates of the latest relevant Google results (web, news, etc.) based on your choice of query or topic.
  9. Google Analytics (Urchin) - Google Analytics makes it easy to improve your results online.
  10. Google Apps - Software-as-a-service for business email, information sharing and security.
  11. Google Base - Google Base is a place where you can easily submit all types of online and offline content.
  12. Google Blog Search - Blog Search is Google search technology focused on blogs.
  13. Google Bookmarks - Google Bookmarks is an online service that lets you save your favorite sites and attach labels and comments.
  14. Google Book SearchSearch and preview millions of books from libraries and publishers worldwide.
  15. Google Calendar - Keep track of all your life’s important events – birthdays, reunions, little league games, doctor’s appointments – all in one place.
  16. Google Checkout - Buy from stores across the web and track all your orders and shipping in one place.
  17. Google Chrome - A browser that combines a minimal design with sophisticated technology to make the web faster, safer, and easier.
  18. Google Code - Code is for external developers interested in Google related development.
  19. Google Contacts – Similar to an online address book, the Contact Manager gives you easy access to the people you want to reach.
  20. Google Custom Search Engine & Google Subscribed Links – With Google Custom Search Engine and Subscribed Links, you can create a search engine tailored to your needs and lets you create custom search results that users can add to their Google search pages.
  21. Google Desktop - Search your computer as easily as you search the web with Google.
  22. Google Dictionary - Free online dictionary.
  23. Google Directory - The web organized by topic into categories.
  24. Google DocumentsFree web-based word processor and spreadsheet, which allow you share and collaborate online.
  25. Google Earth & Google Mars - Offers maps and satellite images for complex or pinpointed regional searches.
  26. Google Finance - Offers a broad range of information about stocks, mutual funds, and companies.
  27. Google Friend Connect – Instantly awakens and strengthens the community that visits your site by enriching it with social features.
  28. Google Gears - A Firefox and Internet Explorer extension that allows to navigate on compatible websites offline and synchronize when going back online.
  29. Google Groups - Where groups of people have discussions about common interests.
  30. Google Health - Puts you in charge of your health information.
  31. Google Image Search & Similar Images - The most comprehensive image search on the web. Google Search Images allows you to search for images using pictures rather than words.
  32. Google In QuotesAllows you to find quotes from stories linked to from Google News.
  33. Google Knol - Knol makes it free and easy to create, collaborate on, and publish credible web content.
  34. Google Latitude - See where your friends are on a map.
  35. Google Local Business Center - If you are a business owner Claim your business listing today and let customers find you online!
  36. Google Mail (Gmail) - Gmail is a new kind of webmail, built on the idea that email can be more intuitive, efficient, and useful.
  37. Google Maps & Google Map Maker - Find local businesses, view maps and get driving directions. With Map Maker you can edit the map in more than a hundred countries and watch your edits go into Google Maps.
  38. Google Mobile - Upgrade your phone with free Google products.
  39. Google Moderator - A tool that allows distributed communities to submit and vote on questions for talks, presentations and events.
  40. Google News, News Archive Search & Google News Timeline - Aggregated headlines and a search engine of many of the world’s news sources. News archive search provides an easy way to search and explore historical archives. News Timeline is a web application that organizes information chronologically.
  41. Google Notebook (SearchWiki) - With Google Notebook, you can browse, clip, and organize information from across the web in a single online location that’s accessible from any computer.
  42. Google Patents - Search the full text of the U.S. patent corpus and find patents that interest you.
  43. Google Product Search (Froogle) - Presents photographs of products and links to the stores that sell them online.
  44. Google Reader - Web based feed reader to keep up with blogs and news.
  45. Google Scholar - Provides a search of scholarly literature across many disciplines and sources, including theses, books, abstracts and articles.
  46. Google Sets - Automatically create sets of items from a few examples.
  47. Google Sites - Google Sites is a free and easy way to create and share web pages.
  48. Google SketchUp - Create, modify and share 3D models.
  49. Google Sky - Google Sky includes a number of different ways to explore the universe.
  50. Google Squared – Takes a category and creates a starter ‘square‘ of information, automatically fetching and organizing facts from across the web.
  51. Google Store – Official Google Accessories, Apparel Items, Software, Office Equipment
  52. Google Suggest - As you type your search, Google offers keyword suggestions in real time.
  53. Google Talk - Chat with family and friends over the Internet for free.
  54. Google Toolbar - Internet Explorer and Firefox Toolbar with Google search.
  55. Google TranslateFree online language translation service instantly translates text and web pages.
  56. Google Trends & Google Insights for Search - Compare the world’s interest in your favorite topics. Use Google Insights for Search and see for yourself what the world is searching for.
  57. Google Video - Search and watch millions of videos indexed from all over the web.
  58. Google Wave – Google Wave is a new online communication and collaboration tool.
  59. Google Web Accelerator - Google Web Accelerator works with your browser to help web pages show up in a snap.
  60. Google Web History - Your web history is stored on Google servers, which means that you can view and manage it from any computer.
  61. Google Webmaster Tools - Provides you with detailed reports about your pages’ visibility on Google.
  62. iGoogle - Your personalized Google home page.
  63. Jaiku - Create your own microblog and connect with your friends.
  64. Orkut - Social networking site designed to make your social life more active and stimulating.
  65. Picasa - Helps you organize, edit, and share your photos.
  66. YouTube - Share your videos with friends, family, and the world.
I haven’t included Google WiFi as I’m not from United States. Google WiFi is a free wireless Internet service to the city of Mountain View, California. I know that the list doesn’t end here but I included only the products which I’ve used or have been using. Please let me know if you know any other interesting service from Google so that I can give a try. So, how many Google Products and Services are you using?
  
The references are  from Wikipedia and Google itself. http://en.wikipedia.org/wiki/List_of_Google_products  and http://www.google.com/options/

Wednesday, April 20, 2011

SEO And SMO Should Go Together To Maximize Online Marketing For Increasing The ROI

The term SMO has revolutionized the Search Engine Industry. SMO is meant for increasing the exposure of your business, brand and product. It aims at creating a trust for your  business, brand and product. Whereas, SEO is optimizing your website to reach the top of the ranking in any search engine.


When you are at the top in ranking on any keyword users will click your site and look for the product and services they want. On the other-hand SMO aims at getting maximum business from the people who are in their network through various Social Media Platforms like Facebook, Twitter, MySpace, Stumble Upon etc.


But the new facts of Internet maketing tells that SEO - Search Engine Optimization is not the only responsible for the all the leads and business today. Today users are more inclined towards the search results which are having a social touch with them. Social Network presence are more influencing the people and this is all due to its touch with the people who re around him and who belongs to the society around him. 


But to give it more twist we must run SEO and SMO together. Following points must always be keep in mind while doing a business online:
1. Get in touch with people who are active on Twitter, Facebook and other such big Social Platforms. 
2. Local listing of your business on Google, Yahoo, Bing.
3. Share your presenttions and bideos which shows and talk about your business on nig sites which drive huge traffic like Slideshare, LinkedIn, Facebook, Orkut(though it is dying these days after the arrival of Facebook) and Youtube. The bideos and presentations must tell about your business efficiently.
4. Discuss about your business on Forums, Blogs, Business Networking Sites etc.
5. Get reviews from experts in your business and publish them. Positive reviews are more powerful for your good business nowadays than any other things. Reviews have affected many businesses in the recent months both positibely and negatively.
6. Integrate your website and Blog with Social Media where you have a good credential. It will boost your SEO ranking on the serch engine as well as increase your leads from targeted customers and eventually increasing your market.
Get the Best SEO and SMO Services . Request A Quote HERE   

Another Nice List Of Free Directory For Submission