Find Jobs
Hire Freelancers

Excel Expert for Data Filtering and Organizing

$10-35 USD

Completed
Posted almost 6 years ago

$10-35 USD

Paid on delivery
I have 49 CSV files that contains daily values for companies. Each file is for a specific company. I need someone filter the data in the files and look for values of end of December for each year only up to 2017. For example if a company has daily prices from 2005-2017, I will need you to locate the prices at December /29/30/31/ (depending on the year) for 2005, 2006, 2007, 2008, 2009......2017 and present that data in table that summarizes all the years. Once you have a summary table for each CSV you will input the result in one table that summarizes all the results. More clarification will be provided via chat. IT should be a simple and straightforward for someone proficient in Excel, doesn't require any calculations just data filtering, sorting and organizing in one summary workbook.
Project ID: 17062901

About the project

17 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
HI, I am good at Excel and vba. I have reviewed the details. I can filter the data and collect them into summary sheet from all csv files. Looking forward for samples to identify the range.. -Chandra
$35 USD in 0 day
5.0 (1027 reviews)
8.2
8.2
17 freelancers are bidding on average $34 USD for this job
User Avatar
Hi I am ALISON certified for Microsoft Office specially Excel and Access Database. Data Entry and Processing is my passion with years of experiences. I am very hard working and know the value of time so, always deliver work on time. My motive is to make my employer happy with quality of service
$27 USD in 0 day
4.9 (489 reviews)
8.0
8.0
User Avatar
Hi! I'm interested on working on your project. I have wide experience in data entry and excel. I know my way around filters and I'm available to start immediatly. I hope you give me a chance to work with you. Regards.
$35 USD in 1 day
5.0 (128 reviews)
7.2
7.2
User Avatar
Hello, I will do filter the data in the files and look for values of end of December for each year only up to 2017 for all 49 CSV files. I'm ready to start. Best regards, Hoang
$35 USD in 3 days
5.0 (167 reviews)
7.0
7.0
User Avatar
hello, I am an excel expert with many years experience Excel. I have finished many projects. I checked your project post and understood your requirements that you want to pull data from CSV files based on the specific filter. I will surely assist you n this. Thank you, Peter
$25 USD in 10 days
5.0 (101 reviews)
6.5
6.5
User Avatar
I am a professional with a decade of experience working with Excel and related programs. can complete your project in a given time
$35 USD in 10 days
4.9 (114 reviews)
6.2
6.2
User Avatar
- Can go through the 49 CSV files and will locate the price for December ending price for each year. - Then can derive summary table for all years... example 2005, 2006, 2007, 2008, 2009......2017 - Will provide a consolidated summary for each company for all years. My Skills: - Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs. - Extensively the macros/VBA to automate: - Data camparision using formulas, lookups and summaries., - Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells - Data camparision using formulas, lookups and bringing up summaries., - Mathematical functions, scientific calculations, index, array, formula arrays which are advanced concepts - Have used them. - With summary data plotting graphs, bringing pivot tables - Pl. review my portfolio on projects done - https://www.freelancer.com/u/satishtl.
$60 USD in 1 day
4.6 (53 reviews)
6.2
6.2
User Avatar
As an: 1- engineer in statistics and applied economic 2- specialized technician in Microsoft Office (graduated from Microsoft: Diploma MOS), I am available, able and ready to do this type of work in the best conditions.
$20 USD in 1 day
4.8 (16 reviews)
4.3
4.3
User Avatar
Hi, I can do the filtering as per the desired dates, and organizing the results in a new sheet. Thanks for reading my proposal and taking it into consideration. Please, let's chat for more details.
$20 USD in 1 day
5.0 (2 reviews)
2.8
2.8
User Avatar
Hello, I'm interested in your project. Please send me a message so that we can discuss more. I have a good knowledge in Excel and data entry.I will accomplish this task in the given budget and time with 100% accuracy. Thanks! Abhishek Sinha
$27 USD in 2 days
5.0 (2 reviews)
2.3
2.3
User Avatar
Dear, Taking into account your project, I offer my services to do it I have the skills to do it and time. Best regards.
$20 USD in 3 days
4.9 (3 reviews)
2.1
2.1
User Avatar
i have experience in excel so you will get your work quickly *********************************************************
$10 USD in 1 day
5.0 (1 review)
0.9
0.9

About the client

Flag of UNITED STATES
Richardson, United States
5.0
38
Payment method verified
Member since Apr 7, 2016

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.