Change Google Calendar’s default meeting length and more print options

Posted by Grace Kwak, Product Manager

(Cross-posted from the Gmail Blog.)

Today we’re adding two features that make it easier to customize Google Calendar. First, you can now change your default event length from the standard 30 minute slot. If you frequently create 15 minute meetings, for example, you can now make 15 minutes the default length for all your events. This way, you don’t need to click into the event page to change the duration every time.



You can change the default length of your events from the Calendar settings page. Next to the “Default meeting length” option, choose the length you’d like from the drop-down menu on the right. From there, you can also enable “Speedy meetings,” which automatically shortens events that are 30 minutes or longer to allow you to prep for your next meeting or get to your next appointment if you have a packed schedule.



Second, for those of you who still prefer paper and print your calendar, you can now select a specific date range in the print dialog box. Google Calendar will automatically format your printout for the date range you choose.

We hope you find these new customization options useful. Let us know what you think in the Google Calendar Help Forum.

Editors note: These features are currently launching to all Rapid Release Google Apps accounts.

Pivot Tables now in Google spreadsheets

Posted by Jaideep Mirchandani, Product Manager, Google Apps

Over the past few months, we’ve released a string of new features in Google Docs to give your business more tools for collaborative document editing and data analysis. From simpler file uploads to discussions and mobile editing in documents, we’re making it easier for you and your colleagues to work together on the web. Continuing with this effort, we’re launching pivot tables in Google spreadsheets, which will be rolled out to all Rapid Release users over the next 24 hours.

With pivot tables, you can quickly narrow down large data sets to get high level insights. Say you run a retail chain and you have thousands of rows of sales data broken down by purchase. It could be helpful for you and your sales manager to view the total annual revenue for each region without having to enter multiple formulas. In a matter of seconds, you can create a pivot table and summarize all of your data according to the factors you specify, all while collaborating with your sales manager on the spreadsheet.

To see how pivot tables work in Google spreadsheets, check out this video:



We hope pivot tables in Google spreadsheets will help you save time analyzing your data. For more details on using pivot tables, take a look at our post on the Google Docs Blog.

A recap of new Google Docs functionality for your business

As we near the end of the March, we want to highlight some of the many recent updates made to Google Docs. You’ve already heard about Discussions in Google Docs, which introduced a better way to provide document feedback. Here are some of the other features that have been released in Google Docs over the past couple months:

• Filter your data in spreadsheets: We made it easier to analyze and view your data with the addition of filtering in Google spreadsheets. Applying a filter to a set of data can help you quickly narrow down the data set to find the data you need. By selecting a data set, you can filter and sort amongst many rows at once.
  

• 12 new file formats in the Google Docs Viewer: The Google Docs Viewer is used by millions of people every day to quickly view PDFs, Microsoft Word documents and PowerPoint presentations online. Not only is viewing files in your browser far more secure than downloading and opening them locally, but it also saves time and doesn’t clutter up your hard-drive with unwanted files. We recently added support for:
  
  
  • Microsoft Excel (.XLS and .XLSX)
    
  • Microsoft PowerPoint 2007 / 2010 (.PPTX)
    
  • Apple Pages (.PAGES)
    
  • Adobe Illustrator (.AI)
    
  • Adobe Photoshop (.PSD)
    
  • Autodesk AutoCad (.DXF)
    
  • Scalable Vector Graphics (.SVG)
    
  • PostScript (.EPS, .PS)
    
  • TrueType (.TTF)
    
  • XML Paper Specification (.XPS)

• Mobile editing in 45 languages: Last year, we launched mobile editing in English in Google documents. You can now edit your documents on the go in 45 languages on Android with Froyo (version 2.2) and on iOS devices (version 3.0+) including the iPad.

• Optical Character Recognition (OCR) in 34 languages: Last June, we introduced the ability to upload documents into Google Docs using Optical Character Recognition (OCR). We’ve now added support for 29 additional character sets, including those used in most European languages, Russian, Chinese Simplified and some other Asian languages. See the upload page for the full list.
  

• Multiple chart ranges and hidden sheets in Spreadsheets: We added the ability to chart multiple ranges and hide sheets in Google spreadsheets. In charts, you can now add extra ranges by clicking on “Select ranges...” and “add another range.” You can also manually add new ranges separated by commas. In addition, we introduced the ability to hide your sheets. You can now click on a sheet tab and select “hide sheet” to remove a sheet from view.

• Revisions, presence, and format painter in Drawings: We’re making it easier to work together in drawings. First, we’ve added presence highlights around shapes so you can keep track of which object each person is editing. Second, we added revision history which lets you see who made which change as well as go back to previous versions. Third, the new format painter lets you choose a source shape, press the format painter icon to copy its formatting, and then click on another shape to apply that formatting to the destination shape.
  

• Google Cloud Connect for Microsoft Office: Google Cloud Connect is now available in 39 languages. We’ve also added the ability to hide the toolbar.

