I need a excel expert for help creating Inventory tracking templates I can work with
$250-750 USD
Closed
Posted over 3 years ago
$250-750 USD
Paid on delivery
I have a small HVAC company that I am starting from the ground up and need templates that I am able to plug in relevant info into.
I currently order and buy all of my supplies through these vendors;
Acme, Gensco, Thermal, Platt, Keller, Ferguson, and HomeDepot.
I have all of my supplies accumulated in a supply room and hand out to employees every day as needed. I have the employees signing out items that they take daily, but I have no way of tracking what is going out each month other then the papers I have them sign items out on. I have no idea what I am spending on these items each month and can not account for areas of waste to see where my money is going, also need to be able to track quantity of my supplies on hand to know when items need to be re ordered and what I actually have versus should have on hand.
I need Excel templates that have the formulas so that I am able to just plug the relevant information in.
Attached is an example of a list of supplies that I order from ACME and currently have in our supply room. There are similar lists I am now putting together for the other suppliers that I listed above which I am still compiling.
I need a way to get organized and control of my supply room. So I need templates that have the formulas and are all set for me to just be able to plug in the relevant information needed and be able to;
1) Track my current inventory levels and keep track of any items that need to be re-ordered
2) Track how much of each item I am ordering and being given out each month to employees so that I can track where my money is going and track any potential waste.
Dear Employer,
I am an Excel expert with over a decade of experience and perfectly understand your job. Will deliver a professional job. Kindly check my previous reviews once for your kind consideration!!
Thanks,
Ashish
Hi,
How are you?
I have developed several Excel & Word VBA macros before. And I know about Excel formulas very well.
If needed, I first can do a demo and send it asap. And then you can see it and decide on this project.
Also, I can send some of my VBA apps.
I can complete your job successfully in your mind.
Wishing for your response.
Let me try at your job.
Thanks
-----EXCEL EXPERT --I CAN START RIGHT AWAY -----
Hello I have checked your attachment and description I can help you with your creating Inventory tracking templates work project I have many project done as like your work I am ready to this work . we can meeting over this project
Anowar
Hi Sir,
I went through the job description. I can provide you fast and accurate solution to track the inventory, Ordered Quantity month on month ect. I have 10+ years of experience in Excel/VBA. Please check my past reviews. Please ping back to discuss in details and get started. I assure you i will provide you cost effective solution.
Thank You
Regards
Rishi
NOTE : I HAVE EXPERTISE IN EXCEL AND VBA.
With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully completed projects which involved Programming, scripting, web scraping, excel.
Key features of my work are as follows:
1) Always within schedule
2) Always within scope
3) Best tools and techniques used for the completion of tasks
Looking forward to hearing from you.
Regards
Senior Excel VBA / Macros expert.
As 12+ 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 platfrom give me a chance to show you the best i can do at your service.
**** templates for excel and also have created various excel dashboards on this platform******
Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 61 projects on FL. Expertise in -
• Macros
• Formulae
• VBA
• User forms
Willing to share a sample of my work done on various excel applications on this platform.
Looking forward to hearing from you.
Thank you
BAVarun
PS: Please have a look at the reviews given to me on this platform.
PPS: The price indicated in the bid is generic in nature. It may change basis on the scope of work post our discussion
Hello,
I have thoroughly read your project details and checked the attached list. The required skills match my expertise and I would love to work with you on this project.
I am an Excel expert. You can check my recent reviews in Excel projects and repeat hires. Kindly review the project details of a project I recently completed. https://www.freelancer.com/projects/excel/Excel-expert-calculate-daily-cattle/details
Further, I am a qualified and experienced professional having in-depth knowledge and vast experience in Accounting and Finance, enabling me to perfectly manage your project.
I am sure my experience and skills will deliver the best results.
I can start immediately.
I offer quality, accuracy and long term support.
You can initiate the chat or send me a message so that we can discuss the project in detail and move forward.
Looking forward for working with you.
Regards,
Hamid
Good day. I have been using MS Access and Excel with VBA for my personal and professional use and I can guarantee you that I can finish the project as soon as possible without sacrificing the app's quality. I can build you an Inventory Management database using MS Access complete with all the UIs needed to make it useful and functional fit to your needs. Feel free to message me so that we can talk more about this project. Thanks and have a nice day.
Hello,
I am expert in Finance. I can prepare your inventory template as per your requirements. I have done the same type of work. Please have a look:
https://www.freelancer.com/projects/excel/High-Level-google-access-excel/reviews
Looking forward to hearing from you.
Regards;
Younus
I can perfectly help you with that. I am a professional Data Analyst and Excel expert holding years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Thanks
Jayant
Hi there,
This sounds like an interesting project and I would like to create the templates for you so that you can easily track inventory levels and know where your money goes.
With an accounting background and over 10 years of experience in working with Excel (with a focus on the automation and streamlining of processes), I will create your personal solution that fits your needs.
I am reliable, work thoroughly and with an eye for detail, stick to my deadlines and deliver high quality solutions.
I look forward to having a chat about the details.
Warm regards,
Nadja
✔Excel/ Macros Expert
Hi Greetings!!
I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA and Macro) to perform Data Analysis, Data Visualization, Financial Analysis, Financial Modeling and various types of Analysis, Automation and complex calculations. I will be happy to discuss in detail how I am highly suitable for this project.
Thanks
Arun
Hello,
I am offering myself to help you to complete this project. I gained throughout my working experience. I am interested to take part in this project.
Thank you.
Hi!
My Name is Mohan Rajaram, Thanks for your Post. I 'm interested in this work. I will submit the project ahead of time, I will finish the job better according to the guidance given, so I will present the best project overall. I'm interested in your project. Please send me a message so that we can discuss more.
Hello,
I can help you with your inventory tracking request since I am experienced Financial Reporting Analyst. You can find my professional experience details on my profile and contact me if you are interested.
Kind Regards,
Özlem
