4-hour project : Organise data in MS-Excel

$10-30 AUD

Færdiggjort

Slået op

cirka 1 måned siden

$10-30 AUD

Betales ved levering

Before you bid, please check our "Client profile" on Freelancer.com, and the testimonials from previous freelancers whom we have hired. We are an established employer. Quick and correct work will earn you positive feedback and timely payment. ************************************************************************************************** Project description : This is an intensive, manual work project that will take at least 4 hours of dedicated Excel skills Please proceed with reading further, only if you are willing to work hard and devote time to complete the task correctly. It CANNOT be automated or run via a script. It CANNOT be outsourced via code. Please do not waste your valuable time trying to do either. The task: There are 10 Excel workbooks, with approximately 1 million rows each. These contain the data for text messages sent via SMS to customers in the last 1 year. Your task is to sort and separate the messages into different sheets in each workbook. You will create 1 workbook for each month, e.g., messages sent between the first and last day of: 1. April 2023 2. May 2023 3. June 2023 .....and so on The sample workbook is here ([login to view URL]). The main data files are here ([login to view URL]) You will sort the data for each month into the following 11 sheets: 1. OTP messages (Messages related to sending OTP - One Time Password) 2. AWB tracking messages (Messages related to AWB - AirWayBill tracking) 3. AWB Booking messages (Messages related to AWB - AirWayBill booking) 4. AWB Mismatch messages (Messages related to AWB - AirWayBill documents being incomplete, or there being a mismatch) 5. Thank you messages (Messages thanking customers to using our services) 6. KYC messages (Messages related to KYC - Know Your Customer services) 7. SME messages (Messages related to SME - Small and Medium Enterprises services) 8. Airway Bill messages (Messages related to Airway bills which don't fit #2, #3 or #4 above) 9. DHLLKS messages (Messages where the sender ID in Column E says "DHLLKS") 10. DHLAAA messages (Messages where the sender ID in Column E says "DHLAAA") 11. All other messages (All other messages which do not fit into the category above but have the sender ID in Column E marked as either "DHLEXP" or "DHLLKS" or "DHLAAA") 12. Discard all other messages - You can delete any messages which have any other sender ID in Column E other than those mentioned in Point #11. What we are looking for - Your ideal skills and experience: - Excellent attention to detail - Ability to work efficiently and meet strict deadlines - Thorough and complete effort - Sound knowledge of Excel and data sorting Project Scope: - The contact details should be accurate and up-to-date. - The project needs to be completed within the timeline. Deliverables: - Month-wise MS-Excel output sheets, to be uploaded here on Freelancer.com Note: Only freelancers with proven experience in MS-Excel should apply. Accuracy and efficiency are crucial for this project. We will randomly check your uploaded testing report for accuracy before releasing the payment milestone, so please work carefully and try to finish as quickly as possible. FINAL CHECK BEFORE YOU UPLOAD YOUR OUTPUT: Check that the count of data (rows in Excel) which you started with is the same as what you have finished with. This should ensure that you have not accidentally deleted or double-counted any rows. ************************************************************************************************************* Please bid only if you have previous experience and can deliver within the time specified, otherwise do not waste your valuable bid. Work must be 100% clean and professional Timely, sincere work will earn positive feedback and prompt payment. So take the task seriously, and show us your best work. Best of luck in your bid!

Projekt-ID: 37969411

Om projektet

30 forslag

Projekt på afstand

Aktiv 1 måned siden

Leder du efter muligheder for at tjene penge?

Emailadresse

Fordele ved budafgivning på Freelancer

Fastsæt dit budget og din tidsramme

Bliv betalt for dit arbejde

Oprids dit forslag

Det er gratis at skrive sig op og byde på jobs

Tildel til:

@nicolettelange88

As an experienced administrator and data specialist, I've had many opportunities to work under strict deadlines while maintaining accuracy and attention to detail. Sorting through massive amounts of data and organizing them in meaningful ways is a skillset I've honed over the years.

$20 AUD på 1 dag

0,0

(0 anmeldelser)

0,0

@claudia520

A tu servicio. Soy ágil , muy detallista y minuciosa para realizar este tipo de trabajo. Tengo 10 años de experiencia

$20 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@smzaman01

Hi I am a professional engineer having more than 15 years working experience. I can assist you properly as i have all relevant knowledge you are looking for. So, would be good to start a chat regarding this. I am sure you would be happy to get my service. Regards, SM Moniruzzaman

$17 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@gargarpit3110

As a seasoned freelancer, I understand the meticulousness this project demands and have had the opportunity to display my Excel expertise on countless occasions. My past experiences with data processing projects involve analysis, reformatting and manipulation of massive data sets that are similar in complexity and size to what you've shared. Handling accounting tasks that comprised sufficiently large databases calls for attention to detail, time management skills, and unfailing dedication - attributes that align well with the scope of your demanding data organization duties. Additionally, my team, comprising accountants, Excel experts and data analysts, ensures that every project from us is 100% clean and professional while meeting stringent deadlines. Thanks, Arpit Garg

$20 AUD på 1 dag

4,6

(11 anmeldelser)

2,7

30 freelancere byder i gennemsnit $23 AUD på dette job

@daniyal3214

Hello, I am an experienced Excel expert with years of experience. I understand that this is a manual work it will take at least 3 to 5 working hours. I completely understand on what basis you want me to build separate workbooks. I will be happy to discuss in details. Available to start immediately.

$45 AUD på 1 dag

4,8

(246 anmeldelser)

7,3

@nabila66

Hello I will organize your data in Excel format as you mentioned here. I will complete the project within next 4 hours. Regards, Nabila

$30 AUD på 1 dag

5,0

(220 anmeldelser)

7,0

@snehamehta525

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh

$30 AUD på 1 dag

4,7

(64 anmeldelser)

5,9

@mobimubasir

Hello. I read your requirement i will do that in 4 hours. Please come on chat we will discuss more about this. I will waiting your reply.

$30 AUD på 1 dag

5,0

(26 anmeldelser)

4,7

@FardinkhanBoss

Greetings, I’m willing to provide you with a FREE SAMPLE in this way you will be able to trust my quality work. My bid amount is negotiable and we can discuss it over chat. There I am ready to start now. I will make a sample first if you like sample work then you can hire. I am ready to make a free sample now. I have done many jobs like this. Please message me for detail. Regards Fardin

$20 AUD på 7 dage

4,9

(17 anmeldelser)

4,7

@umairnoor32

UMAIR HERE I HAVE READ YOUR INSTRUCTIONS AND I CAN DO IT EFFICIENTLY. PLEASE GIVE ME THIS PROJECT I WILL GIVE YOU UNLIMITED REVISIONS EVEN AFTER COMPLETION OF THE WORK. THANK YOU

$30 AUD på 1 dag

5,0

(56 anmeldelser)

4,4

@TayyabDastgir

Hello, Kindly consider initiating a CHAT to transform your aspirations into tangible reality, as I am eager to delve into the intricacies of your project and collaborate effectively to achieve your desired outcome. Here's what I offer:  Automation (Macro/VBA)  Financial Analysis  Formulas and Functions  Data Analysis (PivotTables, Charts)  Charts and Graphs  Reports and Dashboards  Data Entry and Management  Conditional Formatting  Tables Creation  Data Validation  Collaborative Work  Data Import/Export  Filtering and Sorting  Scenario Analysis  Solver Optimization The initial bid is flexible as we aim to understand your project fully. Let's work closely for exceptional results. Best regards, Tayyab Dastgir

$30 AUD på 1 dag

5,0

(4 anmeldelser)

2,8

@syedalihassansh4

Dear Sir, I have carefully reviewed your instructions and I am confident that I can complete this project efficiently. I would appreciate the opportunity to work on this project, and I assure you that I will deliver high-quality work with unlimited revisions. Moreover, I am committed to working on your project even after the work is completed. Please let me know if you have any questions or concerns. I look forward to your response. Thank you for your time. Best regards, SYEDA NIMRA

$30 AUD på 1 dag

5,0

(9 anmeldelser)

2,2

@chintanshah97

Dear Client, Greetings of the day! I'm available to work on it right now. Sir, am an EXCEL Formula, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD and DATA ANALYSIS expert with advanced skills. Also, if possible can you share the questionnaire as well. I checked sample work and sheets to be worked upon. Out of four projects, three projects are related to excel data entry plus data analysis. I will share the demo before awarding the project. https://www.freelancer.com/u/chintanshah97 Regards, Chintan Shah

$30 AUD på 1 dag

5,0

(3 anmeldelser)

2,1

@ElizaSapkota7

Dear Client, I have recently done a similar job and delivered by 4hours of allocated time. I am detail orientated an expert excel user in data management and sorting. I can start immediately and deliver with accuracy in timely manner. Hope I could work for you. Regards, Eliza

$30 AUD på 7 dage

5,0

(1 bedømmelse)

0,6

@zeeshanhussain01

As a highly skilled Excel expert with an appreciation for accuracy, I believe I'd be the perfect fit for your intensive data organization project. My track record of creating analytical reports and organizing large datasets will definitely come in handy as we tackle your ten workbooks containing approximately one million rows each! Whether it's breaking down the messages into separate sheets based on their unique categories or ensuring all pertinent contact details are correctly stored, I'll meticulously adhere to your guidelines while employing my research skills to guarantee high-quality results. In conclusion, I understand the meticulousness required by this project; and have the proficiency to execute cut e successful ly within your specified timeframe. Don't just take my word for it: let my previous clients’ reviews and testimonials speak for my excellence. I am poised to help you implement this demanding task with utmost diligence. Choose me today and rest assured of deliverables that will surpass your expectations! Let's get started on turning those 4 hours into a successful step forward for you!

$20 AUD på 1 dag

0,0

(0 anmeldelser)

0,0

@vaishnavi722

With over 4.5 years of experience in sales and business development, I had the opportunity to work with large pools of data just like this project demands. My attention to detail is impeccable, which ensures that each entry is sorted accurately and error-free. In addition to that, I have pursued a bachelor's degree in electrical engineering; improving my analytical skills and logical reasoning which further aids me in approaching intricate tasks such as yours. I understand the essentiality of completing the project within the stipulated timeframe while maintaining its quality and can assure you of a timely submission with outstanding precision. Working efficiently and meeting strict deadlines have been an integral part of my professional journey which will provide added assurance of my deliberate effort to complete this task most efficiently. In closing, I'd like to emphasize that not only do I have a sound knowledge of Excel, but my approach to work resonates with thoroughness, detail orientation and timeliness - all key components for successful completion of your project. My commitment is to deliver month-wise MS-Excel output sheets that are accurate and up-to-date, just like your specifications demand. Allow me the opportunity to showcase my value by entrusting this important task to me. I'm eager to ensure your expectations are not just met, but exceeded!

$20 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@Irene994

My ability to type 70 words per minute with a low error rate makes me qualify for this job. I am also attentive to details and organize my work in an orderly manner. Being a good time keeper, I will deliver my work On time.

$20 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@Vsranawat9696

hey dear client I See Your Requirements and I understood what will you need ? on the Basis of Skills i 100% sure i Can complete you project in 2 Days. thanks

$15 AUD på 2 dage

0,0

(0 anmeldelser)

0,0

@rp042310

Hello, I am Rahul Patel. I have 6+ years experienced in data scraping, data mappings, SEO, data entry and excel work. I have completed so many major project in my job time. Now I am starting freelancer. In starting periods I will work in lower budget for gain my experience. I am mention my work in my portfolio as well as in my resume. Thank you. Regards, Rahul Patel

$20 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@mijanur5276

Hello, With extensive experience as a Data Entry Operator, I'm confident in my ability to handle your project proficiently and promptly. My strong command of all Microsoft Office software, including Excel, lends itself perfectly to the task at hand. Typically typing at speeds exceeding 40 words per minute with 100% accuracy, your project will be in highly capable hands. In addition to being technically skilled, I bring an organized and detail-oriented approach to my work that is well-suited to this demanding sorting task. My ability to meet strict deadlines without sacrificing the quality or accuracy of my work has been tested and proven in previous projects. I understand the importance of thorough and complete effort and will ensure the final deliverables are accurate, professional and on time. Above all else, I believe my commitment to excellence aligns perfectly with your requirements. The quality and accuracy of my work are top priorities always. As a reliable, diligent freelancer who values timeliness and precision on every job given- I am exactly who you need for this project. Choose me today for an efficient completion that exceeds your expectations. Thanks

$10 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@abhijitsk1990

I have 3 years experience in data entry at freelancer company. I will submit you the project at stipulated time period with high accuracy.

$20 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@basantsoni1

I have read the requirements for your projects, sir, and I believe I can complete this work for you quite effectively given my one year of experience. Since I work on other websites, I can also provide you with samples of my prior work. I can deliver your order in less than a day.

$10 AUD på 1 dag

0,0

(0 anmeldelser)

0,0

@ramgrav0583

Hi! I’m Ramon your data entry clerk. I can do the data entry work provided by you on priority basis I work fast with accurate working ability. I am highly motivated and organized. I can stay on the task and complete the project in a timely manner. I would like to take the opportunity to show my interest in working your project.

$15 AUD på 7 dage

0,0

(0 anmeldelser)

0,0

@telpact

As a team leader of Telpact Limited, we have a collective experience of over 10 years in data processing and data entry tasks. Our expertise is rooted in meticulous attention to detail and an unparalleled ability to meet strict deadlines without compromising on quality. We understand the magnitude of your project and the need for professional precision, and we guarantee an accurate and timely completion within budget. Our proficiency with Excel is a distinguishing advantage for this project, as we've retrieved, sorted and organized datasets of similar sizes in complex formats. Our robust quality control measures ensure that no row is mistakenly deleted or double-counted, providing you clean and error-free output. Choosing us not only guarantees excellent output but also peace of mind. We are well-equipped to handle your demanding task, giving you room to focus on your core business needs while we deliver professionally and promptly. Let's discuss your specific requirements further, in order to serve you better. Together, let's make this project a resounding success! Best Regards Vinamra Sonkhiya

$20 AUD på 7 dage