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.
- 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
- Fixing Text Case and Spaces: TRIM, PROPER and UPPERFree
- Splitting Order References and E-mails: LEFT, MID, RIGHT and TEXTAFTER Locked
- Joining Fields: Full Names, Address Labels and Record Keys Locked
- Converting Text Numbers and Text Dates: VALUE and DATE Locked
- Finding Duplicates: COUNTIF Flags and a Highlight Rule Locked
- Checking Required Fields: COUNTBLANK, ISBLANK and IF Locked
- Validating Entries: Ranges with AND, Formats with LEN Locked
- Matching Two Lists: XLOOKUP, ISNA and "Not found" Locked
- Standardising Categories with a Lookup Table Locked
- Record Counts and Completeness Rate per Field Locked
- Daily Entry Log: Hours, Records per Hour and Error Rate Locked
- Data Quality Dashboard: Clean Rate, Target Check and Issue Chart Locked
- Phone Numbers and Account Codes: SUBSTITUTE, LEN Checks and Leading Zeros Locked
- Double-Keying Check: Comparing Two Entries Field by Field with EXACT Locked
- Batch Control Totals: Record Counts, Amount Totals and Hash Totals Locked
- Monthly Entry Summary: SUMIFS by Clerk and Document Type, Totals and a Stacked Chart Locked
- Records Retention: Lookup of Keep Periods, EDATE and Due-for-Review Flags Locked
- Turnaround Times: NETWORKDAYS, a Two-Day Target and the Open Backlog Locked
- Check Digits: Catching Typing Errors in Account Numbers with MID and MOD Locked
- Final Project – Monthly Records Report: Speed, Error Rate, On-Time Rate and a Status per Team Locked
Learner reviews
Be the first to review this course.