Get this course

Data Technician [Level 3] → 1.Data Foundations [Live Sessions]

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
  • Resources
  • Slide Deck - 1.06 Spreadsheets for Data Processing
  • Web links: Spreadsheets for Data Processing
  • 1.06 Spreadsheets for Data Processing (21/05/2026)
  • Quiz / Test
  • 1.06 Spreadsheets for Data Processing
  • Lesson Review
Completion rules
  • You must complete the test "1.06 Spreadsheets for Data Processing"
Back