Excel Mastery: Test Automation

min $50 AUD / hour

Completed

Posted

3 months ago

min $50 AUD / hour

I'm looking for an Excel expert who can help me create a dynamic and automated Excel test. This project is ideal for those who are not only proficient in Excel's formulas, functions, and data analysis capabilities but also have a solid grasp of Visual Basic for Applications (VBA) to implement macros and automate processes. Requirements: - Proficiency in Excel functionalities, including complex formulas and functions. - Experience in developing and implementing macros for automation. - Strong knowledge and comfort in using Visual Basic for Applications (VBA) within Excel. - Ability to create dynamic and automated tests within Excel to facilitate specific objectives. - Innovative thinker with the ability to suggest improvements or efficient methods to achieve the project's primary goal. Ideal Skills and Experience: - Extensive experience with Excel and its advanced features. - Demonstrated history of creating automated systems or tests in Excel using VBA. - Strong analytical skills to understand and implement the best solutions for given tasks. - Excellent communication abilities to ensure the project's requirements are met and any potential adjustments are clearly discussed. The primary aim of this project is to leverage Excel's automation capabilities to create an automated test. This tool should not just fulfill the current requirement but also be adaptable for future needs. Candidates with a creative approach to problem-solving and who have successfully delivered similar projects will be highly regarded.

Excel

Visual Basic

Visual Basic for Apps

Data Processing

VB.NET

Project ID: 37769047

About the project

55 proposals

Remote project

Active 3 mos ago

Looking to make some money?

Email address

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:

@ParisPallas

$0 AUD in 40 days

5.0

(664 reviews)

8.7

55 freelancers are bidding on average $52 AUD/hour for this job

@schoudhary1553

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

$50 AUD in 40 days

4.9

(598 reviews)

8.5

@P0L

Hello, I am an Excel/VBA expert and I would like to help you with your test automation project. Please check my profile and contact me to discuss further details. Besy regards.

$75 AUD in 20 days

5.0

(515 reviews)

8.1

@akritisood94

Hello, and thank you for considering me for your Excel Mastery project. I'm Akriti, an ardent fan of data analysis, automation, and efficiency - qualities that align perfectly with the tasks at hand. My proficiency in Excel's formulas, functions, and Visual Basic for Applications (VBA) make me a formidable candidate for this project. My experience extends far beyond just using VBA to create macros but into leveraging its capabilities to bring data alive by providing valuable insights. I can take on the challenge of creating dynamic and automated tests in Excel with utmost dedication. My skills go beyond just meeting requirements, I am well-versed in suggesting innovative improvements and more efficient approaches towards a goal; demonstrating my strong analytical skills. My track record speaks for itself - as I have successfully delivered on similar projects before. I understand the unique challenges and possibilities that come with automating tasks within Excel, having worked extensively with it, implementing advanced features like macros and data analysis over the years. Let me help you automate your test to not only meet your current requirements but also adapt to facilitate future needs.

$50 AUD in 40 days

4.9

(420 reviews)

7.5

@maverick44000

Good Day Sir, I am highly skilled in Excel and VBA scripting and have extensive experience spanning over a decade. Please invite for a chat and discuss your exact requirements so we may kick off. I am available to start working right away. Thank you, Usman

$55 AUD in 30 days

5.0

(96 reviews)

7.1

@SShtv

Hello, I'm interested in your project. Your task is clear to me and I am ready to solve it. I have extensive and successful practical experience in processing and analyzing data in Excel, including using formulas and macros.

$50 AUD in 40 days

4.9

(135 reviews)

6.7

@AwaisChaudhry

Hi Good evening , I have read the brief details on your job listing . I see you have been looking for someone experienced with Excel, VBA Development. Its been 8 years since I have been working on freelancer.com, I have 9 years of experience doing similar jobs. I would request you to check my profile and review projects, feedbacks of projects related to those skills. Questions: 1. These are all the requirements of your job or do you have more? If yes, Please provide detailed requirements in chat and let me review and get back with queries. 2. Do you currently have anything done or this job has to be done from scratch? 3. What is the timeline to get this job done? 4. Are you open to use 3rd party APIS for it even if they are paid? 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. Portfolio: https://www.freelancer.com/u/AwaisChaudhry Timings: 9am - 9pm Eastern Time (I work as a full time freelancer) Please initiate the chat so we could discuss it in detail and we will continue from there. Thanks! Awais

$50 AUD in 40 days

5.0

(6 reviews)

6.5

@arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project. Kind Regards Arun

$50 AUD in 40 days

5.0

(48 reviews)

5.8

@faisal9263

