Excel parts search screen

$30-250 USD

완료함

게시됨

23일 전

$30-250 USD

제출할때 지불됩니다

I need a skilled Excel expert to create a comprehensive spreadsheet and optimize its formulas and functions. The project needs to be completed within a month. Key Tasks: - **Spreadsheet Creation**: The successful freelancer will be responsible for creating a detailed spreadsheet that will serve as a part search tool. - **Formula and Function Optimization**: I need assistance in optimizing the formulas and functions within the spreadsheet. This is to ensure the tool is efficient, accurate and user-friendly. I would like to have a new parts search screen made up similar to the one attached ( Storeroom Parts Locator. ) but using the attached excel sheet (inventory Report) Nice UI on front page would be great! should be able to search for description and or part number. results should be easily view able and printable search results should show : Item Code (Column H -Inventory Report), Item Description (Column F -Inventory Report), and locator Name ( Column Z - inventory report) , Onhand qty (column O-inventory report) Would also like to have a similar "import custom catalog" function where we can upload a new "inventory report" as needed and entire search document will be updated. documents: Example : Storeroom Parts Locator V6 New report to incorporate : Inventory Report * if possible please unlock Storeroom Parts Locator v6 excel Any questions please feel free to reach out to me Ideal Freelancer: - Proficient in Microsoft Excel with a strong background in data structuring and management. - Experienced in creating complex spreadsheets for specific purposes. - Skilled in optimizing formulas and functions for advanced data analysis. - Efficient and committed to deliver high-quality work within the given timeline.

프로젝트 ID: 38023134

프로젝트 정보

87 제안서

원격근무 프로젝트

활동 중 22일 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

프로젝트를 수여된 사용자:

@AishaAlimuhammad

$0 USD 7일에

5.0

(479 건의 리뷰)

9.2

87 이 프로젝트에 프리랜서들의 평균 입찰은 $198 USD입니다.

@P0L

Hello, I am an Excel/VBA expert and I would like to help you with your parts search tool. Please check my profile and contact me to discuss further details. Best regards.

$200 USD 10일에

5.0

(516 건의 리뷰)

8.1

@axiomswb

Hi there! I have expertise in this domain. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

$140 USD 3일에

5.0

(89 건의 리뷰)

7.1

@ayesha0124

Hello, I believe i can help u with getting this job done as i have the great knowledge of Data Entry, Visual Basic, Excel, Data Processing and PHP. I have working experience of several years on this platform. So please initiate the chat to discuss with me in detail. Regards, Ayesha

$250 USD 7일에

5.0

(17 건의 리뷰)

6.6

@rabbiawebjuggler

Hi I am expert in Data entry, Web search and also Alison certified in excel. I am ready to start now Quality is my top priority Ping me back for further discussion Thank you!

$140 USD 1일에

5.0

(130 건의 리뷰)

6.8

@giaphung2k1

Hiya I can do this project. I am a professional Linux and developer in PHP, Wordpress, Laravel, Magento, Joomla, Prestashop, OpenCart, Yii, NodeJS, ReactJS, Angular, Vue.js, HTML5, CSS3 and jQuery. I can do this project. Please hire me. I think, You will contentment with my skills. I can fix your site issue successfully I am looking forward to having further discussions with you and can start working immediately. Best regards, Giáp Văn Hưng

$250 USD 7일에

5.0

(109 건의 리뷰)

5.9

@vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am an experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more detail. Thanks, Virendra

$140 USD 7일에

4.8

(153 건의 리뷰)

6.2

@DGM999

Hello Jason M., I am Sadat Saeed, a PHP expert with 8 years of experience. I have carefully reviewed your project requirements for creating a comprehensive Excel parts search tool. I propose to develop a user-friendly search screen with optimized formulas and functions, similar to the attached Storeroom Parts Locator V6. My portfolio showcases successful projects and positive client testimonials. Let's discuss further details. Please start the chat to explore this project. Portfolio: https://www.freelancer.ca/u/DGM999 Best regards, Sadat Saeed

$85 USD 3일에

4.8

(41 건의 리뷰)

5.9

@ExpertSoul

I understand that you are looking for Excel parts search screen With expertise in Microsoft Excel, I'll craft a comprehensive spreadsheet for part search, optimizing formulas and functions to ensure efficiency and accuracy, while enhancing user experience with a user-friendly interface. My commitment to delivering high-quality work within the timeline ensures a seamless solution tailored to your needs. I believe in client satisfaction, therefore payment is only required once you are fully content with the work. Feel free to initiate a chat to discuss this project further. You can visit my Profile https://www.freelancer.com/u/ExpertSoul Thank you

