Excel Inventory Sheet format
Budget: ₹600 – ₹1,500 INR
I have a single workbook that holds our current inventory data. I need that data reorganised into two clearly labelled sheets, each grouped by stock level. Alongside the split, each sheet must show the average stock for its level so I can spot over- or under-stocked items at a glance.
You’ll be working inside Excel only. Please rely on native features—formulas, pivot tables or Power Query, whichever you prefer—so the result stays fully editable. Data validation rules already in the file must remain intact.
Deliverables
• Sheet 1 – items at or below the reorder threshold, plus a line (or cell) displaying the average stock for this low-level group.
• Sheet 2 – items above that threshold, again with the average stock figure.
• The updated workbook returned error-free and ready for immediate use.
Speed and accuracy are essential; the dataset is tidy but sizable, so I’m counting on strong Excel skills to turn this around quickly.
You’ll be working inside Excel only. Please rely on native features—formulas, pivot tables or Power Query, whichever you prefer—so the result stays fully editable. Data validation rules already in the file must remain intact.
Deliverables
• Sheet 1 – items at or below the reorder threshold, plus a line (or cell) displaying the average stock for this low-level group.
• Sheet 2 – items above that threshold, again with the average stock figure.
• The updated workbook returned error-free and ready for immediate use.
Speed and accuracy are essential; the dataset is tidy but sizable, so I’m counting on strong Excel skills to turn this around quickly.