Find Jobs
Hire Freelancers

Automate a task - create an Excel pivot table based on data using Python

€8-30 EUR

Completed
Posted 6 months ago

€8-30 EUR

Paid on delivery
I am looking for a freelancer who can automate a task for me. The task involves creating an Excel pivot table based on data from an Excel file. Specific requirements: - The source of the data for the pivot table is an Excel file. - Although I don't have a specific layout or format in mind for the pivot table, I do have some preferences that I would like the freelancer to consider. Its a data set that needs to be created: Previously was a google sheet that used a formula: =RANGETOTABLE(FILTER('Sheet1'!D:J,'Sheet1'!E:E=A2 ),'All Employees'!$D$1:$J$1) A folder needs to be created called Payroll Adjustments Each Excel file needs a name Convention (Country) Payroll (Month you run the file) (year) Skills and experience: - Proficiency in Excel and pivot table creation. - Strong analytical and data interpretation skills. - Attention to detail to ensure accurate analysis and trend identification. If you have experience in Excel Dataset creation and data analysis, and can automate this task for me, please submit your proposal.
Project ID: 37462230

About the project

45 proposals
Remote project
Active 6 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I can help you complete this project within 5 hours. I understand you're in a hurry... So let me get straight to the point. You don't have to pay me hourly. Just give me details about this project. I will do the work myself and make sure I can finish this project for you. After I send you my project... based on your feedback I will fix it within 2 hours. Then, based on the end result, you can decide if you want to pay me or not. Regards HungHello there! My name is Giáp, and I am an experienced WordPress developer and website designer with over 10 years of experience. I specialize in building custom WordPress websites that are both beautiful and functional. I have a deep understanding of the WordPress platform and am skilled in all aspects of WordPress development, including Excel Dataset creation and data analysis. I am well-versed in the concepts of Excel Pivot tables and can use this knowledge to create an Excel pivot table based on data from an Excel file. Additionally, I have the necessary skills and experience to ensure accurate analysis and trend identification when creating the Payroll Adjustments dataset. I would be delighted to discuss your project further if you are looking for an expert who can automate a task for you. Please feel free to contact me if you have any questions or would like more information about my services.
€25 EUR in 7 days
4.9 (3 reviews)
2.1
2.1
45 freelancers are bidding on average €24 EUR for this job
User Avatar
Excel expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from this platform give me a chance to show you the best i can do at your service.
€29 EUR in 1 day
4.6 (184 reviews)
6.2
6.2
User Avatar
Dear client, I am an experienced freelancer with a strong background in Excel dataset creation and data analysis. I have successfully automated similar tasks for clients in the past. I will create a script to generate the desired pivot table based on your specifications from the source Excel file. Additionally, I will organize the output files into a "Payroll Adjustments" folder with the specified naming convention. My attention to detail ensures accurate analysis and trend identification. I am confident in delivering a reliable and efficient solution for your project. Let's discuss further details to get started promptly. Thank you.
€30 EUR in 1 day
5.0 (18 reviews)
5.0
5.0
User Avatar
Hi there. In excel the pivot can be created using a macro which can make the pivot on a button click Ive done such task earlier lets connect and discuss on this Thanks Vishal
€45 EUR in 1 day
5.0 (87 reviews)
5.2
5.2
User Avatar
Hi there, I am a professional business analyst with experience of automation of excel sheet. Please hit the message button to start working together
€19 EUR in 7 days
4.9 (48 reviews)
5.0
5.0
User Avatar
I understand you are looking for a freelancer who can automate a task for you and I believe I am the perfect fit for this project. With my extensive knowledge in Excel and Python I am confident that I can provide the necessary solution to create an Excel pivot table based on data from an Excel file. My expertise includes proficiency in Excel and pivot table creation as well as strong analytical and data interpretation skills that would be invaluable for ensuring accurate analysis and trend identification. Additionally, my attention to detail ensures that any errors or omissions are immediately noticed and corrected so that you receive high quality results every time. If you would like me to discuss further please don't hesitate to reach out with any further questions or requirements. Thank you for considering me for this task and I look forward to hearing from you soon!
€19 EUR in 2 days
5.0 (20 reviews)
5.1
5.1
User Avatar
Hello, Hope you are doing well. I have gone through your requirements generating pivot table from the excel data file. With my strong background in excel, macro/VBA programming I am confident in my ability to deliver high-quality results. I would appreciate the opportunity to discuss your project further and provide any additional information you may require. Thank you for considering my proposal, and I look forward to the possibility of working with you. Regards, Naveen Upadhyay
€20 EUR in 1 day
5.0 (11 reviews)
3.9
3.9
User Avatar
Hello mate Excel Expert Here, I have developed many customised solutions to many businesses via Freelancer and directly. My expertise is in spreadsheet automation using complex formulas and/or VBA/google appscript. Happy to you with calculation sheet designed and formulated. Let's discuss further and get this done. Thank you!
€85 EUR in 1 day
5.0 (4 reviews)
3.1
3.1
User Avatar
Hello! Greetings from Wilfred! After thoroughly reading the job description of your Automate a task - create an Excel pivot table based on data project, I am thrilled to express my strong interest in being a part of it. With my years of experience working as a freelancer, I have honed my skills in Visual Basic, Data Processing, Visual Basic for Apps, Data Entry and Excel which you indicated are essential for this project. My goal is not just to complete the project, but to truly make a positive impact and exceed expectations. I am excited about the potential of this project and welcome the opportunity to contribute my expertise to its success. I am eager to learn more and discuss how I can contribute to its success. Thanks Faiza E. for your time. Let's work together to bring your vision to life.
€25 EUR in 1 day
5.0 (1 review)
2.9
2.9
User Avatar
Hello Client ! I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Eclipse , Sql , Mysql ,Oracle , Object Oriented Programming , Data Structure , Algorithms . I have a perfect grip on “Automation” , and work in “Machine Learning” Deep Learning ”. I want to assure you that these are my areas of expertise and I can do any work related. Here I am also assuring you that the quality of work will not be compromised . I am able for work full time on your time zone and start work right now . Please send me a message for further Details .
€19 EUR in 2 days
5.0 (2 reviews)
3.1
3.1
User Avatar
Hello, my name is Neha and I am a freelancer specializing in graphic design, animation and illustration. I have worked on projects related to these fields for over 8 years and have gained a wealth of knowledge and experience. I understand from your description that you are looking for someone who can automate a task for you involving creating an Excel pivot table based on data from an Excel file. Specifically, you are looking for someone with proficiency in Excel and pivot table creation who can take care of this task quickly and accurately. I believe I am the perfect person for this project. My skills include proficiency in Excel and pivot table creation as well as strong analytical and data interpretation skills that would be useful when analyzing the data source for the pivot table layout preferences you have requested. Additionally, I am careful about detail so that accurate analysis can be done without any mistakes.
€19 EUR in 1 day
5.0 (1 review)
2.8
2.8
User Avatar
Hi Faiza E., Good afternoon! I am skilled data analyst with skills including Data Entry, Excel, Data Processing, Visual Basic and Visual Basic for Apps. I hold an masters degree in data analysis which provides me with the necessary background to handle your project. Having done similar projects, I can deliver quality and superior work at a price we are both comfortable with and within the agreed timeline. Meanwhile, I am currently reviewing your attachment. I will update you shortly in the inbox once you respond to my proposal. Please send a message to discuss more about this project. I await your immediate response, Lincoln
€25 EUR in 2 days
5.0 (2 reviews)
2.5
2.5
User Avatar
Hey Faiza E., I just finished reading the job description and I see you are looking for someone experienced in Visual Basic, Excel, Data Entry, Data Processing and Visual Basic for Apps. This is something I can do, Please review my profile to confirm that I have great experience working with these tech stacks. While I have few questions: 1. These are all the requirements? If not, Please share more detailed requirements. 2. Do you currently have anything done for the job or it has to be done from scratch? 3. What is the timeline to get this done? Why Choose Me? 1. I have done more than 250 major projects only on freelancer.com. 2. I have not received a single bad feedback since last 5-6 years. 3. You will find 5 star feedback on last 100+ major projects which shows my clients are happy with my work. Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) I will share you the my recent work in the private chat due to privacy concerns! Please start the chat to discuss it further. Regards, Ahmed
€8 EUR in 2 days
5.0 (3 reviews)
2.1
2.1
User Avatar
Greetings, I have more than 10 years of experience in professional consultancy regarding Microsoft Excel and Power Bi. I am an expert in formulating scenarios, logic, and criteria outputs based on user requirements. I am also proficient in enabling automation through Macros and user forms to speed up the notch. I can cater to all your Ms Excel needs in a jiffy. My motto is “Whatever you think to do, I can formulate it.” I can better able to manage your task and assure you to deliver quality work. Please inbox me for more details and discussions. Looking forward to working with you. Regards,
€30 EUR in 2 days
5.0 (4 reviews)
2.3
2.3
User Avatar
Greetings! I am a Professional in Microsoft office, Data Entry, PDF, and excel with over more than 1 years of experience, therefore, I can easily do this job. You can message me to discuss the detail. Why me? My goal is to offer services to you that are profitable. I don’t want you to place an order once and that’s it. For me to be successful, I need you to come back and order again. Give me the opportunity to work on your project. I wish to build a long-term relationship with you. We can have further discussion in chat. Thanks! Warm Regards, Here’s I am mentioning some of my technical skills: ✅ Ms. Excel ✅ PDF ✅ MS Word ✅ MS Office ✅Photo Editing etc. Click on the Hire Me button to start chatting with Me. I understand that you are looking for a freelancer to assist a client with adding products to a partially completed WooCommerce website and I believe I am the best fit for this project. With over 1 years of data entry experience and background in Microsoft office, I am confident that I can provide accurate and timely service for this project. I would be more than happy to discuss further details regarding the project or any other related matters should you wish to discuss further. Thank you for considering me for this job and I look forward to hearing from you soon!
€8 EUR in 1 day
4.4 (5 reviews)
1.8
1.8
User Avatar
Hi, I am an experienced excel expert and data analyst. I have read your project details carefully and I am confident that I can handle this project perfectly. Furthermore, I have recently completed similar project for my client and he gave me 5-star rating. I am sure that you will also be satisfied with my service like my previous clients. Please, come in chat for further discussion, Best regards, Noor Nawaz
€19 EUR in 1 day
4.9 (3 reviews)
1.8
1.8
User Avatar
Hi there! I understand from your description that you are looking for a freelancer who can automate a task for you. Specifically, you need someone who can create an Excel pivot table based on data from an Excel file. With my experience in Excel and pivot table creation, I am confident that I can provide the necessary skills to complete this project. My profile shows that I have extensive expertise in making websites, data entry, mathematics and physics. Additionally, my attention to detail ensures accurate analysis and trend identification during projects. This combination of skills makes me the perfect fit for this project. I would be delighted to help you create an Excel pivot table based on data from an Excel file. Please feel free to contact me if you have any questions or would like more information about my services. Best Regards, Iqra Ahmad.
€19 EUR in 7 days
4.2 (5 reviews)
2.0
2.0
User Avatar
Dear Client, I am excited to hear about your project! With my skills in data entry, processing and Excel, I believe that I can help you reach your goals for this project. I have experience in creating Excel datasets and data analysis which will be crucial for the automation of the task. I have a deep understanding of how to use Excel effectively as well as knowledge of how to create pivot tables which will be needed for creating the pivot table based on the data from your Excel file using formula such as index, and Match, or Hllokup to replace RANGETOTABLE in a google sheet . Additionally, I pay close attention to accuracy in data analysis so that you get the most accurate results possible without any mistakes. I would love to discuss further how my skillset would best fit for this project so please feel free to reach out if you have any questions or would like more information about me or my services. Regards, faris
€20 EUR in 1 day
5.0 (2 reviews)
1.2
1.2
User Avatar
Hello, I can finish this job for you easily and quickly, and for a very fair price. I am a highly experienced programmer.
€15 EUR in 7 days
5.0 (1 review)
0.7
0.7
User Avatar
Hi there! My name is Asad, and I am a data expert. I understand that you are looking for someone to automate a task for you and create an Excel pivot table based on data from an Excel file. Specifically, you are looking for someone who can do this with precision, professionalism, and efficiency. With over 10 years of experience in freelancing, I have developed skills such as proficiency in Excel and pivot table creation, strong analytical and data interpretation skills along with attention to detail to ensure accurate analysis and trend identification. Additionally, I am available 24/7 via Freelancer Messenger so that we can discuss further how we can make this project happen together.
€8 EUR in 1 day
0.0 (1 review)
0.0
0.0
User Avatar
I understand that you are looking for someone to automate a task for you involving creating an Excel pivot table based on data from an Excel file. Specifically, you need someone who can do this with proficiency in Excel and pivot table creation who has strong analytical and data interpretation skills as well as attention to detail to ensure accurate analysis and trend identification. I believe I am the perfect fit for this project. My background includes working in customer service advisor positions, database management, advanced Excel and Data Studio so I have experience in these areas as well as knowledge of how to create pivot tables using Excel. Additionally, my skillset includes proficiency in Excel which will be necessary for the project as well as strong analytical and data interpretation skills which will be needed to produce an accurate layout and format for the pivot table. If you decide to accept my proposal please let me know immediately so we can get started on this amazing opportunity!
€14 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of PORTUGAL
Odivelas, Portugal
5.0
11
Payment method verified
Member since Jul 6, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.