
Closed
Posted
Paid on delivery
I’m sitting on several city-based Excel files and need them merged into one clean .xlsx workbook. Once everything is in the same place, I want the data reorganised so that every employee is grouped by tenure, not by city or department. From there, the only performance metric I need reported is Project Completion Rates. Here’s how I picture the finished file: • One master sheet holding all raw records, clearly tagged with the original city information. • A structured table or pivot that buckets employees by tenure bands (you can suggest logical ranges if none are listed). • A calculated field that shows each person’s project completion rate, plus an overall summary for quick comparison. Keep formulas transparent and avoid hard-coding any numbers so the report stays future-proof. If you like working with Power Query or similar tools, feel free—just make sure the workbook remains a standard .xlsx that opens without add-ins. Share back the consolidated file and a brief note outlining any assumptions you made. That’s it.
Project ID: 40193657
44 proposals
Remote project
Active 2 mos ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
44 freelancers are bidding on average ₹1,093 INR for this job

Hi, I will combine all city-based Excel files into one master .xlsx, clearly tagging each record by city. Employees will be grouped by tenure (using logical ranges), and Project Completion Rates will be calculated with transparent formulas. A simple summary will be included for quick comparison. The final file will open without add-ins and include a brief note on assumptions. Best Regards, Virendra
₹1,500 INR in 3 days
6.2
6.2

Ready to do the required.
₹2,500 INR in 1 day
5.2
5.2

AM READY TO START: EXCEL DATA MERGE & TENURE-BASED PERFORMANCE DASHBOARD Hello, I am John K., a full-time Excel data architect with over 15 years of experience. I specialize in consolidating multiple datasets and building dynamic, formula-driven reports that organize information for clear, actionable insights. My understanding is: You need multiple city-based Excel files merged, reorganized to group employees by tenure bands, and analyzed to show individual and overall Project Completion Rates in a future-proof, add-in-free workbook. I will deliver: ✅ A single .xlsx workbook with a raw master sheet and a dynamic tenure-band analysis ✅ Calculated Project Completion Rate metrics with transparent formulas ✅ A brief assumptions note for clarity Let's connect via chat to discuss logical tenure bands and transfer your files! I'm ready to build your streamlined report. Respectfully, John K.
₹600 INR in 1 day
4.4
4.4

Hi I have 15+ years of experience in Excel, VBA automation and business intelligence including ETL and data pocessing, data visualization using advance Excel . I have gone through the requirements and can complete the work most efficiently. If interested we can connect now and get started.
₹2,500 INR in 7 days
4.6
4.6

As an experienced and results-driven Data Scientist, I am confident in my ability to meet and exceed your expectations for this project. Over the years, I have demonstrated strong proficiency in data analysis, processing, visualization, and entry – skills that are central to the success of your undertaking. My goal is to consolidate all your Excel data into one highly-organized and easily interpretable workbook that aligns with your desired structure. I understand the importance of future-proofing workbooks to maintain compatibility and ensure seamless analysis. My use of transparent formulas and avoidance of hard-coding numbers supports this need. Additionally, if working with Power Query or other similar tools can better serve the project, trust that I'll implement them without compromising the accessibility of the final report. Leveraging my mastery of working with complex data sets and creating insightful visualizations, I assure you a comprehensive presentation of each employee's tenure-based performance metric in terms of project completion rates. With every milestone I help businesses achieve, my commitment to delivering impactful and measurable results only deepens. Therefore, by choosing me you would be gaining not only a proficient freelancer but a true partner for your ongoing data needs.
₹1,500 INR in 1 day
3.5
3.5

Hello Sir/Madam, I am a beginner freelancer but very sincere and detail-oriented. I can carefully complete your Tamil Text Proofreading & Excel Entry task using my mobile or computer. I will follow all instructions properly and deliver on time. I am offering a reasonable price to build my first review. Thank you for considering my proposal.
₹1,050 INR in 7 days
0.0
0.0

Hi, I can help consolidate your city-based Excel files into one clean, well-structured .xlsx workbook. I’m highly proficient in Excel and experienced in merging data, restructuring tables, and creating clear formulas and pivots without hard-coding values. I’ll group employees by tenure, calculate individual project completion rates, and provide a simple summary for quick comparison. The file will remain future-proof and easy to update. I can start immediately and deliver within the proposed timeline. Thanks.
₹600 INR in 1 day
0.0
0.0

With a broad set of skills in data management and proficiency in MS Excel, I am well-suited to take on your project of consolidating your employee performance data. Apart from merging the files into one master sheet, I will creatively organize the data by tenure bands and calculate everyone's project completion rates accurately for easy comparison. Throughout the process, I'll employ my strong attention to detail to keep formulas transparent, avoiding hard-coded numbers so that your report stays future-proof. Beyond my technical skills, dependability is at the core of my work. I understand the importance of confidentiality with such sensitive data, and you can trust me to handle it professionally. Additionally, I pride myself on delivering top-quality work promptly, without compromising accuracy. My goal is always complete client satisfaction, making sure that your needs and specifications are met in every way possible. Finally, project turnovers have always been a seamless process for me as I also believe in sharing crucial assumptions made during my task execution. My aim is to not only provide a consolidated file but also enable you to easily understand the restructured data. With these unique strengths and commitment to providing high-quality service that aligns with your needs and expectations, I believe I'm the perfect fit for this job.
₹1,050 INR in 7 days
0.0
0.0

