In today’s post we are sharing with you two important Google Sheets features that will help you make the best of your Sheets experience. The first one is an autocomplete functionality and the second one is a cleanup feature. Read on to learn more.
SmartFill for Sheets is an intelligent algorithm integrated with Google Sheets that reads your Sheets data, detects patterns and provides autocomplete functionality. For instance, “if you have a column of full names, you may want to split it into a column with first names and a column with last names. As you start typing first names into a column, Sheets will automatically look for patterns. If Sheets detects a pattern, it will generate the corresponding formula, and then autocomplete the rest of the column for you. “
Sheets Smart Cleanup is an excellent feature that enables you to tidy your data and get it ready for analysis. It offers two important services: Cleanup suggestions which detects potential errors and bugs and suggests fixes (e.g., ‘removing extra spaces, removing duplicate rows, adding number formatting, identifying anomalies, fixing inconsistent data, and more’), and Column Stats “can help you quickly get a sense for your data by automatically generating visualizations and key stats that provide insight into the data in a specific column. These insights can include count and distribution charts, frequency tables, and summary statistics. This can help you quickly catch potential outliers and confidently move on to deeper analysis. “