Get this course

Data Technician [Level 3] → 1.Data Foundations

Spreadsheets for Data Processing (S06)


Description
Apply cleansing techniques to improve data completeness and consistency. Learn key methods to manipulate data so that complete datasets can be created to perform further analysis on.
Features: Ranges, Validation, Cell referencing
Functions: TRIM, LEFT, RIGHT, MID, REPLACE, FIND
Content
  • 01:Features
  • 02:Formulas
  • 03:Formatting
  • 04:Functions
Completion rules
  • All units must be completed
Back