Skip to main content

[TIP: How to query in Natural Language (NLP) within Google Spreadsheets]

Introduced in the Google Cloud Next 2017, this feature allows you to Question/Answer in natural language within Google Spreadsheet.

In general, spreadsheet novices often do not know how to use a sheet or the functions Spreadsheet provide, so even if there is useful data in the sheet, it is often misaligned because of poor analysis.

If you take advantage of the Explore function in 'Spreadsheet' as shown below, you can create a good report.



This is a sample statement that can be queried in the Explore of a sheet.

1. What were the top item on 2017
2. How many unique countries
3. What percentage of Represent is '이영희'
5. Who is the top represent?
6. Top Sold Units for Rep of '홍길동'
7. How many sold items by '홍길동

-----------
Kindle Edition-Paperback/eBook -
"Advanced Chrome Device Management & 2017 Essential Guide for Chromebook Users"


' 
Labels:

Comments

  1. website development company in chennai11/01/2018 1:45 PM

    That is great research you have done. It is an exceptionally valuable reference for staying up with the latest with the most recent advanced promoting news.

    g suite unlimited pricing in india

    ReplyDelete
  2. website development company in chennai12/15/2018 3:34 PM

    Nice Blog, Gsuite a set of intelligent apps including Email, Docs, Drive, Calendar & More with guaranteed 99.9% Uptime and 10+ Yrs experience plus operating with G Suite Premier Partner for providing 24/7 Customer Support. g suite basic pricing india

    ReplyDelete
  3. Anonymous2/21/2019 1:08 AM

    Nice article
    Click here:Soap Bubble
    Windmill live Wallpaper
    Timer Plus
    Opera Browser
    Peroidic table
    4g Lte Only mode

    ReplyDelete

Post a Comment

Popular posts from this blog

How to Manage Android Apps for Google Workspace users using Chromebook

How to Manage Android Apps (Google Play(beta)) for Google Workspace users using Chromebook  A Google Workspace  administrator can manage Chromebook users who want to install Andorid apps in the domain. Here is the information on how to manage Chromebook users installing Android apps by Google Workspace administrator. An administrator can force to install approved Android apps for Chromebooks logined in  Google Workspace . or allow  Google Workspace  users to install the Android apps from Play Store.  If you’re a Chrome for business customer, the managed Google Play Store is available for   these Chromebooks   using Chrome OS version 53 and later. For Chrome for education, the managed Google Play Store is supported on Chrome OS version 56 and later. Before you begin         Enable Android apps for Chrome OS in your domain Android apps on Chrome OS use the Android and Google Play manage...
49 comments
Read more

What is Chrome Enterprise Upgrade (Chrome Device Management)?

Ho w to manage Chrome Devices for Enterprise and Education. (CEU) Companies have not had a positive view of Chromebook. In recent years, however, businesses have changed the perception of Chromebook. According to the IDC report , there are predictions that by 2018, 25% of Fortune 500 companies will use Chromebook. One of the biggest features for Chromebook is that it has an affordable price (average $ 150 - $ 300). In addition, it features fast performance, fast booting, secure computers free from viruses and malware, easy-to-manage computers, free office document editing tools, and MS Office compatibility tool. With the ability to run even millions of Android apps on the Google Play Store, Chromebook evolves into innovative computers that are capable of not only cloud-based online apps but also Android offline apps. Google is launching a Chrome-based platform to strengthen its enterprise market. Google is driving the new paradigm of computers in the ent...
13 comments
Read more

Claude AI for Writers & Professionals: Enhance Your Creativity and Productivity

  Unlock Your Creative and Professional Potential  with Claude AI Discover how the new book "Claude AI for Writers & Professionals" can revolutionize your workflow. - Book recap podcast: -  Are you ready to revolutionize your writing process and boost your productivity in the age of AI? The way we write and work is changing rapidly, and generative AI is at the forefront of this transformation. But how can you effectively harness this powerful technology without losing your unique voice or getting overwhelmed? Introducing  "Claude AI for Writers & Professionals: Enhance Your Creativity and Productivity"  – your essential guide to mastering Anthropic's groundbreaking AI,  Claude 3.7 Sonnet . This practical book, written in collaboration with Claude itself, demystifies AI-assisted writing and provides actionable strategies for writers, professionals, students, and anyone looking to leverage AI for enhanced communication and efficiency. Inside, You'll D...
Post a Comment
Read more