• Hidden gridlines in Google spreadsheets: Under the View menu, you can Hide gridlines for each sheet, leaving only the borders that have been put there.

• Quick starring and improved sharing invitations: Now you can star documents while editing them. Once a doc is starred, you’ll be able to find the doc by clicking on the starred link in your document list. We’ve also updated document sharing so that when you share a doc with others, all new collaborators are now included on the email.

• Cloud printing on the go: now you can print from your smartphone with Google Cloud Print for mobile documents and Gmail for mobile. Just open a document in Google Docs or an email in Gmail in your mobile browser and choose “Print” from the dropdown menu in the top right corner. To get started, you’ll need to connect your printer to Google Cloud Print.

As with all updates in Google Docs, users get access to new features each time they open their browsers, and improvements roll out to customers with no need for administrators to manage patches or install software. Stay tuned for more updates to Google Docs.

Posted by Jeff Harris, Product Manager, Google Docs

New in Gmail Labs: Smart Labels

(Cross-posted from the Gmail blog.)

People get a lot of email these days. On top of personal messages, there are group mailing lists, social network notifications, credit card statements, newsletters you might have signed up for, and promotional email from a shopping site you used once months ago. Gmail’s filters and labels were invented to help manage the deluge, but while I have about 100 filters that triage and label my incoming mail, most of my friends and family have all their messages in a giant unfiltered inbox.

Last year, we launched Priority Inbox to automatically sort incoming email and help you focus on the messages that matter most. Today, we're launching a complementary feature in Gmail Labs called Smart Labels, which helps you classify and organize your email. Once you turn it on from the Labs tab in Settings, Smart Labels automatically categorizes incoming Bulk, Notification and Forum messages, and labels them as such. “Bulk” mail includes any kind of mass mailing (such as newsletters and promotional email) and gets filtered out of your inbox by default (where you can easily read it later), “Notifications” are messages sent to you directly (like account statements and receipts), and email from group mailing lists gets labeled as “Forums.”


If you already use filters and labels to organize your mail, you may find that you can replace your existing filters with Smart Labels. If you're picky like me and still want to hold on to your current organization system, Smart Labels play nice with other labels and filters too. On the Filters tab under Settings, you'll find that these filters can be edited just like any others. From there, you can also edit your existing filters to avoid having them Smart Labeled or change whether mail in a Smart Label skips your inbox (which you can also do by just clicking on the label, then selecting or unselecting the checkbox in the top right corner).

Labs in Gmail are a great testing ground for experimental features, and we hope Smart Labels help you more effortlessly get through your inbox. If you notice a message that was automatically labeled incorrectly and want to help us troubleshoot, you can report miscategorizations from the drop down menu on each message (in doing so, you’ll donate the full message to our engineers so that we can improve the feature).

To get started with Smart Labels:

1. Sign in to Gmail and click 'Settings'.
2. Click the 'Labs' tab and select 'Enable' next to 'Smart Labels’.
3. Click 'Save Changes.'

Please note that Google Apps for Business and Education users will first need their administrators to enable Gmail Labs from the Google Apps admin control panel to take advantage of Smart Labels, and other Gmail Labs. For more information on Gmail labs for Google Apps, see the Help Center.

Give it a try and send us feedback on how we can make it work better for you!

Posted by Stanley Chen, Software Engineer

The more you know: switching to Gmail like a pro

Every day, tens of thousands of people switch from Microsoft Outlook® and other client-based software to Google Apps. To make the transition as smooth as possible, we thought we’d share some tips on using Gmail.

Embrace conversations
Emails rarely come just one at a time; they’re usually part of a larger exchange. Gmail helps you manage messages more efficiently by grouping related emails into conversations. Conversations are a collection of messages with the same subject line and other similarities. When you click to read a conversation, you'll see all of the back-and-forth email responses that happen over the course of the entire email conversation.

This makes it easier to follow the full context of a conversation, and keeps your inbox less cluttered and more organized. If you prefer a more traditional view of your Inbox, you can always turn off Conversation view so that all emails arrive individually.


Forget delete, and archive your way to “Inbox Zero”
The average corporate inbox is only 300MB, which means too many people are forced to spend way too much time managing their inbox -- deciding which email to keep, and deleting the rest. With 25GB of storage, you probably won’t ever need to delete an email again because of storage limitations. And if you thrive on clearing your inbox, simply archive your emails to clear the clutter. They’re still fully searchable in an instant!

Search to sort
You may be accustomed to sorting email to find saved messages, which is a pretty limited way to find information because you usually know what you’re looking for. Gmail uses the power of search to help you quickly find what you want. You can even use advanced search operators to search by sender, date, attachment or a variety of other attributes. Try it and you'll find some of the qualities that Google.com is known for: great accuracy and really fast search results. Search is particularly more effective than sorting when you’re looking through multiple gigabytes of email!


