The problem is that excel is a lot of things packed into a single application and the attempts I have seen at challenging it typically only consider one usage.
for some people, it is a tool to:
- just to format a table to be printed
- visualise and analyse large amount of data (pivots, chart)
- store data (like a database)
- make complex calculations (financial modelling or else), which can go from a quick, one off throw away calc to an established critical process
- automate tasks (VBA - more often that not with close to zero programming skills)
- just a convenient UI to edit data (I often use .xlsx as configuration files when a script requires lots of mapping to be maintained by end users)
I have seen lots of attempts that address one or two of those points. But all of them at once?
for some people, it is a tool to:
- just to format a table to be printed
- visualise and analyse large amount of data (pivots, chart)
- store data (like a database)
- make complex calculations (financial modelling or else), which can go from a quick, one off throw away calc to an established critical process
- automate tasks (VBA - more often that not with close to zero programming skills)
- just a convenient UI to edit data (I often use .xlsx as configuration files when a script requires lots of mapping to be maintained by end users)
I have seen lots of attempts that address one or two of those points. But all of them at once?