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?

Excel Techniques

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 Excel techniques 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.

About Melissa Esquibel

While it’s true that if you don’t know where you’re headed, it doesn’t matter how you get there; not asking in the first place is the sure road to disaster when it comes to significant technology infrastructure changes. Ask any business unit executive who can’t do today what she did yesterday but keeps being told that the organization is now “in a better place,” technologically speaking.

Melissa Esquibel was in the thick of early business technology innovation when hardware and systems were kept in a virtual black box, and IT gatekeepers doled out functionality within a rigid systems architecture. Now, in the present, where end-users know how to access the power of technology independently and according to the agile timelines they need, this push and pull has created quite a mess in many organizations.

With her unique experience as the conduit between the gatekeepers and the gate stormers, she offers her unique perspective as “bridge builder” to you. Her sense of humor and common sense approach will engage your team and produce results you can take to the bank in real world time savings and effective use of your organization’s resources. She brings out the best in people, coaxing out meaningful collaboration and impactful solutions.