Find Jobs
Hire Freelancers

Consolidate Excel Workbooks and Worksheets

$10-30 USD

Завершено
Опублікований over 5 years ago

$10-30 USD

Оплачується при отриманні
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
ID проекту: 17909861

Про проект

9 пропозицій(-ї)
Дистанційний проект
Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
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 день
5,0 (68 відгуки(-ів))
5,7
5,7
9 фрілансерів(-и) готові виконати цю роботу у середньому за $29 USD
Аватарка користувача
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 день
4,9 (285 відгуки(-ів))
7,7
7,7
Аватарка користувача
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 день
4,5 (68 відгуки(-ів))
5,0
5,0
Аватарка користувача
.............................................................................................................................................................
$25 USD за 2 дні(-в)
5,0 (18 відгуки(-ів))
3,5
3,5
Аватарка користувача
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 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
green brook, United States
5,0
3
Спосіб оплати верифіковано
На сайті з жовт. 31, 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)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.