I will create an excel equipment inventory and issue return tracker

Egypt

I speak Arabic, English

Engineer Operations Manager Systems Data Solutions

I turn messy operational data into clear, usable tools. I build Excel trackers for equipment and inventory, clean and reconcile Excel or CSV data with a full change log, and create editable PowerPoint...
About this Gig

For one person managing equipment in an office, workshop or small team: know who has each item and what is overdue.

I will build an Excel workbook that keeps your equipment, people and every issue/return in one place, and shows what is available, on loan, overdue or needs review.

What you get:

- Equipment and personnel registers with drop-down lists

- Issue & return log: one row per item, history is never overwritten

- Automatic status per item, overdue flags and a Checks sheet that lists duplicate IDs, unknown items, wrong dates and double issues

- Dashboard (cards in all packages, charts in Standard/Premium, site filter in Premium)

- Your data imported up to the package limit

- Short user guide

Arabic & English options available. Choose one workbook language; contact me before ordering if you need both.

Please send before ordering: your current file or column list, approximate counts, your Excel version and how you issue and return items.

Not included: macros/VBA, e-mail reminders, Google Sheets, live links to other systems, multi-user editing.

Built with AI-assisted tools, then reviewed and tested in Microsoft Excel 365.

Platform:

Excel

Development technology:

Excel

Expertise:

Formulas

•

Functions

•

Dashboard

•

Charts

•

Data validation

My Portfolio