Available Spaces: 19
Contact Details: Paul Atwell: email@example.com
Raw data often requires cleansing to make it meaningful, useful and usable. This course is for those requiring an understanding of the techniques available to cleanse data. The course also demonstrates the usage of the functions: CLEAN, TRIM, SUBSTITUTE, SEARCH, REPLACE, LEFT and MID.
This course is ideally suited to those who already have a good working knowledge of Excel.
- Data cleaning functions
- Text substitution functions
- Using Flash Fill
- Finding the correct text
- De-duplication techniques
- Using Text to Columns to clean data
- Working with American formatted dates
- Reformatting offset headings
This session is 30 minutes in duration with an additional 15 minutes for a Q & A session which you are not obligated to remain for.