I will create an excel inventory and stock control spreadsheet
About this Gig
Do you need to organize your stock and stop losing track of your products?
I am a Mechanical Engineer with over 5 years of real experience in logistics, warehouses and inventory control. I will create a clear, easy-to-use Excel or Google Sheets spreadsheet to manage your inventory.
What I can include:
- Product list with codes, categories and prices
- Stock in and stock out records
- Automatic current stock calculation with formulas
- Low stock alerts
- Drop-down lists to avoid data entry errors
- Suppliers tab
- Monthly summary and charts (Premium)
Why work with me:
- Real experience managing warehouses, not just theory
- Clean, professional and easy-to-use format
- On-time delivery and clear communication
- Simple instructions so anyone can use the sheet
Note: I work with formulas and functions. This gig does not include VBA macros.
Please send me a message before ordering so I can understand your needs and recommend the best package.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Functions
•
Cleaning
•
Data validation
FAQ
Will the spreadsheet work in Excel and Google Sheets?
Yes. I can create it in Excel or Google Sheets. Just tell me which one you use before ordering.
What do you need from me to start?
A short description of your business, your product list (or an example), and what information you want to control. If you already have a sheet, you can send it.
Can you improve my existing spreadsheet?
Yes. Send me your file and I will review it and tell you which package fits best.
Do you include VBA macros?
No. I work with formulas, functions, drop-down lists and formatting, which is enough for most inventory needs.

