Tuesday, August 31, 2010

Gmail Priority Inbox

Gmail Priority Inbox: "Last year, I posted about a new Gmail feature that will prioritize important messages. This feature will be available soon and it's called Priority Inbox.

'Priority Inbox is a new view of your inbox that automatically helps you focus on your most important messages. Gmail has always kept spam messages out of your inbox, and now we've improved Gmail's filter to help you see the emails that matter faster without requiring you to set up complex rules. Priority Inbox splits your inbox into three sections: Important and unread, Starred, and Everything else. Messages are automatically categorized as they arrive in your inbox. Gmail uses a variety of signals to predict which messages are important, including the people you email most and which messages you open and reply to (these are likely more important than the ones you skip over).'



Gmail also adds two buttons that let you classify messages as important or unimportant, just like the 'Mark as spam' and 'Not spam' buttons. Unlike spam filtering, finding important messages is more difficult because you can't use information from other accounts to classify messages.

Google has to build a personalized classifier for each Gmail user and it needs a lot of messages. 'Email importance ranking works best for people who receive a lot of email,' explains Google. Google takes into account implicit signals like: the messages from people you frequently email are important, if a message includes words frequently used in other messages you usually read then it's probably important, the messages you star are probably more important than the messages you archive without opening. There are also explicit signals: click on the important/unimportant buttons, create filters to mark messages as important.

Priority Inbox will be available in Gmail and Google Apps over the next week, but you'll only see it in Google Apps if the administrator has enabled 'pre-release features'.



Tidbit: Gmail uses the 'important' label to classify messages, so that's the reason why you can't create a label named 'important'.


{ Thanks, Niranjan, Tillmann and Nikola. }





"

Friday, August 27, 2010

In-cell dropdown and validation in spreadsheets

In-cell dropdown and validation in spreadsheets: "Today, we added in-cell dropdown and validation to spreadsheets. This makes it easy to constrain the values of an individual cell to a specific range or list. For example, if you are building a trip planning spreadsheet, you can now limit the options in the travel destination column to a select set of cities via dropdown lists.

In-cell dropdowns also make input easier by reducing unnecessary typing and errors in processing. You can create dropdown lists in individual cells through the data validation tool by validating against a range of cells in your sheet or by creating a custom list.


Follow these steps to create an in-cell dropdown list through validation against a range.
  1. Enter data into a range of cells.
    • For example, create a list of destinations on your spreadsheet.
  2. Select the cell(s) you would like to validate.
  3. Under the Tools menu, select Data validation...
  4. Change the Criteria to ‘Items from a list.’
  5. Click the button next to the ‘Create list from range’ option and select the range of cells you entered data in during Step 1.
  6. Click Save and the cell you chose to validate will have a dropdown arrow in it with the data in your cell range as the potential input values. If you want, you can set a cell to allow invalid data.
You can also create a in-cell dropdown using a custom list.
  1. Under the Tools menu, select Data validation...
  2. Change the Criteria to ‘Items from a list.’
  3. Click the button next to the 'Enter list items' option.
  4. Enter a set of custom values, separated by commas. For example, you could enter 'San Francisco, New York, Chicago and Los Angeles.'
  5. Click Save and the cell you selected will have a dropdown list with the values you entered as potential input values.
Let us know what you think in the comments.

Posted by: Li-Wei Lee, Software Engineer


"

Thursday, August 26, 2010

Show all formulas in your spreadsheets

Show all formulas in your spreadsheets: "Finding cells that include formulas in them can sometimes be a bit like looking for something in the dark. To help you illuminate your spreadsheet surroundings, we’re introducing the ability to reveal all formulas with one click.


