FormulaCamp
Completed
← Full curriculum
Track 6 · Confident User

Data Management and Cleaning

Sorting, filters, duplicates, Text to Columns, data validation, dependent lists, and cleaning up text, numbers and dates from CSV files.

4 free lessons

0 of 10 completed · about 3 h

Start

10 lessons left until your certificate

Order in Your Data

  1. 1Sorting DataFreelesson15 min
  2. 2Filter and SUBTOTALFreelesson15 min
  3. 3Duplicates and Text to ColumnsFreelesson15 min
  4. 4Data Validation and Dropdown ListsFreelesson15 min
  5. 5Practice: Working with Datapractice20 min

Lists and Messy Data

  1. 6Dependent Dropdown Listslesson20 min
  2. 7Flash Fill and Text Formulaslesson20 min
  3. 8Numbers Stored as Text and Dates from CSVlesson20 min
  4. 9Encodings and Delimiters When Importing CSVlesson20 min

Advanced Filtering

  1. 10Advanced Filter and Criteria Rangeslesson20 min