Data Cleaning and Harvesting

During investigations, you will often find documents in different formats, making data analysis difficult and progress a challenge. Learning new Excel techniques for data cleaning is an essential step to transform this "chaos" into a clear and organized format. Along with the data harvesting techniques you will learn in this course, you will be able to quickly identify suspicious transactions that might indicate illicit activity.

Take your skills to the next level by learning how to:

• Prepare financial documents for data analysis
• Apply Excel functions to fix formatting errors
• Identify additional sources of financial data
• Use OCR software to digitise hard copies and export data
• Scrape data from websites.

This course is self-paced. You can start, take breaks, and continue at any time. It is structured in sessions that build on each other, so we recommend you start with Session 1.After completing the course, you will be eligible for a certificate of completion.

Note: If you are new to analysing financial data, we recommend you start with our course on Financial Analysis using Excel