Tech & Science Latest Google Sheets release helps automate pivot table creation

13:22  07 december  2017
13:22  07 december  2017 Source:   TechCrunch

Google's Allo messaging may link to your email account

  Google's Allo messaging may link to your email account It could open the chat app to many more people.There's no guarantee that this reduced phone dependence will be widely available soon, but code like this typically hints that it's on the horizon. If it does arrive, though, it could make Allo a more elegant experience, particularly if you regularly use it across multiple devices.

1 Google is killing Chrome Apps for desktops, for good. 2 Here’s how you automate your inbox to zero. 3 Google launches a data-friendly search app for 8 We could fund a universal basic income with the data we give away to Facebook and Google . 9 Lyft increases latest funding round by 0M to .5B.

It has been what separated those folks from the rest of us, but Google is out to democratize the pivot table in the latest version of Google Sheets announced today. The idea here is to begin bringing automation to bear on the data pile to help surface meaningful insights.

Google logo at the Google headquarters in Brussels.© AP Photo/Virginia Mayo, File Google logo at the Google headquarters in Brussels. The spreadsheet gurus in your organization know how to use pivot tables to pull meaningful insight out of a morass of numbers. It has been what separated those folks from the rest of us, but Google is out to democratize the pivot table in the latest version of Google Sheets announced today.

Google is achieving this by adding some artificial intelligence under the hood. The new features build on the Explore feature the company added last year. The idea here is to begin bringing automation to bear on the data pile to help surface meaningful insights.

Android 8.1 final preview enables the Pixel 2's custom camera chip

  Android 8.1 final preview enables the Pixel 2's custom camera chip The first Android 8.1 preview release opened the doors to app developers wanting to support the Pixel 2's untapped Pixel Visual Core chip, and now the phones themselves are ready for action. The 8.1 release also includes acceleration for machine learning through TensorFlow Lite, performance improvements for Android Go phones and a host of minor tweaks. Logically, this last preview also stamps out a host of bugs from before.

Pivot table Google Sheets can help you to represent your data in a more convenient and presentable form. In this article, you will learn about creating Google Sheets pivot table and charts from pivot tables .

Using the pivot tables , we get to explore the underlying information and trends that the data contains. Let us understand this with the help of an example. But fortunately, we have a much simpler yet a sophisticated functionality that Google Sheets offers – pivot tables .

Today’s feature add machine learning to the pivot tables to achieve a couple of major breakthroughs. For starters, instead of manually creating a pivot table to bring order to your data set, Google Sheets can suggest a pivot table based on the data you have in Google Sheets for you automatically. No more begging at the guru’s door for the spreadsheet mortals among us. This puts them within reach of just about anyone.

a screenshot of a computer© Provided by TechCrunch

There’s also a natural language querying interface in the Explore pane, so you can ask questions in plain English (or your language of choice eventually; it currently only supports English) and the applications can find the data in the pivot table for you. You no longer have to go hunting for the data. You  can ask a questions, and get an answer (assuming it’s there to be found, of course).

Google pulls YouTube from Amazon devices, escalating spat

  Google pulls YouTube from Amazon devices, escalating spat By Jeffrey Dastin

To create pivot tables , you will obviously need data with which to work. Have that ready in a Google Sheet to get started on your pivot table . Select all the data by selecting the corner cell or pressing Ctrl + A.

Google Docs initially allowed the creation of basic pivot tables via the pivot table gadget from Learn how to build a simple pivot table , using My current code is below: Dim shBrandPivot As I am working on automating a report. Google sheets pivot table tutorial – how to create and examples www.

For those you who are old school and want to create your pivot tables from scratch, Google has some love for you too. It uses the same intelligence it provides for mere mortals to create pivot tables to make suggestions to help you too.

It’s not all about intelligence though, you know. You want your pivot table interface to look good too and Google has updated the Pivot Table UI including customizable headings, rows and columns.

Google isn't limiting the intelligence to pivot tables either. It's trying to add it across the entire spreadsheet experience, so you if you are entering data, it could pop up suggestions about what formula you might want to use for a given kind of information. If this works well, it could be quite helpful, but if it doesn’t, it could get annoying.

All of this and more will be rolling out over the coming months, according to Google.

Google Maps will soon tell you when it's time to get off your train or bus .
Google is about to launch a small but useful update to Google Maps that will give you live guidance and interactive real-time notifications during your journey. The idea here is to give you real-time updates while you are on your transit journey. These updates will appear in the Google Maps app and, maybe most importantly, on your Android lock screen.To get started, you search for your transit directions in Google Maps as usual. So far, so good.

—   Share news in the SOC. Networks

Topical videos:

This is interesting!