Dear Hiring Manager, I am an Excel expert with a proven track record in developing dynamic and automated tests using advanced formulas, functions, and VBA. With extensive experience in creating efficient solutions, I am confident in delivering a tool that not only meets your current needs but is adaptable for future requirements. My strong analytical skills and communication abilities ensure a collaborative and successful project. I have a history of implementing innovative solutions and am eager to contribute to your objectives. Let's discuss how I can bring my expertise to your project.

$50 AUD in 40 days

5.0

(19 reviews)

5.4

@techplusintl

Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 8+ Years of Experience ★★★ I've read requirements and ready to create a dynamic and automated Excel test. I provide complete ranges of solution for your Excel, Custom Formulas / Functions, Pivot Table, Dashboards, VBA and Macros Automation need. I can also provide similar past Excel work example before being hired. Services we offer: ✔️ Custom Formulas ✔️ VBA Macros Automation ✔️ Vlookup / Hlookup ✔️ Countif / Countifs ✔️ Converting CSV files in to specific format. ✔️ Export & import of Excel files in to specific excel file ✔️ Visual Basic User Forms, for user interface designing and dashboards ✔️ Interactive Pivot Tables and Graphs. ✔️ Converting Excel to PDF or CSV ✔️ Complete Dynamic VBA Macros Dashboards ✔️ Removing Duplicates from the File ✔️ Data Entry with automated process As the requirements on project are not complete and need discussion so i placed tentative bid. To provide you the best quote, let's have a chat! Best Regards, TechPlus Team

$50 AUD in 40 days

5.0

(10 reviews)

5.4

@zafarfarooq612

Greetings, I am an Excel expert eager to assist in creating a dynamic and automated Excel test, leveraging my proficiency in Excel's formulas, functions, and data analysis capabilities, as well as my solid grasp of Visual Basic for Applications (VBA) for macro implementation and process automation. With experience in developing and implementing macros for automation and a strong knowledge of VBA within Excel, I am well-equipped to create dynamic and automated tests to meet specific objectives. My innovative thinking allows me to suggest improvements or efficient methods to achieve the project's primary goal, ensuring the tool is adaptable for future needs. I have a demonstrated history of creating automated systems or tests in Excel using VBA, and my strong analytical skills enable me to understand and implement the best solutions for given tasks. With excellent communication abilities, I am committed to meeting the project's requirements and facilitating clear discussions on potential adjustments. I am dedicated to delivering a high-quality, automated test that fulfills the project's objectives and exceeds expectations. Best regards, Zafar

$50 AUD in 40 days

4.9

(70 reviews)

5.2

@remisanonymous

Hi, I have a few years of experience in programming VB and VBA macros, importing, exporting, sorting, calculating, and manipulating data in Excel, what can make me the perfect fit for this project. Can you provide more details about your project, what test automation you need? Please feel free to contact me if you have any questions or would like further information on my skillset or profile. Best regards, Remis

$50 AUD in 20 days

4.9

(22 reviews)

4.5

@andrwojsz

Hi, Thank you for your detailed description and clear requirements. As a data analyst with more than 5 years of experience, I would like to join the project and provide relevant solutions. I can create macro code, dynamic formulas or queries to perform the desired tests. I have experience in creating tests, automatic changes and reports using Excel tools for the financial industry. I will be happy to share some reports in private chat. I would really appreciate for the cooperation. Best Regards,

$50 AUD in 20 days

5.0

(6 reviews)

3.6

@devbaloni1983

IHi, ***** .Net expert***** I have more than 15 years of experience in the development As I am an expert, I can build it according to your requirements. Because I have a lot of experience in these fields, I can build your project as soon as possible. I offer excellent software quality work and provide the best support for your project. If you give me this job, I will do my best to finish your job by your timeline. If you want to see my past works, I can show you my past works right now. Ready to discuss this with you about the task now. Thank you for the reading. .

$50 AUD in 40 days

5.0

(2 reviews)

3.0

@kavitadhingra

Hi there! I'm Kavita, and I believe I'm the Excel expert you need for your test automation project. With over 10 years of experience working with Excel and VBA, I've built a strong foundation in utilizing these tools to streamline processes and accomplish complex tasks efficiently. My proficiency with advanced Excel features, including complex formulas, functions, and data analysis, ensures I can create the dynamic and automated tests you're looking for. In addition to my vast technical knowledge, my creative problem-solving approach sets me apart. It's not just about meeting the current requirements; it's about providing a solution that can adapt to future needs. From my track record of successfully delivering similar projects to proposing innovative methods to optimize Excel's automation capabilities, I understand the value of efficiency and adaptability in test automation. Lastly, the ability to communicate effectively is vital to project success. Having liaised between teams on various Power BI projects, I understand the importance of understanding and addressing client needs. I'll ensure that we are on the same page throughout the project lifecycle, proactively suggesting improvements where possible. Let's combine your vision with my expertise to create a seamlessly automated solution that surpasses your expectations. Let's discuss how we can make your test automation process an efficient one for your team!

