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!
11 freelancer bu iş için ortalamada 206$ teklif veriyor
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.
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.