Spreadsheets experts often use PivotTables to understand the hidden meaning behind data, which is a significant difference between expert and average user. However, the latest version of Google Sheets hopes to shorten the gap between the two, user-friendly language to facilitate the creation of PivotTables.
With the help of artificial intelligence, the Google Sheets Explore feature is once again enhanced to help users understand the content behind the data. For beginners, you no longer need to manually create the PivotTable, Google Sheets will automatically recommend creating PivotTable based on the data in the chart.
And in the Explore page, users can ask questions in natural language. At present, only English is supported. Users only need to enter a question to get the corresponding answer. And for those more old-fashioned users who want to create their own PivotTables, Google Sheets also offers intelligent help to create recommendations for users and more.