

You just described the basic functions of a database. People are building a databases in spreadsheets. That’s not a reason to keep using Excel, that’s a reason to have an intervention lol
Edit: this is halfway tongue in cheek. Trying to get office workers to use more and different tools partway through their careers is unfortunately unviable in many industries.

This is the real answer.