Start with a specific problem: a missing match, a changed identifier, or an unexpected result.
Choose key columns, review every match, and export the kept rows.
Pair repeated occurrences and inspect items left over in either source.
Diagnose spaces, nonbreaking spaces, tabs and line breaks in imported IDs.
Find why visually identical IDs do not match and choose a repair.
Keep identifiers as text and compare the sample CSV with the expected workbook.
Resolve ISO, MDY and DMY dates while preserving the original strings.
Reproduce blocked cells, tables and merged-cell cases, then repair them.
Work through separate N/A, VALUE and REF cases with expected repairs.
Follow one dataset from preserved original to cleaned output and row-count checks.
Highlight overdue and upcoming dates without treating blanks as dates.
Set numeric, date and list entry rules and inspect their limits.
Count inclusive working dates with your holidays and custom weekends.
Search a Mac-specific shortcut reference and download the printable PDF.
For the complete library, including conditional formatting, lookup and drop-down examples, browse all tutorials.
Inspect workbook properties and export available built-in and custom fields with VBA; learn what file properties this method leaves out.
Learn how to convert between degrees and radians in Excel, use trigonometric functions with degrees, and create custom functions for angle calculations in this comprehensive guide.
Copy query M code from Excel, keep a versioned text file, and paste tested changes back into Advanced Editor.
Compare Text to Columns, Flash Fill and formulas for simple names, with checks for middle and compound names.