Data Organization via Excel

Step 1:

Sort and Filter List 1 to remove all data entries of employees with an email address ending in @[login to view URL]

Also remove all entries for those people who have no email address listed (blank email field)

Each person on this new list should only have an email address that does not end in @[login to view URL]

Save this new filtered list file as: Contractors

Step 2:

Add filtered data from List 1 and Consolidate with List 2

List 2 should now have all data entries from filtered List 1 plus existing data entries in List 2

Save this new filtered List as file: Contractors and Employees

Step 3:

Cross Reference List 2 with List 3 and remove all data entries for those people who do not appear in List 2.

List 3 should only contain data entries for the specified entries in List 2 – Remove all other entries

Please Note: the same person may have multiple entries under their names. Please ensure all entries remain on the list. The first name, last name and email address will be the same, however the course name in field H will be different. Must retain records for all the different courses that a single employee has taken.

Save this new filtered list as file: Reports

Skills: Excel, Data Entry, Data Processing, Web Search, Web Scraping

See more: export data database excel aspnet, acces data base excel, data entry excel india, feed data internet excel, getafreelancercom extract data website excel sheet, read data website excel, problems data cleansing excel, xml data url excel, create front end data entry excel, extract data excel reports, data mining excel course, data organization excel folder, https freelancer projects data entry excel need contact list organization

About the Employer:
( 0 reviews ) Prague, Czech Republic

Project ID: #20867481

41 freelancers are bidding on average €14/hour for this job


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community (g More

€18 EUR / hour
(714 Reviews)

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl More

€18 EUR / hour
(329 Reviews)

Hi There, I am an advanced excel specialist. I have absolutely understood your requirements. I will complete all the three "Steps" exactly as per the requirement. Can you please send me the spreadsheet via Chat in or More

€15 EUR / hour
(89 Reviews)

Can you please send me your all excel lists please now? Ready to Organize your excel lists very FAST. Highly Expert and Experienced in EXCEL DATA organizing here.

€12 EUR / hour
(213 Reviews)

Hi, I have examined your project description about organizing, sorting and filtering data in Excel spreadsheet. You can be confident that this project will be professionally completed. Before you award this project, I More

€15 EUR / hour
(52 Reviews)

I am a professional with a decade of experience working in a US based NASDAQ registered company with all the knowledge and skills required for your project. Please send me a message and we can start working.

€12 EUR / hour
(66 Reviews)

Hello, I have substantial experience in excel and VBA, and I will be happy to assist you with your data formatting job. Please share your project details over chat. BR, Razvan

€15 EUR / hour
(16 Reviews)

Experienced project professional, MBA, EXCEL expert, strong estimating background, experienced with complex formulas, LOOKUPS, PIVOTS, and charts towards the delivery financial analytics. Very experienced with data sh More

€12 EUR / hour
(24 Reviews)

Hi, nice to meet you. I am database expert in IT company. I am top in database field in my company. I have been working database expert for 8 years. My skill is Python, Mysql, Postgresql, Excel, deep mathematician know More

€12 EUR / hour
(9 Reviews)

------------------------------------------------------------------------------- HELLO! As an: - Bachelor of Applied Mathematics - Engineer in Statistics and Applied Economics - Microsoft Office Technician (Microsoft G More

€15 EUR / hour
(7 Reviews)

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp More

€15 EUR / hour
(10 Reviews)

€ 12 ONLY!!! In just 2 HOURS!! [EXCEL VBA MACRO & FORMULA EXPERT] <<<100% SATISFACTION first, then PAYMENT>>> Sir, please CONTACT with me, I can complete your PROJECT absolutely as per your requirements within LEAST More

€12 EUR / hour
(19 Reviews)

Good day Sir/Madam. I am an accountant from South Africa and I have extensive excel and MSOffice experience. I specialise I excel report design, but can do most tasks needed in excel. I have a solid understanding of ac More

€12 EUR / hour
(3 Reviews)

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this through a VBA script. It will be quick and accurate. If interested, we can discuss this further on chat.

€12 EUR / hour
(4 Reviews)

Hi there! I've been working with Microsoft Excel for years and I'm proficient in most of the built-in formats and functions. I believe I'll be able to process your worksheets as you specify to make your employee data e More

€12 EUR / hour
(4 Reviews)

Hello Sir I am interested in organizing data in Excel. I am an experienced Excel user. I assure you of the top-notch quality work to your satisfaction and look forward to work in collaboration with you offering the be More

€15 EUR / hour
(2 Reviews)

Dear Hiring Manager, Good day. In response to your job posting, I would like to send our proposal. I believe we are capable of providing you the service that you require with optimum results. We offer accurate, reli More

€12 EUR / hour
(2 Reviews)

Hi, I have got a vast experience in excel working with one of the top5 MNC worldwide and have worked in complex excel solutions with filtering, sorting, pivoting, formula, advance excel etc. With the explanations you More

€12 EUR / hour
(6 Reviews)

Hi, I am writing this after reviewed your project description. I am interested in your project and Kindly drop a message so we can discuss. 3+ years experience of following types of Work: 1. Lead list development, as More

€12 EUR / hour
(1 Review)

Greetings, I understand your project description. I think you want a person for your project who expert in Data Entry. I think there is no detailed discussion of the work here. So, we can discuss more work? First More

€12 EUR / hour
(0 Reviews)