Labels instead of folders
While you won't find folders in Gmail, labels give you even more flexibility to organize your email. You can’t put an email into multiple folders, but you can apply multiple labels to the same message, which makes it easy to manage information that may fall into more than one category.


By clicking on a label, you can view a chronological list of all conversations that have been tagged with that label. And you can even organize labels hierarchically, using the “Nested Labels” lab. (Your administrator needs to have enabled Labs for you to access them.)

Work offline
These days you’re probably almost always connected to the Internet. But in those increasingly rare moments when you’re not, you can still access Gmail. When you’re offline, you can work in your browser to compose messages, search, organize mail, and do all of the things you're used to doing while accessing your email online. Any messages you send while offline will be placed in your outbox and automatically sent the next time Gmail detects a connection. To enable offline Gmail, go to the ‘offline’ tab in Settings, select ‘Enable’ and then save changes.

New features
As a web application, Gmail can be updated and improved without the trouble of purchasing, downloading and installing updates. This means Gmail will continually offer new functionality to help you be even more productive, like Priority Inbox, integrated voice and video chat, and labs such as Apps Search and Desktop Notifications. To stay current on new features, we encourage you to subscribe to our RSS feed for updates to the Google Apps suite.

We hope you enjoy the experience we offer -- we believe that ultimately, a fully-searchable, delete-nothing inbox makes for happy, productive people. But if you’re still not quite ready to use Gmail’s web interface, you can keep using Outlook or other clients of your choice. For more tips, check out our detailed transition documentation, and let us know what else we can do to make your move to Gmail easier in the comments below.

Posted by Rajen Sheth, Google Apps Product Manager

Work better across time zones with Google Calendar

Collaborating with colleagues from various teams in different offices is a daily facet of my work. I am based in Zurich, Switzerland, and many of the people I interact with are in California, USA, which is nine hours behind. Oftentimes I find myself invited to attend meetings that happen late in my evening, which proves that coordinating across time zones can be a challenge.

At Google we want to help you maintain a healthy work/life balance, so today we’re launching a set of new features that will improve your experience whether you’re scheduling across time zones or just across the hall.

Setting Up Working Hours
For Google Apps users, the new ‘Working hours’ setting allows you to configure the hours that suit your schedule, as you can see in the screenshot below:


Users setting up an event will be able to see your working hours clearly marked in your calendar in the event creation page. They will also be warned if they schedule an event outside your working hours. For example, when someone in California is scheduling an appointment with me for 11am their time, they will see a warning like this:


Find a Time, Make it Recurring
The new "Find a Time" tab on the event scheduling page lets you view your coworkers’ schedules at-a-glance and choose the best time for a meeting. This is especially helpful for scheduling events with a large number of attendees, particularly if they are spread out geographically. Also in the event scheduling page, we’ve launched a simpler interface for setting recurring meetings with a small window that appears when you select the “Repeats” check box. For Google Apps customers with the administrative control panel option set to “enable new pre-release features” users will automatically see these new changes to the event editor.

We’ve also made a number of changes on the back-end that improve the performance, consistency, and extensibility of Calendar, which we’ve announced on our Gmail blog today. Enjoy your meetings, now with fewer time zone scheduling hassles!

Posted by Oana Florescu, Software Engineer, Calendar

Update (8/30): While rolling out the new calendar features last week we identified a potential issue that caused us to delay the update. We are working to launch these new feature to users on domains that do not utilize the Google Calendar Connector (GCC) service early this week and we are working on supporting GCC users in the near future.

Upgrade your users’ knowledge with Google Apps Tips and Tricks

As a Google Apps trainer, I’ve spent more than two years working with Google Apps customers on deployments, researching how they use resources provided by Google or from our professional training partners.

I always learn a lot from “Go Live” week – the first days of deployment, when users start to discover Apps’ features and capabilities. But for me, the real “aha” comes a month or so later, when users are familiar enough with Apps that they want to dive in and do more. I often see people beginning to seek out and share power tips and tricks for using Apps around that time.

To help with that sharing, we’re announcing a new addition to the Google Apps Deployment Site: a center for Google Apps Tricks and Tips. This center contains a collection of ideas and suggestions that that users can try to take their Apps use to the next level. The first collection of tips focuses on Gmail, but insights on using Docs and other features are in the works.

View this image in detail here.

The tips are short, easy to understand, and incorporate step-by-step graphics to walk the user through the tip. They’re designed to encourage users to discover features of Google Apps they may not have known existed, and to educate them when new functionality is incorporated into the products.

We’ve made it easy for Google Apps administrators to use these resources. Our Tips and Tricks Getting Started Guide walks you through the process of incorporating the tips and tricks in your training site. (If you haven’t created a launch or training site, check out our support site templates for an easy way to get started.)

Give Google Apps Tips and Tricks a try and watch how quickly your users become more collaborative, productive, and proficient as they incorporate the newly learned features into their daily routine.

Posted by Gary Giurbino, Google Enterprise Training team