Find Jobs
Hire Freelancers

Consolidate Excel Workbooks and Worksheets

$10-30 USD

Teljesítve
Kiadva ekkor: több mint 5 évvel ezelőtt

$10-30 USD

Teljesítéskor fizetve
I have ~80 excel files all using the same template (number and name of sheets). I wanted to combine the files so there is only one file and only 7 sheets from the original files consolidated into 5 master sheets. Some of the excel file contain duplicate rows, so this would need to be checked to confirm we are not pulling in any duplicates. Preferably, the file I receive once done would actually be 2 files - a master file with every row (including the duplicate rows) and a file which has been adjusted to filter out duplicate rows. See sample of 2 files attached. Notes: 1. Company Financials - please eliminate all rows that identify the Year as "Current." Only include rows where an actual year (e.g. 2015, 2016, 2017) is present. Check for duplicates once consolidated 2. Company List - consolidate all files; check for duplicates 3. Compensation Details - please eliminate all rows that identify the Year as "Current." Only include rows where an actual year (e.g. 2015, 2016, 2017) is present. Check for duplicates once consolidated. Each individual should only have 1 row for each year at each company. 4. Option Details (Time-Vested) - Consolidate across all files. Checking for duplicates might be a little tricky since an individual can have more than 1 row for each year 5. Stock Details (Time-Vested) - Consolidate across all files. Checking for duplicates might be a little tricky since an individual can have more than 1 row for each year 6. Performance Incentive Details - Consolidate across all files. Checking for duplicates might be a little tricky since an individual can have more than 1 row for each year 7. Outstanding Equity - Consolidate across all files. Checking for duplicates might be a little tricky since an individual can have more than 1 row for each year
Projektazonosító: 17909861

A projektről

9 ajánlat
Távolról teljesíthető projekt
Aktiválva: 5 évvel ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
Neki odaítélve:
Felhasználó avatár
Hi, I am ready for your project. I am excel expert and this project is easy for me. I am waiting for your message. Thanks
$20 USD 1 napon belül
5,0 (68 értékelés)
5,7
5,7
9 szabadúszó adott átlagosan $29 USD összegű árajánlatot erre a munkára
Felhasználó avatár
This is Vibrant Webtech and I was glad to see that you're looking for help for project Consolidate Excel Workbooks and Worksheets. I've delivered more than 400 + projects in the last 5 years and this makes me very confident with your task.I'd like to have more details before proceeding. This way I'll have the chance to elaborate m bid accordingly. I never ask for payments in front. I will only ask you to release the agreed milestones once the task for each one of them is met and you're happy with it. Feel free to visit my personal page on this platform and get an idea of how satisfied my clients are from my work. Don't hesitate to contact me. I'm looking forward to hearing from you soon.I have more than 5 year of experience in Data Entry, Data Processing, Excel, Microsoft Office, Word. Please ping me for more discussion.
$50 USD 1 napon belül
4,9 (285 értékelés)
7,7
7,7
Felhasználó avatár
Hello There , Thank You For The Opportunity. As per your requirement, i would like to tell you that i have a very strong experience of more than 5 years in the field of Data entry , Data Extraction , Web Search . Spare a moment to take a look at my reviews . My Regards
$30 USD 1 napon belül
4,5 (68 értékelés)
5,0
5,0
Felhasználó avatár
.............................................................................................................................................................
$25 USD 2 napon belül
5,0 (18 értékelés)
3,5
3,5
Felhasználó avatár
Sir, thank you for your posting job. I have checked your job description carefully and I'm very confident I can complete this project perfectly without any fault.
$20 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Thank you very much for the opportunity to bid on this project. I can assure you of my attention to detail and it will be completed with all of your instructions at the heart of what I do. With plenty of experience in this area, coming from an administration and management background, your project will be completed in a very timely fashion. Although I am Australian, I spend a lot of time in the United States, particularly in the Greater Los Angeles region.
$30 USD 1 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
I have over 15 years working at advanced level with excel and VBA, being able to provide a fast deployment speed and flexibility upon the specific or your technical demands. I am ready to create and customize reports that are specific to your needs and edit them on the fly with the power and flexibility of Excel formatting tools. In my everyday work I am dealing with scheduled reports where I have reports created and delivered automatically, in a variety of file formats, right from Excel. At the same time I am able to portrait a multi-report suite access, where I provide insights into individual sites, business units, and departments by creating reports that span multiple report suites.
$35 USD 5 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Hi, I am Akshay. I have been working in a BPO since 2 years and hold a decent experience in the particular firm. I work for a company from Texas and I provide superior customer service. Assuring you the best Quality as I am designated as the Quality Analyst for the company. I can type 65 WPM with 100% accuracy and I hold a decent experience in Online Data Entry and Data Mining. I may be new on freelancer, but offline, I have 2+ years of experience working for BPO as a Sales Agent, Coach and currently as a Quality Analyst. I mostly work on Excel sheets as I am a Quality Analyst and need to generate reports and data on daily basis. I have worked in an environment where English is the only language spoken which helped me in grooming my communication skills a lot. I work closely with clients and hold a great experience in handling them by providing Superior services. I believe in delivering Quality work every time and working with the best of my abilities. I love to learn and always seek learning opportunities. I assure you whatever I will do, I will do it with the best of my abilities to provide upmost Quality. I am willing to do anything under my control to prove my worth and provide you with superior service. You can contact me here anytime to discuss further details. Looking forward to work with you and establish long term relations. :)
$25 USD 2 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

UNITED STATES zászlója
green brook, United States
5,0
3
Fizetési mód hitelesítve
Tagság kezdete: okt. 31, 2016

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.