Find Jobs
Hire Freelancers

Excel Expert for Data Filtering and Organizing

$10-35 USD

Ukończony
Opublikowano prawie 6 lat temu

$10-35 USD

Płatne przy odbiorze
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.
Identyfikator projektu: 17062901

Informację o projekcie

17 ofert
Zdalny projekt
Aktywny 6 lat temu

Szukasz sposobu na zarobienie pieniędzy?

Korzyści ze składania ofert na Freelancer.com

Ustal budżet i ramy czasowe
Otrzymuj wynagrodzenie za swoją pracę
Przedstaw swoją propozycję
Rejestracja i składanie ofert jest bezpłatne
Przyznano:
Awatar Użytkownika
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 w 0 dzień
5,0 (1027 opinii)
8,2
8,2
17 freelancerzy składają oferty o średniej wysokości $34 USD dla tej pracy
Awatar Użytkownika
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 w 0 dzień
4,9 (489 opinii)
8,0
8,0
Awatar Użytkownika
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 w 1 dzień
5,0 (128 opinii)
7,2
7,2
Awatar Użytkownika
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 w 3 dni
5,0 (167 opinii)
7,0
7,0
Awatar Użytkownika
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 w 10 dni
5,0 (101 opinii)
6,5
6,5
Awatar Użytkownika
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 w 10 dni
4,9 (114 opinii)
6,2
6,2
Awatar Użytkownika
- 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 w 1 dzień
4,6 (53 opinii)
6,2
6,2
Awatar Użytkownika
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 w 1 dzień
4,8 (16 opinii)
4,3
4,3
Awatar Użytkownika
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 w 1 dzień
5,0 (2 opinii)
2,8
2,8
Awatar Użytkownika
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 w 2 dni
5,0 (2 opinii)
2,3
2,3
Awatar Użytkownika
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 w 3 dni
4,9 (3 opinii)
2,1
2,1
Awatar Użytkownika
i have experience in excel so you will get your work quickly *********************************************************
$10 USD w 1 dzień
5,0 (1 opinia)
0,9
0,9

O kliencie

Flaga UNITED STATES
Richardson, United States
5,0
38
Zweryfikowana metoda płatności
Członek od kwi 7, 2016

Weryfikacja Klienta

Dziękujemy! Przesłaliśmy Ci e-mailem link do odebrania darmowego bonusu.
Coś poszło nie tak podczas wysyłania wiadomości e-mail. Proszę spróbować ponownie.
Zarejestrowani Użytkownicy Całkowita Liczba Opublikowanych Projektów
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Wczytywanie podglądu
Udzielono pozwolenia na Geolokalizację.
Twoja sesja logowania wygasła i zostałeś wylogowany. Proszę, zalogować się ponownie.