Records Retention: Lookup of Keep Periods, EDATE and Due-for-Review Flags
Lessons in this course
- 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