- Extensive list of functions
- The famous VBA programming language built-in and an extensive list of methods, properties and objects exposed in the Excel Object Model
- Extensive and long standing use in public (it's over 30 years old)
- Burgeoning extensions into ETL, Data Mining and Data Analysis tools
- Every year since inception, a strong, smart development team
- Packaged as part of the ubiquitous Microsoft Office
In the 1980s there were so many spreadsheet products, but nearly all have fallen away. The only challengers left in my mind are G Suite Sheets (a cloud only solution) and Libre Office. Neither of which had macro recording.
This year, it changes. G Suite Sheets now has Macro Recording. I'm astonished - it must be really hard to do that in cloud based solution. Here's my first drive around the block.
The demo is simple. Have a range of cells on a sheet. Record the copying of that block to another, blank sheet.
It doesn't seem as easy as Excel. But it's pretty good.
And here's the recorded and edited macro with annotations in a G Suite Docs document