$75 USD 1일에

4.8

(31 건의 리뷰)

5.7

@amokhtar70

Hi, I have gone through the Job details and am interested in taking it up. I need you to share more details with me, and I will deliver the required tasks fast and accurately. We will negotiate my fees depending on how many hours it will take to fulfill the work. 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

$120 USD 4일에

5.0

(44 건의 리뷰)

5.4

@Jatin77777

Hello, I have more than 14 years of experience in reporting and data analysis. I have designed multiple dashboards and VBA automation to reduce human intervention to enhance data accuracy. These dashboards and reports have dynamic views and functionality to present the data Like: checkboxes, radio buttons, drop-down lists and graphical data representations (Bar charts, pie charts, heat maps, Gantt chat, etc.). Successfully delivered Dashboard, Scorecard, Heatmap & Ad-hoc requests to my clients. I can help you here; I went through the mentioned details and found that I can give you support to complete your task. Please check my portfolio once for more information. Further, we will discuss this on chat. Thanks in advance for your valuable time. Thanks, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR | Gsheet

$160 USD 7일에

5.0

(28 건의 리뷰)

4.8

@saifulcmab

Hello, I can do your job. I am a Professional Accountant with an MBA in Accounting and Information Systems. I am a QuickBooks Pro-Advisor and Xero-certified. I am certified by Duke University, USA in Business Analytics and also Certified in advanced Excel & data analytics from Macquarie University, Australia. I have in-depth knowledge of the business and 10+ years of Managerial experience. I look forward to your project discussing more specifications in the chat box. Best Regards

$140 USD 7일에

5.0

(8 건의 리뷰)

4.8

@javedabbasi8080

Hello, I am excited about the opportunity to assist you with creating a comprehensive and optimized Excel spreadsheet for your parts search tool. With my expertise in Microsoft Excel and data management, I am confident in delivering a high-quality solution within your timeline. I have a strong background in structuring and managing data effectively within Excel. I specialize in creating complex spreadsheets tailored to specific needs, such as your parts search tool. I will ensure that the spreadsheet is user-friendly, efficient, and accurate. Optimizing formulas and functions is one of my core skills. I will enhance the performance of your spreadsheet by streamlining calculations and improving data retrieval processes. The search functionality you described, including searching by description or part number and displaying relevant information like item code, description, locator name, and on-hand quantity, will be implemented with precision. Additionally, I can incorporate a feature to import new inventory reports seamlessly, ensuring that your parts search tool remains up-to-date and functional at all times. I am committed to providing exceptional service and will collaborate closely with you to understand your requirements fully. My goal is to exceed your expectations and deliver a solution that enhances your workflow effectively. Best regards, JAVED

$140 USD 7일에

4.9

(33 건의 리뷰)

4.9

@GdevDataSceince

Hi there, I am a Data Scientist and a professional responsible for extracting actionable insights and knowledge from large volumes of data for Microsoft applications Development. I can write clean Excel, Word, Access, PowerPoint, Power BI, and Outlook and create VBA macros. Excel: Advanced Array Formulas, Charts, Pivot Tables, Pivot Charts, Mail Merge, VBA Macros, Excel Macros, Capabilities, Spreadsheets. Email through Outlook and Gmail, Add-in, Customized Macros. My top priority is to provide high-quality work; I am willing to fully devote my time and energy to improve the service offered with timely, accurate, and professional results; building trust and a long-term relationship with customers is my main objective. https://www.freelancer.com/u/GdevDataSceince Choosing me for this project means benefiting from my extensive skills in Excel and data analysis and entrusting your sales data with someone who values precision and confidentiality. Let's begin working together on this valuable project to deliver lasting results that will positively impact your business. Thanks Gdev

$100 USD 3일에

5.0

(11 건의 리뷰)

4.7

@derekjlaporte

Hello, Jason M., Thank you for posting the job "Excel parts search screen". With my extensive experience in software development, I am confident that I can deliver perfect results for your business. I have a deep understanding of the field you mentioned and have successfully completed projects of similar complexity in the past. I am available to start immediately and can assure you of high-quality work delivered with speed and efficiency. Given the opportunity to work on this project, I am committed to exceeding your expectations. I'd like to discuss further details about your project in a brief call or chat soon. Looking forward to working with you! Best regards, Derek

