Excel Sheet Merge and Email Marketing Platform Upload at Rhine Valley Goods

I recently completed a project for P23Labs, where I was responsible for merging two Excel sheets and uploading the merged file to the email marketing platform, Brevo. The primary objective was to combine data from both sheets into a single, cohesive file while ensuring utmost accuracy and consistency. Breakdown of my Work Data Consolidation: Carefully reviewed both Excel sheets to understand their structure and content. Merged the data by aligning similar columns and combining rows as necessary. Utilized advanced Excel functions and formulas to ensure the integrity and accuracy of the merged data. Data Accuracy and Consistency: Conducted thorough checks to identify and correct any discrepancies or inconsistencies in the data. Ensured that all data entries were uniform and adhered to the required format. Verified the accuracy of merged data by cross-referencing with the original sheets. Proficiency in Excel: Employed various Excel tools such as VLOOKUP, pivot tables, and conditional formatting to streamline the merging process. Automated repetitive tasks to enhance efficiency and reduce the possibility of human error. Uploading to Brevo: Prepared the final merged file in the format compatible with Brevo. Successfully uploaded the file to the Brevo platform, ensuring that all data was correctly transferred. Conducted a test campaign to verify that the data upload was successful and that the email marketing platform was functioning as expected. Attention to Detail: Maintained a meticulous approach to every step of the process, from data merging to uploading. Double-checked all entries to guarantee that no data was lost or incorrectly entered during the transfer. Outcome: The project was completed within the specified timeframe, and the client was highly satisfied with the accuracy and quality of the merged data. The successful completion of this small-scale task has opened up opportunities for additional similar projects in the future. Skills Utilized: Advanced Excel data manipulation Email marketing platform proficiency (Brevo) Attention to detail and accuracy Data consistency verification Project management and timely delivery