Excel Inventory Report Automation
Budget: ₹600 – ₹1,500 INR
I have a live inventory spreadsheet that needs to be polished and made useful today. The raw data is already exported; I just need you to enter the latest counts, tighten the formulas that calculate on-hand, committed, and reorder quantities, then transform the results into clear charts and a concise summary tab I can drop into our weekly meeting deck.
Here’s what finishing looks like:
• Update and validate the SKU, location, and quantity columns from the new CSV.
• Build or fix formulas that flag low stock, calculate days-of-supply, and show variance from last cycle.
• Generate an at-a-glance dashboard: pivot-driven tables plus bar/line charts that highlight fast-moving items and any stockouts.
• Produce a printable report sheet (one click to PDF) so my team can review counts without opening Excel.
I already have the file open in Microsoft 365, so real-time collaboration via OneDrive or SharePoint is ideal. If you’re quick with VLOOKUP/XLOOKUP, structured references, and basic chart design, this should be a straightforward afternoon sprint. Drop in, get it done, and I’ll sign off as soon as the numbers reconcile and the visuals look clean.
Here’s what finishing looks like:
• Update and validate the SKU, location, and quantity columns from the new CSV.
• Build or fix formulas that flag low stock, calculate days-of-supply, and show variance from last cycle.
• Generate an at-a-glance dashboard: pivot-driven tables plus bar/line charts that highlight fast-moving items and any stockouts.
• Produce a printable report sheet (one click to PDF) so my team can review counts without opening Excel.
I already have the file open in Microsoft 365, so real-time collaboration via OneDrive or SharePoint is ideal. If you’re quick with VLOOKUP/XLOOKUP, structured references, and basic chart design, this should be a straightforward afternoon sprint. Drop in, get it done, and I’ll sign off as soon as the numbers reconcile and the visuals look clean.