The problems you mentioned are solved by Excel using tables, which are named, variable in size, and can be referenced by column names instead of addresses. Tab

The problems you mentioned are solved by Excel using tables, which are named, variable in size, and can be referenced by column names instead of addresses. Tables can also be joined and queried using Power Query. Excel is still 100x more powerful and sophisticated than Sheets is.