repeat after me. Excel is not a database.
Except that it is these days. They added PowerQuery back in 2010 and it can literally do almost everything SQL server can do. You create queries that load your source data (from almost anywhere and any format), do a ton of conversions, filters, table joins (left, right, full outer, etc), and processing on your data to get it exactly as you need it, then it stores it in a data model (database) in the file. You can even go far past the million row limit in a sheet.
Then, you tell it column relationships between all these tables in the data model. And build new queries based on those tables, or pivot tables to analyze, etc. And then, output your final data to a sheet or charts for people to look at.