How to Use Column Stats & Cleanup Suggestions in Google Sheets (New Feature!)

Leila Gharani

2 followers

1 Video View·Aug 14, 2023 #googlesheets

Smart Clean-up in Google Sheets is a new AI-powered feature to organize, standardize, and clean raw data before you analyze. It's designed to make data cleanup faster and more accurate. It should also help you find inconsistent data.

Google Sheets Cleanup Suggestions will help you identify common errors that you might want to take action on: removing extra spaces, removing duplicates, formatting issues, or fixing inconsistent data.

Column Stats in Google Sheets scans your spreadsheet and automatically generates visualizations (count and distribution), frequency tables (to quickly view the most and least frequently occurring values), and summary statistics at the column level. This way you can quickly identify problems or get a sense of what your data looks like.

Join My Google Sheets Comprehensive Masterclass: https://courses.xelplus.com/p/google-sheets
*** Additional Bonuses are ONLY available on XelPlus.

Time Stamps
00:00 Google Sheets Smart Clean-up
00:49 Column Stats in Google Sheets
04:06 Cleanup Suggestions in Google Sheets

⯆ Check out the blog post here: https://www.xelplus.com/google-sheets-cleanup-suggestions-column-stats

LINK to Google Sheet Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyy0mPWTS5JL99PySzLPiJYu

★ My Online Excel Courses ► https://www.xelplus.com/courses/

✉ Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Microsoft 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Main Camera: https://amzn.to/3a5ldBs
Backup Camera: https://amzn.to/2FLiFho
Main Lens: https://amzn.to/39apgeD
Zoom Lens: https://amzn.to/3bd5pN7
Audio Recorder: https://amzn.to/2Uo5rLm
Microphone: https://amzn.to/2xYy9em
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

Let’s connect on social:
Instagram: https://www.instagram.com/lgharani
Twitter: https://twitter.com/leilagharani
LinkedIn: https://at.linkedin.com/in/leilagharani

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!

#googlesheets