{"id":182,"date":"2017-06-08T06:57:31","date_gmt":"2017-06-08T06:57:31","guid":{"rendered":"http:\/\/blog.amt.in\/?p=182"},"modified":"2017-06-08T06:57:31","modified_gmt":"2017-06-08T06:57:31","slug":"machine-learning-in-google-sheets","status":"publish","type":"post","link":"https:\/\/blog.amt.in\/index.php\/2017\/06\/08\/machine-learning-in-google-sheets\/","title":{"rendered":"Machine Learning in Google Sheets"},"content":{"rendered":"

Google Sheets is getting smarter today. After adding the machine learning-powered \u00e2\u20ac\u0153Explore\u00e2\u20ac\u009d feature last year, which lets you ask natural language questions about your data, it\u00e2\u20ac\u2122s now expanding this feature to also automatically build charts for you. This means you can now simply ask Sheets to give you a \u00e2\u20ac\u0153bar chart for fidget spinner sales\u00e2\u20ac\u009d and it will automatically build one for you.<\/p>\n

All of this is backed by the same natural language understanding tech that already powered the \u00e2\u20ac\u0153Explore\u00e2\u20ac\u009d feature. It\u00e2\u20ac\u2122s worth noting that the previous version of \u00e2\u20ac\u0153Explore\u00e2\u20ac\u009d could already build graphs for you, but those focused on your complete data set. It didn\u00e2\u20ac\u2122t allow you to get graphs that answered specific questions.<\/p>\n

With this new version, Google also is making it easier to keep in sync data from Sheets that you use in Docs or Slides. You could already update charts you copy into Docs and Slides with just a click, but now you also can do the same with tables.<\/p>\n

\"\"<\/p>\n

Google Drive is complete with essential tools that help in editing, viewing, and sharing documents online. Google Sheets is one of the tools on Drive that serve as an alternative to Microsoft Excel. Today, Sheets\u00c2\u00a0has got a slew of nifty new features for Sheets that will help users.<\/p>\n

One of the primary features on Sheet is the ability to create charts automatically, based on the already available spreadsheets. This tool will take a lot of work off user\u00e2\u20ac\u2122s backs as Google\u00e2\u20ac\u2122s powerful machine takes care of the rest. By clicking on the \u00e2\u20ac\u0153explore\u00e2\u20ac\u009d option, users can ask Google questions based on spreadsheets, such as \u00e2\u20ac\u0153<\/em>bar chart for ice cream sales\u00e2\u20ac\u009d<\/em> and Google will show a chart that utilizes that data.<\/p>\n

The new feature works a lot like the already available Sheet\u00e2\u20ac\u2122s feature, which pulls data from complicated spreadsheets without the need to enter formulas, users can ask a simple question and get desired results. These features are made to make work easier and also gives an edge to Google Sheets over other spreadsheet programs.<\/p>\n

Besides, Sheets is also adding enhanced sync between Google Docs and Google Slides. The company included sync for charts in Docs and Slides, last year. Today, the same ability is being extended to tables. Now, users can copy-paste their data to other services, and then click on the \u00e2\u20ac\u0153Update\u00e2\u20ac\u009d button to restore that data from the original spreadsheet.<\/p>\n

In addition to all the above-mentioned features, Sheets is also getting improvements that were demanded by users. One of these features is keyboard shortcuts to edit. Being an online service, some of the shortcuts or commands used in other similar services were not compatible, but now those commands will work on Google Sheets too. Also, users will now get options to adjust margins, scale, and alignment when printing. Similarly, editing charts is made easier by adding a new sidebar to get all the tools in one place.<\/p>\n

The above mentioned is a brief about how Machine Learning is used in Google Sheets. Watch this Space for More Updates and Latest Trends in Technology.<\/p>\n","protected":false},"excerpt":{"rendered":"

Google Sheets is getting smarter<\/p>\n","protected":false},"author":1,"featured_media":183,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[48,37,7],"tags":[49,38],"class_list":["post-182","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets","category-machine-learning","category-techtrends","tag-google-sheets","tag-machine-learning"],"_links":{"self":[{"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/posts\/182","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/comments?post=182"}],"version-history":[{"count":1,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/posts\/182\/revisions"}],"predecessor-version":[{"id":185,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/posts\/182\/revisions\/185"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/media\/183"}],"wp:attachment":[{"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/media?parent=182"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/categories?post=182"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.amt.in\/index.php\/wp-json\/wp\/v2\/tags?post=182"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}