If you really want to use Excel as a CRUD application. You have roughly three options, IMO:
1. Using data models and connections, which is the majority of the Data tab
2. Using list objects
3. Not using list objects
With data models, you can import tables from external sources, make queries...