Focused Skills lab: Data Cleanup with Text Formulas
One video course to improve your Excel skills
Enroll in Course
You’ve just done a data audit and now you’re overwhelmed with data errors: misspelled city names, zip codes that don’t look right, emails with .net instead of .com and vice versa…where do you even start fixing all of these problems?
Let Microsoft Excel do all the heavy lifting for you. With Greg Duke’s class, "Data Cleanup with =LEN() and other Text Tools", you’ll learn many clever ways of using Excel’s text formulas and tools to help you clean up your organization’s database — and also how to find problems in a data file before you upload it in the first place!
You’ll learn how you can identify problems with an address line by breaking it into its constituent pieces, how to fix commonly misspelled city names, how to identify genuine duplicate records in your database, and how to prevent common types of incorrect data from being entered into an Excel document.
Data Cleanup with =LEN() and other Text Tools will help you learn how to clean up your database faster and with a lot less stress.
Your Instructor
For over 20 years, Greg Duke has worked in fundraising organizations in the United States and the United Kingdom, working primarily in database management and prospect research.
Duke helps Raiser’s Edge clients to optimize their database by implementing data clean-up techniques and creating reporting structures, including dashboards and SQL queries. He also facilitates data imports into Raiser’s Edge and database administration.
Duke has worked at the University of Oxford, Niagara University, Florida International University, and the Rochester Institute of Technology. He has lectured at several APRA International and regional conferences, and previously taught a fundraising course at Niagara University. Duke earned a D.Phil in modern history from Jesus College, University of Oxford.