Category: GReader

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.

Posted by: Matt Ziegelbaum, Software Engineer

Well, that was fast. Almost immediately after Google unveiled Android 3.1, Motorola was first out of the gate with an update, and now, not even a week later, Acer and ASUS are following suit with plans to freshen up their respective tablets with the newly minted software. To recap, 3.1’s benefits include resizeable widgets, support for USB peripherals, and new Movies and Books apps, among other perks. Acer confirmed to us that it aims to start selling the Iconia Tab A500 with 3.1 next month, as well as upgrade existing units running Android 3.0. ASUS, meanwhile, has been touting the impending update for the Eee Pad Transformer on its Italian Facebook page. To which we say, grazie!

Acer Iconia Tab A500 and ASUS Eee Pad Transformer getting Android 3.1 updates in June originally appeared on Engadget on Tue, 17 May 2011 15:41:00 EDT. Please see our terms for use of feeds.

Permalink ThisIsMyNext  |  ASUS Italia  | Email this | Comments

With buzz picking up this week that the owners of the Atlanta Thrashers are in talks to sell their franchise to Winnipeg-based True North Sports and Entertainment, a lot of hockey fans are already wondering what division the relocated team would play in next season. Here are a few ideas.

This year it’s become clear that data is scaling to such an degree that you have to change how you manage your desktop and your entire information architecture in order to not just manage your daily work but to succeed.

It’s the core issue of our day, one that’s that’s a top priority when planning to adopt a virtualized infrastructure that allows for people to access apps from tablets and smartphones.

The first step is to get a perspective on the size of the data. This infographic shows what a yottabyte represents in comparison to other terms for units of measurement. It may seem far out to think in such terms but considering projected storage requirements, the concept doesn’t seem so far fetched.

Sponsor

Discuss

At the end of April Google announced that Android OS 2.3.4 would be available over the “next few weeks” for the Nexus One and Nexus S. This update gives video chat to Google Talk and Canadian Nexus S users are reporting that 2.3.4 has been slowly rolling out since this morning to Rogers, Bell, Telus […]

Related posts:

1. Android 2.3.3 update now rolling out to Nexus S and Nexus One
2. Nexus One Android OS 2.3 Gingerbread update “coming in a few weeks”
3. Nexus One receives Android OS 2.3 Gingerbread upgrade arrives in Canada

This photo, purportedly taken near Louisiana’s Morganza Spillway, is simultaneously horrifying and kind of amusing. The snake just looks so purposeful, with its head raised like that. As though it’s out running some errands, or on a morning commute.

That said, I kind of hope somebody spots the pixels that prove this image is a fake. Because the idea of giant snakes hanging out alongside American highways gives my feet a terrible case of the crawling willies.

Via Michael Pata

Arnold Schwarzenegger and his wife, Maria Shriver, separated after the former governor revealed he had fathered a child with a member of their household staff, The Los Angeles Times reported Tuesday.

U.S. diplomatic cables released by WikiLeaks reveal an American perspective on Canada’s ‘inferiority complex’ when it comes to its powerhouse neighbour.

Saskatchewan’s forest fire season has begun with 27 fires burning, including one covering more than 800 hectares.

Filed under: TV News, The Show Girl

Huddy fans, you better have a seat: Lisa Edelstein will not return to ‘House’ for the show’s eighth (and probably final) season.

According to Deadline, Edelstein and costars Omar Epps and Robert Sean Leonard were not under contract for the eighth season. However, Epps and Leonard signed new deals and Edelstein was expected to … until she decided not to.

“After much consideration, I am moving onward with a combination of disappointment at leaving behind a character I have loved playing for seven years and excitement of the new opportunities in acting and producing that lie ahead,” Edelstein said in a statement.

As part of the new deal that was being negotiated, the actress had been asked to cut her per episode salary.

 

Permalink | Email this | Linking Blogs | Comments

We’ve long assumed that the double decker disaster scenario of a massive earthquake and tsunami caused the Fukushima meltdown. Turns out, all it took was the former, which knocked out Fukushima’s cooling in less than 10 minutes. More »

Looks like Acer’s 7-inch Iconia Tab A100 has opted for a fashionably late entrance. We’ve just been informed by the company that its Honeycomb-sporting, Tegra 2-powered slate will not be arriving, as had been expected, right around now, but will in fact make its debut in the second half of 2011. No reasons have been given for the move, other than to say that the device has been postponed. The thing that prompted us to query Acer’s PR team was a report out of Poland suggesting the A100 had been cancelled. Acer’s UK reps are adamant that’s not been the case, but anyone who was looking forward to grabbing one soon will be disappointed either way.

Acer postpones Iconia Tab A100 launch to second half of the year originally appeared on Engadget on Tue, 17 May 2011 06:39:00 EDT. Please see our terms for use of feeds.

Permalink   |   | Email this | Comments

Comments