How To Use Text to Columns, Flash Fill, Remove Duplicate, Data Validatio...

Click the Download button for Soft Exercise

Text to Columns: Split a single column of text into multiple columns. For example, you can separate a column of full names into separate first and last name columns. You can choose how to split it up; fixed-width or split at each comma, period, or another character.

Flash Fill (Ctrl+E): Automatically fill in a value. Enter a couple of examples you want as output and keep the active cell in the column you want to be filled in.

Remove Duplicates: Delete duplicate rows from a sheet. You can pick which columns should be checked for duplicate information.

Data Validation: Pick from a list of rules to limit the type of data that can be entered in a cell.