Kapalı

Excel data sorting and data entry

OVERVIEW

1. This is not a complex job. It is easy sorting and some data entry.

2. We will run the project over at least four stages. Please provide your price for ALL four stages. We will create milestones for each stage.

3. Our client needs their household budget prepared. They want 12 months of data sorted and given a description (such as Fast Food, Doctor, Supermarket etc).

4. We will provide you with an Exel spreadhsheet containing each month's data. Note that there are fewer than 100 rows and only four columns per sheet. See uploaded file as an example.

STAGE ONE

Combine all 12 months into the spreadsheet named Master (there are fewer than 100 rows and only four columns per sheet).

Sort by column D. Then delete any rows without data in column D. This then becomes your "Reference"for future work.

STAGE TWO

Start with August and work through to July (12 files in total).

Within each row, you need to enter a description in column D. To work out the description, you can search in the REFERENCE file you created in Stage One.

If you are unsure what to put in column D, type in Unsure and highlight that row with yellow highlight.

If you guess something, for instance a Doctor, highlight that row in yellow.

STAGE THREE

Sort each month by description (row D).

Then in row E, add up the total for all items within that description and enter the total against the first entry.

STAGE FOUR

Our client will need further work prepared for their credit cards and other financial transactions.

FINAL NOTE

So we are confident you have read and understood this task sheet, at the end of your submission tyype the word "BUDGET".

Thank you.

Beceriler: Excel, Veri Girişi, Veri İşleme, Word, Visual Basic

Daha fazlasını gör: excel spreadsheet vba data entry form, visual basic applications excel sorting data, excel macro oracle data entry, excel web allow data entry, data entry data base excel sheet, excel front end data entry access, excel skills needed data entry work, excel macros forms data entry, data entry data sorting, excel postal code data entry, Data Entry Data Processing Excel , entry data processing di excel, excel automatic daily data entry, excel time entry data capture, excel script entry data form

İşveren Hakkında:
( 0 değerlendirme ) Montreal, Canada

Proje NO: #20923101

Bu iş için 31 freelancer ortalamada $20/saat teklif veriyor

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Daha Fazla

$20 USD / saat
(343 Değerlendirme)
8.0
proffesor1

Hi, I know excel and data manipulation very well and can perform your project accurately and in line with description. I estimate price for all stage stage 1 - 60 USD (or 3 billed hours) stage 2 - 100 USD (or 5 billed Daha Fazla

$20 USD / saat
(29 Değerlendirme)
7.2
polarjin2017

Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. This is what i have done in Excel/Word/PPT/Access/VBA/MACRO. Just Creating forms, query, Macro, custom formu Daha Fazla

$25 USD / saat
(98 Değerlendirme)
6.7
bhupendrayadav

I have gone through all 4 stages and understood well, I can process the client's data as per rules mentioned in these 4 stages.. Please find below a brief introduction of myself. I am postgraduate with more than 5 yea Daha Fazla

$25 USD / saat
(29 Değerlendirme)
4.9
rIbrarahmed

hi, I am very good in Excel vba, macro, chart etc. if you want to see my excel skills i can share with you some of my work on excel. I understand the value of deadline and do not compromise on quality. Price will disc Daha Fazla

$15 USD / saat
(25 Değerlendirme)
4.6
ironstar20311

( ͡ᵔ ͜ʖ ͡ᵔ ) Hello, sir! I am happy to put my bid on your project. I have a full of experience with data processing using Excel formula and VBA. Here are projects I have done recently using Excel VBA and formulas. ==== Daha Fazla

$20 USD / saat
(16 Değerlendirme)
3.8
SecureForYou

Hi dear, Nice to meet [login to view URL] for taking your valuable time for reviewing my proposal. I am a senior web site developer. I've just checked your description. I have a confidence that I can complete your project in Daha Fazla

$22 USD / saat
(2 Değerlendirme)
3.2
lalitsharma11

Hi, I have read your requirements and ready to start immediately. I have 3 years experience in data entry and web research. Please visit my profile for details. I will charge only 60$ to fo this job. I can assure you Daha Fazla

$15 USD / saat
(4 Değerlendirme)
3.0
dataEntryExperty

I will do it for you. How much time do you have. Please let me know if more details on chat. Already completed many projects

$15 USD / saat
(15 Değerlendirme)
3.1
dicadio

dear Sir, I'm interested with your task, I have experienced data analyst with excel or else database format. here for each stage stage 1,3,4 @$10 , stage 2 $20 I think more longer time needed I understood you requi Daha Fazla

$16 USD / saat
(1 Yorum)
2.7
fastestJohn

Hello. I have just read your project. https://www.freelancer.com/u/fastestJohn?w=f This is my profile. I am really interested in your project now. Because my skills are suitable for your project. I like the "Fastest" a Daha Fazla

$20 USD / saat
(2 Değerlendirme)
2.7
SusanTeke

Hi there! I've been involved in administration of a large educational institution and I'm familiar with most of the tasks you describe. 1. Combining all spreadsheets into "MASTER" - 3 hours work. 2. Categorizing expens Daha Fazla

$15 USD / saat
(4 Değerlendirme)
2.4
donSene

Hello, I can do this within very short period of time, because you have given instructions very clearly. If you’re interested on my portfolio and profile please leave a msg, I’m 24*7 available for you. BUDGET Thx

$55 USD / saat
(7 Değerlendirme)
2.4
habalghost22

Hi , I am an MBA professional have 4yrs of experience in Analytics, Tableau, Advanced Excel, VBA and Python. I have done ample amount of work in excel and VBA. You can have a look at my portfolio to get a glimpse of th Daha Fazla

$15 USD / saat
(4 Değerlendirme)
2.3
daheriyakeshav

Hi, With the details you provided, the task becomes quite easy. The attachment is missing now and it will become much easier if you please send the attachment. I have more than 12 years of experience working with one Daha Fazla

$15 USD / saat
(6 Değerlendirme)
1.6
prasadanxian

"Work is worship" I will do any work by placing my efforts. and I have an experience of 5 years in the Data Entry field. last but not least, Your work is my accurate efforts.

$16 USD / saat
(0 Değerlendirme)
0.0
sgjunghans

I am capable and efficient with data entry and analysis, and will be able to quickly and accurately analyze the year of financial transaction information given to me. BUDGET

$15 USD / saat
(0 Değerlendirme)
0.0
Monil1989

Hi, I hope you are having a fantastic day! I have experienced in Data mining, Data Entry, Web Researcher, Data verification; Form filling, Document verification, Mortgage processes such as Loan Underwriting, Loan P Daha Fazla

$15 USD / saat
(0 Değerlendirme)
0.0
amanpreet19927

I guarantee the quality of work provided to you as I have 7 years of experience in business process outsourcing clients from united states. Providing error free work will be one of my objective along with within the ag Daha Fazla

$15 USD / saat
(0 Değerlendirme)
0.0
santhoshmahanty

Good afternoon,i would like to data entry works ,i have good work and need work also. Good afternoon,i would like to data entry works ,i have good work and need work also.

$20 USD / saat
(0 Değerlendirme)
0.0