Excel Consultant for Inventory Spreadsheet
Budget: $30 – $250 CAD
I'm in need of an experienced Excel consultant to design a custom spreadsheet tailored for handling inventory data. The primary functionality required is effective stock tracking to ensure accurate and up-to-date inventory management.
Key Requirements:
- Design a custom Excel spreadsheet for inventory data
- Implement robust stock tracking features
- Ensure the spreadsheet is user-friendly and efficient
Ideal Skills and Experience:
- Proficiency in Excel, including advanced functions and formulas
- Experience in designing spreadsheets for inventory management
- Strong attention to detail and ability to customize solutions based on specific needs
If you have the expertise to create a streamlined and effective inventory management tool in Excel, I look forward to your proposal.
I have about 800 customers that rent Mason bee homes from me, I have all their names in an Excel spreadsheet. I want to be able to enter the first 2 or 3 letters of their names and have the relevant names come up, then I want to be able to click on an empty cell beside their name a using a scanner enter the barcode information attached to the home. Every home would have a different barcode. The homes are returned to me 3 months later and I would like to be able to scan the barcodes and match it to the name so I can track who has returned
Key Requirements:
- Design a custom Excel spreadsheet for inventory data
- Implement robust stock tracking features
- Ensure the spreadsheet is user-friendly and efficient
Ideal Skills and Experience:
- Proficiency in Excel, including advanced functions and formulas
- Experience in designing spreadsheets for inventory management
- Strong attention to detail and ability to customize solutions based on specific needs
If you have the expertise to create a streamlined and effective inventory management tool in Excel, I look forward to your proposal.
I have about 800 customers that rent Mason bee homes from me, I have all their names in an Excel spreadsheet. I want to be able to enter the first 2 or 3 letters of their names and have the relevant names come up, then I want to be able to click on an empty cell beside their name a using a scanner enter the barcode information attached to the home. Every home would have a different barcode. The homes are returned to me 3 months later and I would like to be able to scan the barcodes and match it to the name so I can track who has returned