Vlookup Tables Jobs

2 were found based on your criteria {{ paging.total|number:0 }} were found based on your criteria

show all
  • Hourly ({{ jobTypeController.getFacetCount("0")|number:0}})
  • Fixed Price ({{ jobTypeController.getFacetCount("1")|number:0}})
Hourly - Intermediate ($$) - Est. Time: Less than 1 month, Less than 10 hrs/week - Posted
Looking for an experienced excel professional to help me build a budget sheet that allows the input of expenses (time & material) as they are incurred and compare against the budgeted numbers. I would also like to build a couple customer facing sheets (bill of materials, quote, etc.) that are automatically populated with data entered into the original estimation sheet, like part descriptions, part numbers, etc. The sample file shows three sheets, estimation, product data base and budget. I've already created something that does the math, but it's tied to this particular spreadsheet and I'm not able to create others using this form. Currently, the "product data base" is not working as expected and I'm basically cutting/pasting data from there to the estimation sheet. I'm okay with this, but need to remove the formulas that a previous Excel guy created.
Skills: VLookup Tables Excel VBA Microsoft Excel Microsoft Excel PowerPivot
Hourly - Intermediate ($$) - Est. Time: More than 6 months, 30+ hrs/week - Posted
JOB DESCRIPTION The person applying should have prior experience working with large set of data since most of the files will have five to thirty thousands of rows. The person should be comfortable with function like vlookup, hlookup, filter, conditional formatting, delete double, advanced copy paste (verticaly to horizontaly, data only...), formula to copy several text cell to one text cell (ex: Column1&Column2&"text1"&(if(Column3=yes),Column4,blank)... ) If you know excel macro, you will be able to save a lot of time. For Most of our customers you will need to work on the excel documents and upload it into their backoffice. Also we have one large retailers, that need manual dataentry. Means you will be better with 2 screens, and you will do a lot of copy paste to add manually each products Key Responsibilities: - Candidates with a strong inclination towards numbers, excel spreadsheets, formulae, queries and software applications - Must have Excel, not google sheets - Strong Excel Skills - Ability to format and transfer the information from one excel document to another excel document that have similar column field but different format - Basic SEO Understanding - Good english Writing Ability - Researching - Internet Speed – Screen shot (need to download sometimes a lot of large images) - Review data for deficiencies or errors, correct and incompatibilities if possible and check output Time We added new products every weeks, so the job will be all the times. We have freelancer from Odesk that work directly with our company since 4 years (wayfair, walmart, overstock, groupon, staples, amazon, ebay ...) If you have experience with one of the retailers listed above, it will be a real plus for your application (send me screenshot of retailers backoffice in this case) . Please send us experience, similar job experience, screenshot of different excel document that you worked with... Thanks
Skills: VLookup Tables Data Entry Microsoft Excel