I will create an excel equipment inventory and issue return tracker

Sommige informatie wordt in het Engels weergegeven.

Egypte

Ik spreek Arabisch, Engels

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...
Over deze dienst

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

Ontwikkelingstechnologie:

Excel

Expertise:

Formules

•

Functies

•

Dashboard

•

Grafieken

•

Data validatie

Mijn portfolio