Data Consolidation and Filling in Excel
Budget: ₹750 – ₹1,250 INR
I'm looking for an experienced Excel expert to help me with a data consolidation task. The job involves:
- Combining text, numbers, and vendor details from several spreadsheets.
- Organizing the combined data in two separate worksheet, column headers existing.
- Filling in the missing data from each spreadsheet.
Ideal skills and experience for this job include:
- Proficiency in using Excel functions for data consolidation and filling in.
- Ability to work with data from different excel sources.
- Attention to detail to ensure accurate data entry and consolidation.
Two have one column that matches so I think a vlook up would work but the others are blank sheets with header columns that need filled in based on the combined data from the first two sheets. Should be relatively easy for an experienced Excel user, which I am not.
ETA: May ask for data entry in web based version of Primavera once data from spreadsheets has completed. Once we have those two complete, I will import into Primavera and then additional data will need to be matched manually. Will show you exactly what needs done. Very simple but tedious and requires great attention to detail.
- Combining text, numbers, and vendor details from several spreadsheets.
- Organizing the combined data in two separate worksheet, column headers existing.
- Filling in the missing data from each spreadsheet.
Ideal skills and experience for this job include:
- Proficiency in using Excel functions for data consolidation and filling in.
- Ability to work with data from different excel sources.
- Attention to detail to ensure accurate data entry and consolidation.
Two have one column that matches so I think a vlook up would work but the others are blank sheets with header columns that need filled in based on the combined data from the first two sheets. Should be relatively easy for an experienced Excel user, which I am not.
ETA: May ask for data entry in web based version of Primavera once data from spreadsheets has completed. Once we have those two complete, I will import into Primavera and then additional data will need to be matched manually. Will show you exactly what needs done. Very simple but tedious and requires great attention to detail.