Skip to main content

New features to help improve and analyse data in Google Sheets

 

What can you think when it comes to smart clean up in sheets? This update will help you to update & analyse data in a sheet.


  1. Cleanup suggestions - This helps to ensure that the information is correct by finding and recommending solutions for frequent data errors.

  2. Column stats - Offers automatic information about the values inside a column, so you can spot outliers and easily get an understanding of what the data looks like.


Importance

These features support in detecting potential cleanup activities and help you to be more sure that simple errors do not affect your results. By creating intelligent views that can help surface insight, it would also encourage faster analysis, which you will then choose to explore more closely.

Cleanup suggestions 

It's necessary to clean up your data by rectifying errors and ensuring data accuracy before reviewing and making decisions based on data in your sheets. Cleanup suggestions  will help you achieve this by surfacing the side panel with intelligent ideas. Such recommendations may involve eliminating additional spaces, removing redundant rows, adding formatting of numbers, detecting inconsistencies, fixing incorrect results, and more. This will help to make the cleaning of data easier and more accurate.



Column stats 


By automatically producing visualisations and key statistics that give insight into the details in a given column, column stats will help you easily get a sense of your results. Count and distribution charts, frequency tables, and summary statistics can be provided in these insights. This will help you catch possible outliers easily and move on to further research comfortably.



Cleanup suggestions: When you are in Sheets, go to Data > Cleanup suggestions. When you import data into Sheets, you may see a proactive notification as well


Comments

Popular posts from this blog

Use Vault for Gmail Confidential Messages and Jamboard Files

Google vault will be supporting two new formats in the future, Gmail confidential mode emails & Jamboard files stored in Google Drive. Google Vault gives you a chance to retain, hold, search, and export data to support your organization’s retention and eDiscovery needs. This dispatch includes support for new information types with the goal that you can thoroughly oversee your association's information. What happens when individuals in your association sends confidential messages? Vault can hold, retain, search, and export all confidential mode messages sent by users in your association. Messages are constantly accessible to Vault, notwithstanding when the sender sets a termination date or denies access to private messages. Here’s an example of what admin@ink-42.com will see in Vault when they search for sam@ink-42.com and preview this email sent by lisa@ink-42.com . But It’ll not work vise versa. Admins can hold, retain, search and export message headers and s

Zoom’s Work Transformation Summit on Jan. 19: Fresh Approaches for Moving Forward

These past two years have undoubtedly reshaped work. More specifically, these past two years — shuffling between remote, in-person, and hybrid work scenarios — reshaped what employees expect out of their jobs, how they want to work, and what the office means to them.  Organizations are challenged with making big decisions to meet those expectations, and those decisions will dramatically alter how they hire, manage their facilities, buy technology, and maintain productivity. Simply adjusting policies and retooling previous work models won’t do. It takes a comprehensive reimagining. To help organizations navigate this next phase of work, Zoom is hosting our  Work Transformation Summit  on Jan. 19, a free, half-day virtual event designed to provide you and your organization with meaningful strategies, creative approaches, and innovative solutions for redefining work.  Summit attendees will have the opportunity to hear from peers and industry experts on the importance of embracing technolo

Access well-known educational technology tools straight from Google Classroom.

  We're making it simpler for instructors to use popular EdTech products that are most effective for their class right in Google Classroom with a new seamless integration of single sign-on, assigning, and grading. With the help of this feature, teachers can find, assign, and grade interesting content for their classes, and both teachers and students can access their EdTech tools without needing to navigate to other websites or apps or go through a cumbersome login process that requires remembering numerous usernames and passwords. This offers a more simplified experience when using technology to affect learning, in addition to saving instructors and students time. We partnered with 15+ EdTech companies to build custom add-ons, including Kahoot!, Pear Deck, IXL, and Nearpod.  Admins :  In order for educators to use add-ons, district administrators must provide access to them. For further information on how to install the add-ons functionality and specific add-ons for a domain, OU, o