$50 AUD in 40 days

5.0

(9 reviews)

3.2

@kmhasancpa

With my extensive experience in Data Processing and Excel, I am well-equipped to handle your project. I have a deep understanding of Excel's advanced features including its formulas, functions, and VBA. In fact, I’ve dedicated more than a decade to different projects requiring high-level Excel expertise much like yours. My proficiency with VBA makes me specially suited in terms of developing and implementing macros for automation. I guarantee that the dynamic and automated test I create for you will not only meet your present requirements but can also be adaptable for any future needs. This aspect, in my opinion, is vital for a tool that can grow alongside your business. Lastly, as the owner of a company with 70 members, I understand the importance of timely communication and collaboration in completing any project satisfactorily. Rest assured, my team is dedicated to providing high-quality work with quick turnaround times. With me working on your project, you can expect a lucrative combination of technical excellence and customer-centric execution.

$51 AUD in 30 days

5.0

(3 reviews)

2.5

@GSingh009

Dear Client My relevant experience includes SQL Server development SSRS (SQL Server Reporting) C# .NET MAUI Angular, Node JS .NET Core Web API MS Access VBA/Macro/Visual Basic. Based on my understanding of the project requirements, I propose a fee of USD 25/Hour (INR 2000/Hour). Please review my profile and let me know if you have any questions or require additional information. I look forward to hearing from you soon. Thank you for considering my proposal. Best regards, Gajendra Singh

$50 AUD in 40 days

5.0

(3 reviews)

1.9

@Asadjutt111

With over a decade as a trusted data strategist under my belt, I'm thrilled to bring my Excel wizardry to your project. Crafting dynamic and automated systems with complex formulas, functions, and VBA macros is where I truly shine. My proficiency in Excel's advanced features combined with a creative problem-solving approach will ensure the test created not just meets your current requirements, but also transcends future needs. I've successfully delivered similar automation projects throughout my career, including comprehensive tests for enhanced efficiency. These accomplishments have equipped me with strong analytical skills to implement the best solutions for given tasks, exactly what you're seeking. As your dedicated data ally, I take exceptional pride in not only meeting client expectations but surpassing them. Nothing gives me greater satisfaction than delivering top-notch results within tight timelines and budgets while ensuring 100% customer satisfaction. Let's steer your project towards a resounding success!

$50 AUD in 40 days

5.0

(3 reviews)

1.9

@NoSonforhim

Hello, I read your project description and understand all. I have 20 years in Database development, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA VB6, Vb.net, C#, and MS SQL server I will make the perfect product what you want. I promise to complete your project within your time and budget beyond your expectations. I am willing to work at lower pay. Let me know when we can discuss and share all.

$50 AUD in 40 days

5.0

(2 reviews)

1.5

@JanAngelo8

Hello, Great to meet you. I am a senior Excel expert with a passion for automation. My proficiency in Excel's formulas, functions, and data analysis, combined with my strong knowledge of Visual Basic for Applications (VBA), makes me the perfect candidate for your Excel Mastery: Test Automation project. With my expertise, I can create dynamic and automated tests to achieve specific objectives, saving time and effort. I am also an innovative thinker and can suggest efficient methods to improve processes. Solutions for the job: - Develop and implement macros using VBA for automation. - Utilize Excel's formulas and functions to create dynamic tests. - Continuously improve processes and suggest efficient methods. Cheers.

$50 AUD in 40 days

0.0

(0 reviews)

0.0

@ziaullahdz

Hi There! I have understood the requirements for the task. I have 6+ years of experience in performing Data Analytics, Automation and various other calculations and analysis using VBA, Macro, Power Queries, Pivot tables, and excel based formulas. My expertise is broad and versatile and includes: *Microsoft Excel- Advance formulas -VBA/Macros -Dashboard -Data Analysis -Web-Scraping and Data Entry. *Adobe Acrobat-Fillable forms -Editing and Scripting. *Google Sheets-Advance formulas -Custom Scripts -Dashboard I am Proficient in Microsoft Excel, Adobe CS & CC Photoshop, Illustrator, InDesign, Adobe Acrobat and Google Sheets, and Wordpress I am waiting for a response from your side. Thanks

$50 AUD in 40 days