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

16:36  07 december  2017
16:36  07 december  2017 Source:   TechCrunch

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.

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.

Google Assistant can now locate a handiman near you

  Google Assistant can now locate a handiman near you Google is adding a handy feature to Assistant, so it can now find local services like plumbing or electrical repairs near you, provided you’re in the US. That’s handy for people who already use the voice-activated service on their phones or Google Home smart speakers. To use it, say “Ok Google, find me a plumber,” and it’ll ask you a couple of questions to track down the right sort of service in your area.The company has partnered with home improvement aggregators HomeAdvisor and Porch to prescreen all service providers that Assistant surfaces.

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’s Project Tango is shutting down because ARCore is already here .
Google said today that it’ll be shutting down Project Tango next year, on March 1st. Project Tango was an early effort from Google to bring augmented reality to phones, but it never really panned out. But those devices required special sensors. And in the meantime, Google (and competitors, like Apple) figured out ways to bring AR features to phones with just the hardware that’s already on board. Google introduced a new augmented reality system, known as ARCore, in late August. And it just brought that system to the Pixel and Pixel 2 in the form of some augmented reality stickers — immediately opening AR features to more people than Tango is likely to have reached in its lifetime.

Source: http://uk.pressfrom.com/news/tech-science/-227891-latest-google-sheets-release-helps-automate-pivot-table-creation/

—   Share news in the SOC. Networks

Topical videos:

This is interesting!