Tabellab
Data & Analytics Beginner

Excel for Data Entry & Records Clerks: Clean, Check and Match Data

20 hands-on labs for data entry clerks and records assistants: fixing case and spaces, splitting codes, joining fields, converting text numbers and dates, duplicates, required fields, validation rules, matching two lists, standard categories, completeness, a daily entry log, a data quality dashboard, phone numbers and account codes, double-keying checks, batch control totals, monthly summaries, retention dates, turnaround times, check digits and a monthly records report.

20 lessons 20 labs Certificate

  • One-time payment
  • Instant access right after payment
  • Secure checkout with Stripe

About this course

This beginner course teaches the Excel skills a data entry clerk or records assistant uses every day, in 20 interactive labs set at the fictional company Brookfield. You fix case and spaces, split order references and e-mails, join fields, convert text numbers and dates, find duplicates, check required fields and validation rules, match two lists with XLOOKUP and standardise categories. You measure completeness, keep a daily entry log and build a data quality dashboard. Later labs clean phone numbers and restore leading zeros, compare double-keyed forms with EXACT, balance batches with count, amount and hash totals, summarise a month with SUMIFS, calculate retention review dates with EDATE, measure turnaround with NETWORKDAYS and catch typing slips with check digits. A monthly records report with status rules closes the course. Every cell is checked instantly.

Lessons

  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

Learner reviews

Be the first to review this course.

Write a review

Your rating

Reviews are checked before they appear. By submitting you confirm the images are yours and may be shown on this page. Privacy