Tabellab

Joining Fields: Full Names, Address Labels and Record Keys

Lesson 3 of 20 Lab 🔒 Locked

Lessons in this course

  1. Fixing Text Case and Spaces: TRIM, PROPER and UPPERLabFree
  2. Splitting Order References and E-mails: LEFT, MID, RIGHT and TEXTAFTERLab Locked
  3. Joining Fields: Full Names, Address Labels and Record KeysLab Locked
  4. Converting Text Numbers and Text Dates: VALUE and DATELab Locked
  5. Finding Duplicates: COUNTIF Flags and a Highlight RuleLab Locked
  6. Checking Required Fields: COUNTBLANK, ISBLANK and IFLab Locked
  7. Validating Entries: Ranges with AND, Formats with LENLab Locked
  8. Matching Two Lists: XLOOKUP, ISNA and "Not found"Lab Locked
  9. Standardising Categories with a Lookup TableLab Locked
  10. Record Counts and Completeness Rate per FieldLab Locked
  11. Daily Entry Log: Hours, Records per Hour and Error RateLab Locked
  12. Data Quality Dashboard: Clean Rate, Target Check and Issue ChartLab Locked
  13. Phone Numbers and Account Codes: SUBSTITUTE, LEN Checks and Leading ZerosLab Locked
  14. Double-Keying Check: Comparing Two Entries Field by Field with EXACTLab Locked
  15. Batch Control Totals: Record Counts, Amount Totals and Hash TotalsLab Locked
  16. Monthly Entry Summary: SUMIFS by Clerk and Document Type, Totals and a Stacked ChartLab Locked
  17. Records Retention: Lookup of Keep Periods, EDATE and Due-for-Review FlagsLab Locked
  18. Turnaround Times: NETWORKDAYS, a Two-Day Target and the Open BacklogLab Locked
  19. Check Digits: Catching Typing Errors in Account Numbers with MID and MODLab Locked
  20. Final Project – Monthly Records Report: Speed, Error Rate, On-Time Rate and a Status per TeamLab Locked