Overview: You will make 3 spreadsheets in Excel from 1 master spreadsheet. You are updating the 2 Ski Trip Directories on SkiMegaMeetup.com. They are linked to the homepage so you can see the 2 old ones before you start. The third spreadsheet will be a few rows of “outdated groups”. The final spreadsheets will only be 1 column wide. Skills needed: -Be able to sort 8 columns by 200-300 rows of data. -Be able to condense several columns into one column with data separated by dashes. -Be able to make URLS into hyperlinks for all rows of data. -Job also includes checking websites & inputting data. Detail: Open a new spreadsheet and label 8 columns -State, Destination, Dates, Ski Club, URL, Meetup, Contact name, email address. Go to SkiMegaMeetup.com. Click on "65 NYC metro ski club links" Copy this into the ski club column keeping all the hyperlinks. send this to me to check. click on the first club. If their website no longer works, please cut that row and past it onto the outdated groups spreadsheet. If their website does work, check their website. Make a row for each ski trip they offer including the 7 other data items requested. Write Meetup in the column if the trip is advertised with a page on Meetup.com. If the same trip is advertised on [url removed, login to view] as the website, just include the link to [url removed, login to view] so the trip isn’t duplicated. Repeat for the first 6 clubs. Send to me for check. Repeat for the rest of the clubs. Send to me for check. Sort the spreadsheet alphabetically by destination, then State, then date. Make those 3 columns plus the Meetup and the ski club columns into one column (5 columns concatenated) separated by dashes where the column used to be. Make each row of the one column spreadsheet clickable with the corresponding trip URL. Done with spreadsheet 1! Go back to the master spreadsheet. Sort by Date, then destination, then state. Make those 3 columns plus the Meetup and the ski club columns (5 columns concatenated) into one column separated by dashes where the column used to be. Make each row of the one column spreadsheet clickable with the corresponding trip URL. Done with spreadsheet 2!
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 215 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Daha Fazla
Bu iş için 11 freelancer ortalamada $206 teklif veriyor
Hi, I would like to work on this project. I have done a lot of similar project of this. So willing to response to provide you sample before awarding this project. Hopefully you will me chance to work on this project Daha Fazla
Dear Sir, quality and expert researcher here to search a targeted group of people, images, email addresses, database or anything that you are needed you may hire me in full confidence.
Hi: Please note that I have 100% completion rate and 5-star feedback on projects. More than 90% of my completed projects are related to Excel. Please connect with me to discuss more.
Hi there, I've been working with Excel since before '98 and I've been using all possible versions of it. I have years of experience working with macros and writing / debugging VBA code. You may check my portfolio Daha Fazla
Dear Sir, I am extremely interested to your project and ready to start immediately. Sir if you give me chance I can do this job. I see your project and i do it as your acceptation. I have 3 years experience to wor Daha Fazla
hi there i have a good team to do expert work of web scraping and info finding all around the world. i get data lists having name , address, email, fax, postal codes and map data. just award me with little info of you Daha Fazla
i am interested to work on this [url removed, login to view] data will be loaded on 3 excel sheets from 1 major [url removed, login to view] will be surely done as per your [url removed, login to view] for your response.
Sir, I am the manager of P.S Data Entry Services,which has 78 working staffs ,who are master in there own fields such as data entry,management ,form filling etc. We are able to complete the project as soon as possibl Daha Fazla
Dear Sir, I Hope I will work with you. I have a big active team for your work. And I Promise that I can give our requirement s. Please give your project details with rate for our deal. Wish that are arrange better qua Daha Fazla
Hello, After over 15 years in the IT and Consulting world, I decided to work on my own. I am focused and result oriented. Analytics is my primary focus area therefore I believe that I could meet or exceed expectati Daha Fazla