[viraptor]

I'm not sure if you described usage or capabilities, but if the latter, these can be done in excel:

- named references - set a range name and you can use it in formulas

- functions - macros can export functions

- sql-like views - power query

It's still all pretty shit, but unless you need to support old versions or Mac Office, there are workarounds for some stuff.