Google Docs in January: Styles, Sparklines, Google+ sharing, and more

One of the best things about working on web apps like Google Docs is that it gives us the flexibility to frequently bring you new features and improvements. Starting this month, we’re going to make some small changes to how we communicate what’s been happening in the world of Docs. Instead of writing blog posts for each and every minor update, we're going to try bundling them together monthly to give you a detailed overview of our favorite features and a short list of other notable changes to make sure you don't miss out on anything new.

On that note, we’ve got a bunch of new features that launched today, as well as some great things that improved over the month of January.

Customizable styles in documents
Giving your document consistent and beautiful formatting should be easy. Before today, if you wanted to update all the Subtitles in your document to look a particular way, you had to change each of them one at a time. That’s too many steps. Now you can restyle all your regular paragraphs, headings, or titles with just a couple clicks. For example, if you want to update all the Subtitles in your document to be a particular size, set one Subtitle to that size, select it, right click and choose Update Subtitle to match selection. This will change all the Subtitles already in your document and automatically update the style for any new Subtitles you create. Plus, with the new Options menu in the styles dropdown, you can set the current document’s styles as the default for new documents or you can load your default styles into the current document.

Sparklines in spreadsheets and more charting options
In Google spreadsheets, we’ve added more charting options and support for sparklines to make it easier to communicate data. The new options give you a bunch of tools to create more sophisticated charts including different Y-axes on either side of the chart, formatting options for the axis and title text, and all sorts of other customization for how your lines, bars, or pies are displayed. We’ve also added sparklines, which let you display line or bar charts inside of cells and are handy for presenting and comparing data in a simple, bite-sized way. In the example below, we’ve used sparklines to plot currency exchange rates over a 30-day period.

Sharing forms on Google+
Sharing the forms you create in Google Docs with the right people shouldn’t be a hassle. Today we added a Google+ share to the form editor so that you can share your forms directly with your circles with just a couple clicks.

And there’s more…
On top of today’s new features, here are some changes from January that you may have missed:

• Adding images to your docs from a high quality stock photo gallery. Simply go to Insert > Image, select Stock photos, and then search for the images that you want.

• A more streamlined format for document discussion notifications that batches multiple discussions into a single email.
• Quickly opening and selecting items from specific menus with keyboard accelerators. For example, when using Google Chrome, Ctrl+Option+E on a Mac and Alt+E on Windows or Linux will open the Edit menu.

• Copying and pasting via the context (right click) menu in documents when you have the Chrome App installed.
• Easily adding Google drawings or Google Groups discussions to a Google Site from the Insert menu.

• Progress bars while uploading files to Google Sites.
• Searching for text inside of PDFs in your documents list using Optical Character Recognition.

If you’d like to learn more about what we’ve been up to in January, I’ll be doing a Hangout On Air later this week this to talk about these changes and listen to your feedback. Stop by our Community Manager Teresa’s Google+ page on Thursday, February 9 at 12 p.m. EST (Pakistan Time 10 p.m)  to tune in.

Making Google spreadsheet functions easier to discover and use

From the simple SUM function to GoogleLookup, Google spreadsheets continues to add features that help you power through data. But sometimes it can be a challenge to find the one you need to use or figure out the right way to use it. We’ve made the following improvements to help you quickly discover and understand all of the powerful functions that Google spreadsheets has to offer.

Help snippets directly in spreadsheets
You shouldn’t have to interrupt your work to figure out how to build a particular formula, which is why we’re bringing help documentation directly into Google spreadsheets.

As soon as you start typing a formula into a cell, you’ll notice an auto-suggest box with the name and syntax of the function you might be looking for. Mouse over any of the suggested functions, and you’ll see a description that explains the function, its syntax, and how it’s used. You’ll also see links to related content and a link to the complete list of functions.


Auto-suggest displays syntax and help documentation for all 300+ available functions and even recognizes nested functions, making it easier to build complex formulas.

Revamped help documentation in the Google Docs Help Center
We’ve also completely rebuilt our help documentation for Google spreadsheet functions with invaluable input from some of our most active forum users such as ahab, yogia1, Ted J, A.P.L, MarinusP, and other forum Top Contributors. Here’s a look at what’s new:

A completely new table for browsing help documentation for all 300+ Google spreadsheets functions. This table is easy to browse, sort or search. To view the table, you can visit the Google Docs Help Center, click the complete list of functions link in the auto-suggest help snippets, or select Help > Function list in any Google spreadsheet.
Help documentation for nearly 60 new functions and formulas.
More detailed help documentation, including better instructions for some of our most sophisticated and complex functions.All of these improvements are now in English, and will be available in additional languages in the coming weeks.

So take advantage of these new resources at your fingertips and you’ll be a Google spreadsheets ninja in no time.

Summarize your data with pivot tables in Google Docs

Starting today, we're rolling out pivot tables in Google spreadsheets. Pivot tables make it easy to process and summarize large data sets in seconds. Check out the video below for a look at how pivot tables work in Google spreadsheets:
In essence, a pivot table does just that -- it allows you to “pivot” or rotate data, thus looking at it from different angles and seeing a variety of patterns which may not be immediately obvious. Let’s take a very simple example of a list of students. This list includes a number of students and some information about them, including gender, class level, and major.



To create a pivot table, select your data and go to Data > Pivot Table Report. In the pivot table report editor, you can add fields to set your rows, columns, and values and can drag and drop the fields around within the editor. Here, we’ve used pivot tables to display the number of students in each class level by gender.


Fields in the Values section can be summarized using built-in formulas to sum, count, or otherwise calculate your data. In the example above the number of students in each class level was summarized via a simple count.


The filter section lets you specify exactly what data you want to be included in the pivot table. For example, we can choose to only count the students in certain extracurricular activities.



With each change, the pivot table is updated in real-time for both you and any collaborators. If you prefer to make changes in batches, you can switch to manual mode. In this mode, your changes won’t be saved until you select Update table.

You can try pivot tables out for yourself using this template or by using your own data set. Please note that pivot tables from Microsoft Excel can’t be uploaded to Google spreadsheets at this time.

We hope you’ll enjoy exploring pivot tables in Google spreadsheets and that they’ll save you time analyzing your data. Check out our help content for even more examples and follow us on twitter.
[Source]