Job Posted: 01.09.2021 7:58:24
Hi there, I am looking for an expert to deal with some manual data check. I would like you to help me go over around 26,000 announcements about CFO change, find out who they are and fill up their information in this excel. The project takes 10 days and we do require accuracy. Here are the detailed steps of the task: 1. Open the sheet ‘Task’, Read the column ‘Key.Development.Situation’ to find the new CFO and the leaving CFO (leave it blank if there is no information). 2. Open the sheet ‘CFO ID Reference’, search the company ID, and then check if the CFO in step 1 has a record here. 3. If Yes, fill up the column H and K using the name and person ID presented in ‘CFO ID Reference’ to fill up the column H:M. If No, just leave it blank. 4. Lastly, find the effective date for each change. If it says "effective immediately" then use the announcement date in column A. Leave it blank if there is no information.