My work has included merging multiple Excel files into unified, error‑free workbooks, creating structured tables and pivot reports, and ensuring accuracy through careful validation. I specialize in preparing product catalogues, employee records, and performance dashboards with transparent formulas that remain adaptable for future updates. Clients value my attention to detail, consistency in tone, and ability to deliver clear, well‑organized outputs on time. I bring reliability, technical proficiency, and a commitment to quality
₹1,050 INR in 7 days
0.0
0.0

Hello! I am Khalid, an expert in Microsoft Excel and accurate data entry. I have reviewed your project requirements and I am confident that I can deliver high-quality, error-free work within the 5-day timeframe. I pride myself on my attention to detail and my ability to organize data efficiently. I am ready to start immediately and ensure your project is completed to your satisfaction. Let's discuss how I can help you.
₹1,050 INR in 5 days
0.0
0.0

Hello, I can consolidate and organise your Excel employee performance data into a clean, structured, and easy-to-review file. My approach is not just copying data. I first review the existing sheets, define a clear structure, and then consolidate the information so totals, comparisons, and performance indicators are consistent and traceable. What I will deliver: One consolidated Excel file with clear structure Clean and standardised data Logical formulas (no hard-coded totals) Clear layout ready for review or reporting Notes for any ambiguities or inconsistencies found in the source files Delivery time: 2 days Price: 1200 INR Milestone: 100% — Excel Consolidation & Validation I’m available to start immediately and keep all communication inside Freelancer. Best regards, Jaime
₹1,200 INR in 2 days
0.0
0.0

I am a dedicated and detail-oriented freelancer with experience in data entry, virtual assistance, documentation, and administrative support. I focus on delivering accurate, timely, and high-quality work that meets client expectations. I am skilled in handling data management, MS Excel, MS Word, Google Docs, email handling, online research, and basic record keeping. I understand the importance of confidentiality, accuracy, and deadlines, and I always ensure error-free work.
₹999 INR in 7 days
0.0
0.0

I am Anand, a reliable and detail-oriented freelancer with strong expertise in Microsoft Office, including MS Word, Excel, and PowerPoint. I specialize in Data Entry, Data Cleaning, Data Analysis, and Data Analytics, ensuring high accuracy and efficiency in every project.
₹2,050 INR in 3 days
0.0
0.0

Hello, I can consolidate all your city-based Excel files into one clean, future-proof .xlsx workbook. I’ll create a master raw data sheet with city tags, reorganize employees into logical tenure bands, and calculate Project Completion Rates per employee using transparent formulas (no hard-coding). A pivot/summary view will be included for quick comparison. Power Query will be used only within Excel, and the final file will open as a standard .xlsx with no add-ins required. I’ll also provide a brief note explaining assumptions and refresh steps. Ready to start immediately once files are shared.
₹900 INR in 7 days
0.0
0.0

Hello, I can merge all your city-based Excel files into one clean master workbook, clearly tagging each record by city. I will organize employees by tenure using logical ranges, create a structured table or pivot view, and calculate Project Completion Rates with transparent formulas (no hard coding). I’m comfortable with Excel tools including Power Query, pivots, and formulas, and will deliver a standard .xlsx file with a brief note on assumptions. Ready to start immediately. Best regards,
₹600 INR in 7 days
0.0
0.0

Subject/Title: Freelance Procurement / Purchase Support (SAP + Advanced Excel) Hello Sir/Madam, I’m Sagar Kale, currently working as a Purchase Executive at Manipal Hospital, Kharadi (Pune) with 2.5+ years experience in Hospital/Pharma procurement. I can support you with: PO tracking & vendor follow-up Quotation comparison (QCS) & negotiation support SAP PO/GRN tracking Inventory support + month-end closing Advanced Excel reports & dashboards ✅ I can start immediately and provide after-office remote support (Mon–Fri) and weekend support if required.
₹1,050 INR in 2 days
0.0
0.0

I am ready to doing your project. I have seven years plus experience in Excel with advance formulas.
₹850 INR in 7 days
0.0
0.0

I specialize in data consolidation and can transform your city-based files into a dynamic, tenure-focused master report. I will use Power Query to merge your datasets, ensuring the process is repeatable and the final .xlsx remains a standard, "plug-and-play" file with no external dependencies.
₹1,050 INR in 5 days
0.0
0.0

Hello, I have carefully read your project details. I can complete this data entry work accurately and on time. ✔ Experience with Excel & Google Sheets ✔ 100% accuracy ✔ Quick turnaround I am ready to start immediately. Looking forward to working with you. Thank you!
₹650 INR in 2 days
0.0
0.0

I will merge all Excel files into one clean workbook, group employees by tenure, and add completion summary with clear formulas. Ready to start now and deliver in 2 days.
₹1,200 INR in 2 days
0.0
0.0

Ludhiana, India
Member since Oct 25, 2022
$250-750 CAD
$250-750 USD
₹750-1250 INR / hour
₹12500-37500 INR
$30-250 USD
₹600-1500 INR
$30-250 USD
₹12500-37500 INR
₹1500-12500 INR
$250-750 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
₹600-1500 INR
₹750-1250 INR / hour
$10-30 USD
₹1500-12500 INR
$30-250 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
₹400-750 INR / hour