Dirty Data: Excel Techniques to Turn What You Get Into What you Need

By Melissa Esquibel

As data is migrated from older, legacy systems to new ones, data integrity and accuracy is often compromised.

The new system’s controls may be top notch, but did all the data migrate correctly and how do you know?

Spreadsheet applications, like Microsoft Excel, are powerful partners for preparing supporting data for audits. But they are also fraught with pitfalls that can lead to unintended errors and omissions.

And the more you copy and paste from here to there, the more issues can arise.

In this short clip, learn a few tricks in Excel that will help you ensure your data migrates cleanly and accurately.

For more great tips, check out our upcoming Using Excel to Clean Up Dirty Data. This two-hour virtual course will be led by Melissa on August 4, 2022.

Melissa Esquibel is the author of Dirty Data: Excel techniques to turn what you get into what you need