$200 USD 2일에

5.0

(1 건의 리뷰)

4.1

@qadrifreelancer

As an Excel developer, I understand the requirement to create a comprehensive spreadsheet for a parts search tool. My approach would be to design a user-friendly UI for easy navigation, implement efficient search functionality based on part number and description, and display relevant information such as Item Code, Item Description, Locator Name, and Onhand Quantity. I propose to optimize formulas and functions to ensure smooth operation and quick response time. Additionally, I would incorporate an "import custom catalog" feature to facilitate easy updating of the inventory report. To streamline the process, I have a few questions: 1. Do you have specific design preferences or color schemes for the UI? 2. Is there any specific criteria for filtering search results, such as sorting options? 3. Could you provide more details on the data structure and any specific calculations required in the spreadsheet? I am proficient in Excel, data structuring, and formula optimization, and I am confident in delivering high-quality work within the given timeline. I look forward to discussing the project further and collaborating to create an efficient parts search tool.... Come over chat

$200 USD 2일에

5.0

(7 건의 리뷰)

4.1

@janita24

Hi Jason M., Good morning! My name is Jane a skilled Statistician with skills including Data Entry, Excel, Visual Basic, Data Processing and PHP. I have over 5 years in tutoring data analysis and statistics. Having completed similar project, I am confident in my ability to deliver high-quality results for this project. I am eager to discuss further details and see how I can contribute to your team. I am happy to offer a free consultation and a 10% discount for first-time clients. Please contact me to discuss more regarding this project. Regards Jane

$140 USD 3일에

5.0

(15 건의 리뷰)

4.2

@stheven19

As a seasoned data analyst, I understand the importance of a well-structured and optimized spreadsheet, which is precisely what you need for your parts search tool. With my excellent command over Excel and Visual Basic, I will create an efficient and user-friendly interface allowing you to easily search, view and print out the required details from your inventory report. Optimizing formulas and functions in spreadsheets is another one of my core strengths. I'll ensure that every formula and function is working accurately and efficiently to give you the most accurate results. As requested, I will add a capability to upload new inventory reports directly into the search document for continual updates - saving you time and effort. Moreover, I strongly believe that collaboration doesn't end with project completion. My commitment to providing excellent post-service support aligns perfectly with your vision of a lasting professional partnership. And finally, just a note to let you know that I had some issues with unlocking the existing Storeroom Parts Locator v6 excel due to security measures, so instead I'll create a completely bespoke solution that tailored specifically to your needs. Choose me for this project and let's unlock your data's hidden potential together! Looking forward to working with you!

$150 USD 1일에

5.0

(13 건의 리뷰)

4.0

@shahajalalbabu00

Hi Jason! As a professional and dedicated freelancer, I understand the value of accurate and efficient data entry. My expertise in Data Entry, Data Processing, and Excel will surely prove useful for this project. I have an excellent command over Power BI and can help you extract your data exactly the way you see it on the platform. In line with your goal to download the Excel file with utmost precision, I can assure you that my meticulous attention to detail will ensure a flawless transfer of all your data. Moreover, I have a strong understanding of how Power BI functions, which helps me maintain data integrity while exporting. Finally, my commitment to client satisfaction means that I will be available 24/7 for any queries or changes you might require. We'll be able to work closely together during the project, guaranteeing not only a successful transfer but also a pleasant collaboration experience. Choose me for this project and let's achieve your goal together! Thanks

$30 USD 1일에

4.9

(38 건의 리뷰)

3.9

@emdi85

Good day! Thanks for your posting. I have read your description carefully I am a good fit for this project due to my strong skills and experience as discussed on project modules. ******Please send me a message so that we can discuss more details.****** Gladly waiting to serve you with my extensive skills. Thanks for reading my proposal.

$140 USD 7일에

5.0

(5 건의 리뷰)

3.5

@Palakash21

We specialize in crafting modern and effective websites, web and Mobile applications, and ERP solutions. Having reviewed your project description, we believe our comprehensive suite of services can deliver a solution that surpasses your expectations. Our team is proficient in a comprehensive range of web development technologies, including the industry standards like HTML5, CSS3, and JavaScript. This allows us to build robust and visually appealing websites. We also leverage the power of languages like PHP, Python, and Java .NET for more complex functionalities. Let's schedule a meeting to discuss your specific goals and receive a free quote tailored to your project needs. Thank you for your time and consideration. Sincerely, Akash Pal

$140 USD 7일에