When you’re comparing formulas with one another or trying to figure out where your formulas aren’t working, showing all formulas should help you out. You can turn this feature on from the formula bar by selecting the “Show All Formulas” button, selecting “Show All Formulas” in the View menu or hitting Ctrl `.

Flip the switch in your spreadsheets to try it out.

Posted by: Matt Ziegelbaum, Software Engineer


"

Make Free Phone Calls from Gmail

Make Free Phone Calls from Gmail: "Gmail added a long-awaited feature: making phone calls. If you install the voice and video chat plug-in, you can call phones in the US and Canada for free. You can also call in other countries, but you'll have to pay. Fortunately, Google's rates are really low and the service is cheaper than Skype.

'Calls to the U.S. and Canada will be free for at least the rest of the year and calls to other countries will be billed at our very low rates. We worked hard to make these rates really cheap with calls to the U.K., France, Germany, China, Japan — and many more countries — for as little as $0.02 per minute,' informs Google.



If you have a Google Voice phone number (anyone in the US can get one), you can also receive phone calls in Gmail. Now that Google Voice integrates with Gmail, a lot more people will use it.


To try the new feature, make sure that your Gmail interface language is set to English (US) and that the voice and video chat plug-in is installed. You get an initial calling credit ($0.10), but unfortunately you can only add credit if you're in the US.



"

Tuesday, August 24, 2010

Tips & Tricks: Enhancing your Presentations with Incremental Reveal

Tips & Tricks: Enhancing your Presentations with Incremental Reveal

Monday, August 23, 2010

Labels: ,

Today’s blogpost is in a different format, a Google presentation about how incremental reveal can make your presentations better by improving their flow.

Check out the difference by comparing the presentation below with and without incremental reveal. Start by clicking play to view the presentation without incremental reveal. Then click on the "open in new window" button to see the full presentation with incremental reveals in action.

You'll notice how the presentation flows more smoothly and is easier to follow.

Posted by: Bryan Carroll, Consumer Operations Strategist

Monday, August 23, 2010

funny Math

The 100 Most Powerful Women On Twitter

Upload Picasa People Photos to Google Contacts

Upload Picasa People Photos to Google Contacts: "Picasa 3.8 makes it easier to upload pictures for your Google contacts. After scanning all the photos from your library and adding name tags to your photos, you can go to the Tools menu, select Upload and click on Upload People Thumbnails.


Picasa asks if 'you want to upload and replace all the thumbnail photos from your People Albums to your Google Contacts'. If you click on 'Upload', Picasa saves the photos to Google Contacts and you can see them in Gmail or in any other application that synchronizes with Google Contacts (for example, Android's Contacts app or iPhone's Contacts app, if you use Google Sync).

If you don't want to upload photos for all your contacts, you can click on one of the people from Picasa's sidebar, right on a photo and select 'Set as Google Contacts Thumbnail'. You can also enable 'Upload people album thumbnails to Google Contacts' from Tools/Options/Name Tags (or Picasa/Preferences/Name Tags on a Mac) to upload the new thumbnails you select in Picasa.

It's strange to see that Google didn't add this option to Picasa Web Albums and that the photos tagged in Picasa Web Albums aren't displayed in Google Contacts. Google could at least offer the option to pick one of the photos tagged in Picasa Web Albums when you add a picture to one of your contacts. Right now, you can only select a photo from your public albums.



"

Sunday, August 22, 2010

Google Live Search: See Search Results as You Type

Google Live Search: See Search Results as You Type: "Google tests a new search interface that updates the results as you type a query. In this experiment, you never have to press Enter or click on the 'Search' button to see the results because Google constantly retrieves the results for your query.

While this interface has the advantage that you can refine your search faster, the constant refreshing can be annoying if you don't need help. Rob Ousbey calls this experiment 'live updating Google search results', Google uses the word 'streaming', while others may call it instant search or incremental search. Google probably wants to morph the search box into a query builder with instant preview.


Check the HD version of the video to better see Google's new UI.

The experiment is not available in Google Labs, but you can try a similar interface at Google Alerts. Type some keywords, click on 'preview results' and every time you change the search terms, Google Alerts shows a preview. There's also Keyboardr, a site that uses Google AJAX API to shows results as you type.

Update: Another user noticed the changes. When you visit Google's homepage and start typing your query, Google moves the search box at the top of the page and displays the results. 'Open the Google page and start typing. Previously, the screen didn't shift. Now, though, as soon as you start typing, Google shifts the search box to the top of the page, and displays ads to the right and distracting search results below.' The new UI can be disabled by clicking on 'turn off streaming' next to the search box.

{ via Blogoscoped Forum }



"