Find Jobs
Hire Freelancers

Excel Expert for Data Filtering and Organizing

$10-35 USD

已完成
已发布将近 6 年前

$10-35 USD

货到付款
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.
项目 ID: 17062901

关于此项目

17提案
远程项目
活跃6 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
颁发给:
用户头像
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 在0天之内
5.0 (1027条评论)
8.2
8.2
17威客以平均价$34 USD来参与此工作竞价
用户头像
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 在0天之内
4.9 (489条评论)
8.0
8.0
用户头像
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 在1天之内
5.0 (128条评论)
7.2
7.2
用户头像
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 在3天之内
5.0 (167条评论)
7.0
7.0
用户头像
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 在10天之内
5.0 (101条评论)
6.5
6.5
用户头像
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 在10天之内
4.9 (114条评论)
6.2
6.2
用户头像
- 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 在1天之内
4.6 (53条评论)
6.2
6.2
用户头像
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 在1天之内
4.8 (16条评论)
4.3
4.3
用户头像
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 在1天之内
5.0 (2条评论)
2.8
2.8
用户头像
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 在2天之内
5.0 (2条评论)
2.3
2.3
用户头像
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 在3天之内
4.9 (3条评论)
2.1
2.1
用户头像
i have experience in excel so you will get your work quickly *********************************************************
$10 USD 在1天之内
5.0 (1条评论)
0.9
0.9

关于客户

UNITED STATES的国旗
Richardson, United States
5.0
38
付款方式已验证
会员自4月 7, 2016起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。