Concluído

Data Cleaning and Coding

I'm a PhD student wanting to outsource some data cleaning. I have a small amount of Excel data that needs to be re-coded in several ways and turned into an access database. I expect I will have a lot more work to offer as this project progresses.

There is name data in the format "John Smith" that needs to be converted to "John_Smith". The data is a 2 column set of relationship data (Column A has relationship with corresponding cell in Column B). An individual ID code needs to be attached to every unique name appearing in the data and another unique code to every relationship Then an access database with approximately 5 fields needs to be created from the Excel data.

Habilidades: Excel, Excel Macros, Excel VBA, Microsoft Access

Veja mais: who created the adidas logo, translate the sentence to afrikaans there is no formal education or cirtificate requirements to become a fashion designer you wi, computer data entry operator of the departments ministries boards authorities in srilanka, data cleaning procedures, contingency cleaning, data cleaning in research methodology, data cleaning spss, cleaning data for statistical analysis, data cleaning process steps, data coding, data cleaning in quantitative research, sql, excel, microsoft access, project is to develop a filesystem and the functions that control access to and manipulation of the filesystem there are two par, data analysis coding, data entry coding excel, data entry coding tool, data entry coding, registry cleaning coding freelance

Acerca do Empregador:
( 0 comentários ) Australia

ID do Projeto: #16719373

Concedido a:

rinabuoy13

Hello there, I am well-versed in excel. I can help you with this task. Looking to hearing from you soon.

$12 AUD / hora
(23 Comentários)
4.1

13 freelancers estão ofertando em média $11/hora para esse trabalho

zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Access/VB. I'm Ms Access/VB/SQL/Access/Excel programmer since 1997. Really all my projects here I've developed for Ms Mais

$12 AUD / hora
(45 Comentários)
6.1
customizedata

Please provide sample excel [login to view URL] clarify some points 1- Are all names in the format Firstname space Lastname (John Smith) ? we can write code (VBA) to replace space with underscore(_). 2- Please Mais

$12 AUD / hora
(37 Comentários)
5.2
supergana

Hi - I am an IT professional with 2 decades of experience. I have 2 patents in US. As far as excel is concerned i am quite well versed with the technology which i have mastered over 2 decades. I can handle simple e Mais

$14 AUD / hora
(15 Comentários)
3.9
sunitagiriprad

Dear Hiring Manager, Over all 15 years of IT industry experience. Development of Web Application and Windows bases Application using Microsoft Technologies Knowledge and experience of following tools o Visual St Mais

$11 AUD / hora
(8 Comentários)
3.3
TechNamrata09

Hello Sir, Thanks for the requirements, I can do perform following activities : 1) Date Separation using Excel related functions, ( VLookUp, HLookUp, Conditional Formatting, Text To Column, If etc) 2) Excel VBA M Mais

$8 AUD / hora
(4 Comentários)
2.2
$8 AUD / hora
(0 Comentários)
0.0
jescahrose

A proposal has not yet been provided

$8 AUD / hora
(0 Comentários)
0.0
bryanbarcoma06

Hi, I worked as an auditor/accountant for 9 meaningful years and now a full-time freelancer. I believed that my excel expertise could help you for this work. Part of our daily task is to work on an excel for the easy c Mais

$11 AUD / hora
(0 Comentários)
0.0
$8 AUD / hora
(0 Comentários)
0.0
unexpectedrich

I can design and create any macro or vba code in MS Excel. Waiting for your service. Thankyou.

$16 AUD / hora
(0 Comentários)
0.0
$12 AUD / hora
(0 Comentários)
0.0
bcusack1996

A proposal has not yet been provided

$12 AUD / hora
(0 Comentários)
0.0