Improved Data Wrangling and Validation in Excel
Presented November, ’14 at CAIR
Are your Excel spreadsheets error-free? This presentation is intended to help you use automated processes to clean up and transform data in Excel. The overall approach combines vLookup, conditional formatting, named cells and ranges, formatting for meaning, and spatial layout. The resulting approach reduces errors, increases auditability, and speeds up repetitive tasks. Virtually all Excel audits find errors; this presentation is designed to increase your confidence in data wrangling tasks.