I'm looking for an Excel expert to do a few things to my spreadsheet, and to explain to me how you did it (so I can learn).
Note: I use Excel for Mac (version 16.6.7)
I have a large Excel file (~7 mbs, ~74,000 rows). The file contains many different web page URLs, along with SEO metrics (e.g. domain rating, organic traffic, etc) for each URL.
I need help doing these three things with the file:
1) Filtering the master sheet by criteria for two columns, then automatically transferring the filtered data into a second (new) sheet
2) From the second sheet, automatically copying and pasting rows that contain specific data (unique instances of URLs) into another (third) sheet
3) In the third sheet, automatically removing characters from cells (specifically, removing the web page extension from each URL, so only the root domain URL is left).
I would like the freelancer I hire to do two things: (1) do the work in my Excel file (if that would include writing macros to do the work, that would be fine); and (2) tell me (or show me by recording a screencast) how you did the work, so I can do it myself on other sheets.
I can share the spreadsheet and a quick video showing exactly what I want done. PM me if you're interested.
I'm willing to pay a good fee to an Excel expert who can get this done AND explain to me how they did it.
Interested bidders MUST briefly explain what makes them an Excel expert.
Hello sir. I can help you with your projects and prepare screen recording videos for you (narrated by me) to help you with your excel work. I have a long history with Excel VBA and i think that is what makes me an expe Plus
33 freelance font une offre moyenne de $131 pour ce travail
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 freelancer.com and have been featured by the freelancer community ( Plus
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. Plus
Hi, I am good at Excel and VBA. I would like to review the existing code and update the necessary points as mentioned. I will work on your mac via screen share. And i will explain the process. Looking forward Plus
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, I can do this virtually directly on your PC view team viewer I have good Microsoft Excel skills with years of experience as well as I have complete number of projects for Excel to manage data and sorting. You ca Plus
Hi Here is excel expert. I have read the project description and I ensure to filter 74 k data file accurate filtering. Before start the work, I will show you sample first. Please contact with me for discussion. Tha Plus
Hi, Nice to know your requirement. I am an excel vba, vb6 professional and have delivered seventy five excel vba projects in the last one year. Sure. Willing to take up your project. Thank you, Regards.
Hi, I'm an expert in Data Entry and excel. I understood your all requirements. I have done many projects like this. I'm ready to start now. Regards, Noor
Hello. How are you? I am highly interested to work on the "Need Excel help (filtering large data file)". I am a full stack website developer. I have more than 7 years experience in "Data Entry, Data Processing, Exc Plus
Greetings, We have read the project description an understand the nature of work. Allow us to complete this project within deadline with 100% accuracy and perfection. Warmest Regards Sample Work [login to view URL] Plus
Hello Sir I have a team. My team is always active for work. If you give me a chance and give direction for the job, I will do this. Regard's Blood Freelancer Team
I can help you, I would refer you to my reviews. I have rich experience in excel and VB, and I do my best to save your time and pocket. I can assure you the results and help you done this on your own. plz feel free to Plus
Available Immediately | MS Excel and VBA Expert | Assured quality of the work and timed delivery | You can check my jobs history for the same. Looking forward for your message.
Hi, I read with interest your posting. I got your job requirements and can start immediately. I believe I possess the necessary skills and experience you are seeking and would make a valuable addition to your compan Plus
Hi, I would love to work on your project. I have a Masters of Computers (MCA). I am Excel Expert by profession. I have 13+ years of exp. working on large excel sheets database with companies like Vodafone, India Bulls Plus
I am quite familiar with Excel. Your project can be done both using VBA and also Excel formulas such as VLOOKUP, FIND, LEFT and RIGHT. I suggest you use the formulas because updating it is easier. Your project will be Plus
Hello dear I'm interested in this project. I'm a professional Data Entry specialist. I already completed the 200+ project in this work. I'll provide Pro Work. If you do not like my work, then 100% money back. Wish you Plus
I am sure I will make your project perfectly, I can make an example for free; If you like it I will make the remaining part of your project.