Building an information management system using Excel

[cercenazi]

Hello everyone, I am a total Excel noob

I work in an organization that stores data in multiple Excel sheets, The data entry is done directly on the Excel sheets which is slow and error-prone as it includes small details.
I want to structure the data in a database-like way as Excel sheets that are linked together with validation and constraints.
I want the users to be able to interact with this "database" using forms and not directly with the Excel sheets. I want to store those Excel sheets in SharePoint. I also want to build custom reports and views using those sheets.

Is this possible using Excel? if yes can you describe at a high level what I need to do and what resources I need to go to? if not can you suggest an alternative?

Note: we can't build an application or use Microsoft Access

Thanks.

 

[ranman256]

you can & should. Using excel for this is like hammering nails with a screwdriver.
Access IS the tool you want. It is available for everyone.

 

[cercenazi]

you can & should. Using excel for this is like hammering nails with a screwdriver.
Access IS the tool you want. It is available for everyone.

Our Microsoft licence doesn't include Access, that's why it's not possible to use it