Find Jobs
Hire Freelancers

Excel power query

$250-750 AUD

Closed
Posted 10 months ago

$250-750 AUD

Paid on delivery
I am looking for an experienced Excel expert to help develop a Power Query solution in order to collate and clean up my data. I have up to 100 Excel spreadsheets with forecast data for individual projects that I need someone to create a new query in order to efficiently collate and clean up my data. My main goal is to have a simplified, organized view of the data in order to make sense of what I have. We also have many other reporting templates that we require assistance with creation, ongoing support and customisation.
Project ID: 36710509

About the project

65 proposals
Remote project
Active 9 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
65 freelancers are bidding on average $436 AUD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$300 AUD in 5 days
4.9 (557 reviews)
8.4
8.4
User Avatar
"""""""""""""""""""""""""""""""""""""""ADVANCE EXCEL EXPERT"""""""""""""""""""""""""""""""""""""""""""""" ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORMULA'S, DASHBOARD in EXCEL Advanced Level Expert. This is my field and I can complete this project with added quality. About me I am a Chartered Accountant with more than 7 years of experience including 4 years from the worlds leading Accountancy and auditing firm ""PWC"" and 1 year working at managerial level in Multination company and 2 years as freelancer. I can handle this task very efficiently and you can expect 100% accuracy from me. I am Microsoft Excel, accounting, auditing, financial statements, Form Creation in Excel through VBA and in Google Sheet, QuickBooks, and Sage expert. I have been working as a freelancer from the last 2 years and I have 300+ 5 stars reviews here. I am not new to work. I know how to meet strict deadlines without compromising the quality of the work. I will also be available for any query after the job is done as I am building my clients. please be my client and get any type of accountancy, Excel, QuickBooks, and auditing-related work with quality, efficiency, and at reduced rates. Note. The price is negotiable. I will be available for any query round the clock even if the project is completed. Regards Arman Kakar "
$250 AUD in 1 day
4.9 (256 reviews)
7.3
7.3
User Avatar
Dear Sir, Are you looking for an experienced Excel expert to help develop a Power Query solution in order to collate and clean up your data? I am Smith, a highly experienced Excel expert with proficiency in Visual Basic, Excel, Excel VBA and Excel Macros. I am confident that I can help you develop a Power Query solution to collate and clean up your data. My steps to complete the project are as follows: 1. Understand your requirements in detail and analyse your data. 2. Create a Power Query solution to collate and clean up the data. 3. Develop and customize the reporting templates as per your requirements. 4. Test the solution and provide ongoing support. I am confident that I can deliver a solution that meets your needs and exceeds your expectations. To demonstrate my proficiency, I am willing to provide a free demonstration of the solution even before the project is awarded. I am looking forward to hearing from you. Thank you.
$500 AUD in 7 days
4.9 (76 reviews)
7.1
7.1
User Avatar
Hi there! As I have read, I see you need help developing a Power Query solution to collect and clean your data and I could help you! I'm a professional Database Administrator and Analytics Engineer with more than 10 years of experience and more than 300 projects done here on this platform. I offer unlimited revisions and I don't require any payment in front. I always meet delivery deadlines working until I get the desired results. I know all the most used softwares to do this project specifically, I could even give you some other options in case you think is better to use other tools. Send me a message so I can show you my previous work and we can discuss more. Appreciatively, Giovanni.
$250 AUD in 1 day
4.9 (59 reviews)
6.9
6.9
User Avatar
Excel power query. 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.
$500 AUD in 4 days
4.8 (151 reviews)
5.8
5.8
User Avatar
Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all efficiency you are looking for. I understand the requirements and am able to start this project right now. Let’s get started by initiating a chat box to make your project to the next level of automation.
$250 AUD in 1 day
5.0 (56 reviews)
5.2
5.2
User Avatar
Hello sir/ madam I checked your project description. I can do Microsoft Excel power query task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saaniya.
$250 AUD in 1 day
4.7 (133 reviews)
5.6
5.6
User Avatar
Hi, I have gone through the Job details and am interested in taking it up. I need you to share the file with me along with the required changes and I will deliver the required tasks fast and accurately. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein
$300 AUD in 4 days
5.0 (31 reviews)
5.2
5.2
User Avatar
Hello, I have Power and Excel/Google Sheets skills and am able to provide solutions to most Excel/google sheet problems, including VBA programming. If you work with me you will get good value for your money and a flexible approach to carrying out your work. I am great with deadlines and I will keep you updated throughout the process the quality of my work is high. Please Ping me in the chat box for further discussion. Thank you! Anuradha
$500 AUD in 7 days
5.0 (40 reviews)
4.8
4.8
User Avatar
With over 7 years of experience in excel usage and an ACCA qualification, I have expertise in all areas of Excel, I can provide you with efficient, accurate, and insightful solutions to your data-related challenges. My Excel services include the following: Financial modeling: As an ACCA qualified professional, I have extensive experience in creating financial models in Excel. I can help you create complex financial models, including cash flow projections, discounted cash flow analysis, and financial statement analysis. Data analysis and visualization: I can perform various types of data analysis, including statistical analysis, data modeling, and regression analysis, and visualize the results using charts and graphs. I have worked with large data sets and can help you summarize and present your data in a meaningful way. Reporting and dashboards: I can create custom reports and dashboards to help you visualize and analyze your data, and make informed decisions based on the insights gained. I can also design interactive dashboards that allow you to explore your data in real-time. My development process includes an initial consultation to understand your requirements and objectives, followed by designing and implementing customized solutions to meet your specific needs. I am committed to delivering high-quality services and ensuring customer satisfaction. Please don't hesitate to contact me if you have any questions or would like to discuss your project further. Best regards,
$750 AUD in 3 days
5.0 (44 reviews)
5.0
5.0
User Avatar
Hello, I'm a professional excel programmer, SQL Expert , Ready to do the required automation of data clean and organization of your excel data
$500 AUD in 7 days
5.0 (17 reviews)
4.6
4.6
User Avatar
I have good experience in using advance excel, power queries and VBA. I am interested to assist with the project. Please let me know the details. Thanks.
$500 AUD in 7 days
5.0 (23 reviews)
4.5
4.5
User Avatar
Hey ! Good evening After reading your job posting, I am convinced that I am the best person to help you. I have skills in Excel Macros, Excel, Visual Basic and Excel VBA. I have worked in many projects similar to yours, making this an interesting task for me. Please message me for more information on how I will complete this project. Thank You Carol M.
$555 AUD in 1 day
5.0 (1 review)
4.0
4.0
User Avatar
Hi, As a data analyst with over 4 years experience in excel, power query, vba and advanced formulas I would like to work on this project. I can create query which will upload data from selected files/folders, next clean the data and get desired table/pivot table or data model. I offer unique solutions with explanation of each step if you will need. Please consider my proposal - power query it's my main tool that I use on a daily basis. I would really appreciate for the cooperation. Best Regards,
$250 AUD in 2 days
5.0 (6 reviews)
3.6
3.6
User Avatar
Hi, Shraddha is my name and Power Query is my game! I love it so much that I just randomly pick data and start cleaning because it is so much fun. I have a lot of experience in collating sheets and cleaning up data so this is one of those projects that excite me. I am an Excel, Power Query, VBA, & Power BI specialist. I have prepared several Dashboards, some you can see in my profile and some I will share with you when you message me in chat. I can create measures and am also very good with DAX and M code, I will definitely love to work with you and will be able to give you great results. Lets discuss in chat, I can work long term. This can be a start of something awesome! Please give me a chance Thanks
$250 AUD in 1 day
5.0 (5 reviews)
3.6
3.6
User Avatar
Hello mattr3, We went through your project description and it seems like our team is a great fit for this job. We are an expert team which have many years of experience on Visual Basic, Excel, Excel VBA, Excel Macros Lets connect in chat so that We discuss further. Thank You
$500 AUD in 7 days
5.0 (3 reviews)
3.3
3.3
User Avatar
Hello there! My name is Md. Akibul and I am an experienced Excel expert. I understand that you are looking for someone to help develop a Power Query solution to collate and clean up your data. With my extensive experience in Excel and VBA, I can easily take on this project. I have been working on Excel & VBA for more than five years. Additionally, I have completed numerous real world projects in my previous jobs. This makes me confident that I can deliver quality results for your project requirements. Moreover, I have completed courses about Excel VBA on Coursera which gives me additional knowledge about the subject. I believe that my skillset, experience and dedication make me the best fit for this job requirement. If you would like to discuss further please reach out to me directly so we can kickstart the discussion!
$250 AUD in 1 day
5.0 (6 reviews)
3.0
3.0
User Avatar
Hello, I have some experience with Excel Power Query. Did you excel data is structured? Kindly could you share details about the current data and its structure? and what you want as output? Ronald Garcia.
$250 AUD in 7 days
5.0 (3 reviews)
3.1
3.1
User Avatar
Hi. i am a data analyst, i have expertise in Excel and power bi. i can do this job. come to chat to discuss it. i am interested and ready to start...
$250 AUD in 3 days
4.8 (6 reviews)
2.4
2.4
User Avatar
Hey Bryson Henniger here! Can you provide a sample of the Excel spreadsheets that need to be collated and cleaned up? What specific data elements or columns do you need to extract from each spreadsheet? Are there any specific criteria or rules for cleaning up the data during the collation process? Do you have a preferred format or structure for the organized view of the data? Are there any unique identifiers or keys that can be used to link the data across multiple spreadsheets? Are there any specific calculations or transformations that need to be applied to the data during the collation process? Can you provide any guidelines or requirements for the reporting templates that need to be created? How frequently will new spreadsheets be added to the data collation process? Are there any specific Excel functions or formulas that you would like to be incorporated into the Power Query solution? What is the desired output or outcome of the data collation and cleanup process? Are there any existing templates or examples that can be used as a reference for the reporting templates? What is the level of ongoing support and customization that you require for the reporting templates?
$300 AUD in 10 days
4.8 (2 reviews)
2.1
2.1

About the client

Flag of AUSTRALIA
Geelong, Australia
0.0
0
Payment method verified
Member since Jun 6, 2023

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.